This is an old revision of the document!

---

su - postgres
vacuumdb --all --full -v

su - postgres
psql template1
\l
\du

SELECT rolname FROM pg_roles;
 
CREATE USER USER WITH PASSWORD 'mypass';
GRANT ALL PRIVILEGES ON DATABASE template1 TO USER;
 
SELECT rolname FROM pg_roles;
GRANT postgres TO joe;