Postgres user

I’m documenting this because I always forget. To use psql (the postgresql command line tool) you will first need to log in as the postgres user. There is a nice tutorial here.

To change to the postgres user:

$ sudo -i -u postgres

Start psql:

$ psql

In one step:

$ sudo -u postgres psql