Postgres Administration

postgres-admin.txt

# command line:
sudo -u postgres createuser --superuser username
sudo -u postgres createdb -O vagrant dbname

# enter shell
psql dbname username
# list users: 
\du
#list databases: 
\list
# exit shell: 
\q

# manaing roles (users)
CREATE USER username WITH PASSWORD 'password'
ALTER ROLE username WITH PASSWORD 'vagrant';
DROP ROLE username;

# WITH options
SUPERUSER | NOSUPERUSER 
CREATEDB | NOCREATEDB
CREATEROLE | NOCREATEROLE
CREATEUSER | NOCREATEUSER
PASSWORD 'password'

# managing databases
CREATE DATABASE dbname OWNER username;
DROP DATABASE IF EXISTS dbname;