"sudo: unknown user: postgres" when trying to create postgres user

Question

I'm using Mac 10.9.5 and PostgreSQL 9.3.4. I'm following instructions for installing a third-party software package (Instructure Canvas) on my local machine) and the instructions say to execute:

sudo -u postgres createuser $USER
sudo -u postgres psql -c "alter user $USER with superuser" postgres

but upon executing the first command, I get the error

davea$ sudo -u postgres createuser $USER
sudo: unknown user: postgres

Other posts seemed to indicate I needed to prepend a "_" to my "postgres" user, but upon doing so, i get this error ...

davea$ sudo -u _postgres createuser $USER
createuser: could not connect to database postgres: FATAL:  role "_postgres" does not exist

Any ideas what I need to do to get this to work properly?

Craig Ringer · Accepted Answer · 2015-02-06 06:20:45Z

2

It looks like whatever you installed has a system user named _postgres and a PostgreSQL user named postgres. Fun!

Try:

sudo -u _postgres createuser -U postgres myusername

(The numerous messy, conflicting and incompatible PostgreSQL installs used on OS X are a nightmare, argh).

answered Feb 6, 2015 at 6:20

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

"sudo: unknown user: postgres" when trying to create postgres user

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related