Creating a PostgreSQL database

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 😀

Advertisement