Sarathlal N

Add / change default user password in PostgreSQL

In most Unix distributions, the default Postgres user neither requires nor uses a password for authentication. But if you like to set a password for the user, you can follow the below steps.

Login to CLI as the default user

sudo -u postgres psql

Change password

ALTER USER postgres PASSWORD 'myPassword';

Recent Posts

  1. Automating Release Generation with GitHub Actions
  2. WP CLI Commands to Bulk Delete Entries in WordPress Database
  3. Split a Single CSV File into Multiple Files Using the Split Command - Bash
  4. Migrating code repo from BitBucket to GitHub
  5. Streamlining Development - Our Journey with Git, Bitbucket, and Jira

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.