- 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:
- postgresql: how to reset forgotten postgres password
- how to install PostgreSQL 12 on Ubuntu / Debian 10,11
- postresql: move data directory to another location
- how to restore postgreSQL database with template using pg_dump
- postgresql: Could not open file “pg_clog/0000”: No such file or directory
422