Set Up Default Password for Postgres User

 Upon installing postgres, there is no password for Postgres User

This is the way to set up default password for Postgres User in Linux

  1. Open terminal
  2. Type: sudo -u postgres psql <-p portNo> eg sudo -u postgres psql -p 5433 or sudo -u postgres psql for default port 5432
  3. Type: postgres=# ALTER USER postgres PASSWORD '<your desired password>';
  4. Type: \q to exit postgres and return back to terminal login
DONE!

No comments:

Post a Comment

If you have any doubts, please let me know.

Regarding site Free Browser Tool (https://free-browser-tools.mohitkrgupta.dev) (discussion with google search AI)

Various discussions with Google Search AI regarding site  Free Browser Tool are as below: site free-browser-tools.mohitkrgupta.dev what doe...