postgres createuser with password from terminal

Question

I'm using vagrant to setup a new Ubuntu machine. With provisioning I'm in the need to create a new postgres user. Currently I'm using:

sudo su postgres
createuser -P myuser

Unfortunately provisioning fails because a prompt needs to be filled with password (-P flag).

Is there a way to pass the password to createuser like createuser myuser --password test or echo test | createuser -P myuser?

Andomar · Accepted Answer · 2017-02-23 15:21:37Z

20

sudo -u postgres
psql -c "create role NewRole with login password 'secret';"

answered Feb 23, 2017 at 15:21

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

4 Comments

Anatol Over a year ago

thanks! my problem is the db does not exist yet. is it possible to create the db and in this step also the user and password like createdb -E 'utf-8' -l en_US.utf8 -O testDB -T template0 AND create role NewRole with login password 'secret

Andomar Over a year ago

Sure? Just run createdb before calling psql to create a role.

TheRealChx101 Over a year ago

What privileges does this assign to the user?

fumiyas Oct 3 at 8:55

Unsafe. ps(1) (and so on) disclose secret in process list.

Collectives™ on Stack Overflow

postgres createuser with password from terminal

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related