Set Default Password For Postgres User For Psql

Posted By Weston Ganger

Im always forgetting how to do this. Dont set the password for the linux account postgres, instead set the password for the postgres user in psql.

sudo -u postgres psql postgres

# In psql prompt
\password postgres
# Enter your password

Now when you want to connect to psql use the following command

psql postgres -U postgres

See my other article on setting it up with the current user so your not messing around with the postgres user

Related External Links:

Article Topic:Software Development - Linux

Date:October 21, 2015