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?
1 Answer
sudo -u postgres
psql -c "create role NewRole with login password 'secret';"
