How to change Porstgresql default password

  1. Switch to user root
pg$ su -

Login to psql using the postgres database login role to connect to the postgres database.

cd /data
psql postgres postgres

Enter the \ password command to change the passwords of the three login roles.
The syntax for the \ password command is \ password .

For example, to change the sde password, enter:

\password sde

You will be prompted for a new password. Repeat the same steps for the owner and postgres users, with a strong unique password for each.

To exit psql, enter \ q.

Similar Posts:


How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Scroll to Top