How to change your password securely in PostgreSQL database?
meda Changed status to publish 16/07/2022
We can use the ‘\password’ command on PSQL command-line tool for changing our password securely.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | Example: Connect to your database through PSQL scripting tool and do the password change.Server [localhost]:Database [postgres]:Port [5432]:Username [postgres]:Password for user postgres:psql (13.5)WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details.Type "help" for help. postgres=# \passwordEnter new password:Enter it again:postgres=# |
meda Changed status to publish 05/03/2022