Create local Postgresql account

Question

On OS X 10.11.2, I've installed Postgres.app and I'm running the local server. I'm trying to create a local account with a username and password so that I can develop a Rails app locally. However, running the following command:

sudo -u postgres createuser -s {USERNAME}

I receive sudo: unknown user: postgres error.

Any suggestions as to why this error occurs and how to resolve this?

Pēteris Caune · Accepted Answer · 2016-01-29 14:58:26Z

2

sudo tells you there is no system user "postgres".

When you installed PostgreSQL, it should have created database user "postgres" and you can try use that:

$ psql -u postgres
postgres=# create user {username} password '{password}';

answered Jan 29, 2016 at 14:58

Pēteris Caune

45.5k6 gold badges64 silver badges84 bronze badges

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

Comments

Bhav · Accepted Answer · 2016-01-29 15:00:37Z

0

I managed to create a user with the following steps.

In the terminal:

createuser --superuser {USERNAME}

I then set a password in psql:

\password {USERNAME}

answered Jan 29, 2016 at 15:00

Bhav

2,2879 gold badges43 silver badges83 bronze badges

Collectives™ on Stack Overflow

Create local Postgresql account

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related