Postgres is my favorite RDBMS, but I always forget how to setup a database. So this is mostly to remind myself 🙂
createuser --echo --no-createdb --encrypted --pwprompt --no-createrole \ --no-superuser [ROLENAME] createdb --echo --owner=[ROLENAME] [DBNAME]
Which echoes something like:
CREATE ROLE [ROLENAME] ENCRYPTED PASSWORD '[encrypted-password]' \ NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN; CREATE DATABASE [DBNAME] OWNER [ROLENAME];
To connect use:
psql [DBNAME] [USERNAME]
That’s all 😀