Setup a PostgreSQL database

You create the user, the database, and then initialize it with the included script.

1. create the user and insert the preferred password:

   createuser --pwprompt greylite
   

2. create the database for this user:

   createdb --owner greylite greylite
   

3. initialize the database:

   psql -U greylite --file scripts/postgresql.sql greylite
   

Done.

Control variables

You will need the following environment variables for this database configuration:

DBRESOURCE="hostaddr=127.0.0.1 port=5432 dbname=greylite user=greylite password=yourpass"

See greylite controls for more information.