Postgres user does not exist?

macos, postgresql

Solution

`psql`: Logs me in with my default username

`psql -U postgres`: Logs me in as the postgres user

Sudo doesn't seem to be required for me.

I use Postgres.app for my OS X postgres database. It removed the headache of making sure the installation was working and the database server was launched properly. Check it out here: http://postgresapp.com

Edit: Credit to @Erwin Brandstetter for correcting my use of the arguments.

Problem

I have just installed Postgres and have been tinkering with it and various configurations for 1-2 hours. I am stuck on being unable to change to the postgres-user `$ su - postgres` yields the following error: `su: unknown login: postgres` `$ sudo -u postgres psql` yields the following error: `sudo: unknown user: postgres` These attempts are made as the normal user. Trying them as root has the exact same results. I have installed postgres via Homebrew on OS X, and I have read the instructions multple times.

Original source

Related problems