Обсуждение: Why password authentication failed for user "postgres"?

On Sat, 2022-06-04 at 06:32 +0800, BeginnerC wrote:
> Hello everyone,
> I am a newbie to the postgres,when I use the psql to connect to the
> postgres,a error message printed:
> These command list like this:
>
> psql -U postgres
> Password for user postgres:postgres
> postgreSQL: password authentication failed for user "postgres"
>
> How to solve this problem?
> Thanks in advance!

this may work...

switch user to postgres.
$ sudo su - postgres
login to postgres
$ psql 
reset the password for postgres
postgres-# \password

Hello everyone,

I am a newbie to the postgres,when I use the psql to connect to the postgres,a error message printed:

These command list like this:

psql -U postgres

Password for user postgres:postgres

postgreSQL: password authentication failed for user "postgres"

How to solve this problem?

Thanks in advance!

• Which OS are you working on?
• Can you show us your pg_hba.conf?

If you use -U with psql, the connection must not try to use method "peer" (which means "use the system user with this name", but also means "You must be logged in with the system user corresponding to the postgresql user"), but some kind of authorization, like md5, and use it with IP address. This might be difficult for the user postgres, who often has no password set in the database. If you really need to connect with user postgres and some password, you can set one using the method described by Reid Thompson.

Regards,

Frank