Return to Answer

Post Timeline

Active reading.

Source Link

edited Sep 11, 2022 at 16:15

31.2k
22
111
134

useUse this:

\password

enterEnter the new password you want for that user and then confirm it. If you don't remember the password and you want to change it, you can log in as postgres"postgres" and then use this:

ALTER USER 'the username' WITH PASSWORD 'the new password';

use this:

\password

enter the new password you want for that user and then confirm it. If you don't remember the password and you want to change it, you can log in as postgres and then use this:

ALTER USER 'the username' WITH PASSWORD 'the new password';

Use this:

\password

Enter the new password you want for that user and then confirm it. If you don't remember the password and you want to change it, you can log in as "postgres" and then use this:

ALTER USER 'the username' WITH PASSWORD 'the new password';

Source Link

answered Feb 12, 2018 at 11:52

Chris Dare

use this:

\password

enter the new password you want for that user and then confirm it. If you don't remember the password and you want to change it, you can log in as postgres and then use this:

ALTER USER 'the username' WITH PASSWORD 'the new password';

Collectives™ on Stack Overflow