Re: Why password authentication failed for user "postgres"?

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Fri, Jun 3, 2022 at 6:32 PM BeginnerC <chuxuec@xxxxxxxxxxx> 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!

The password you type should not be showing up as you type it, which is what you appear to be showing above.  Also, 'postgres' is a horrible password, you might as well configure 'trust' authentication if you are going to use that as a password.

Look in the db server's log file for a (possibly) more detailed error message.

Cheers,

Jeff