Create A Postgres Database

Connect to the main postgres database with a user that has create database privileges via:

psql -U user_name -d postgres

(Or, psql postgres if your setup for that)


CREATE DATABASE your_database_name;

The database is made from a clone of the template1 database. So, any changes made there will show up in your new database.


You can check what permissions users have with \du when logged into the database