login psql - harvest login

$ sudo -u postgres psql postgres And, then in the psql shell. CREATE ROLE myuser LOGIN PASSWORD 'mypass'; CREATE DATABASE mydatabase WITH OWNER = myuser; Then you can login, $ psql -h localhost -d mydatabase -U myuser -p port If you don't know the port, you can always get it by running the following, as the postgres user, SHOW port; Or, champion slot login