Set password in PostgreSQL

Question

I am trying to set new password in postgreSQL.But I am getting error like below.[root@localhost ~]# sudo -u postgres psql

 could not change directory to "/root"
 Welcome to psql 8.1.23, the PostgreSQL interactive terminal.
  Type:  \copyright for distribution terms
    \h for help with SQL commands
    \? for help with psql commands
    \g or terminate with semicolon to execute query
    \q to quit`postgres=# \password postgres
  Query buffer is empty.
  \p: extra argument "assword" ignored
  \p: extra argument "postgres" ignored`

score 1 · Answer 1 · answered Feb 26 '16 at 08:32

1

This works for me.ALTER USER postgres WITH ENCRYPTED PASSWORD 'password';

answered Feb 26 '16 at 08:32

snirali

139
1
4
11

score 0 · Answer 2 · answered Feb 26 '16 at 07:46

0

Try this? Link
Login to your database and use the ALTER USER Postgres WITH PASSWORD '<newpassword>'; command.

answered Feb 26 '16 at 07:46

Eli Berkowitz

299
3
12

score 0 · Answer 3 · answered Sep 23 '22 at 18:47

Highly recommended to avoid ever using the ALTER USER Postgres WITH PASSWORD... syntax as there is a possibility whatever password you submit will be saved forever in your on disk logs.

Whenever possible, the best way to do it is through an interactive psql CL like so:

psql=# \password user_name

If you cannot do that, consider using SCRAM-SHA-256 authentication and the method described here.

Set password in PostgreSQL

3 Answers3