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

On Fri, Jun 3, 2022 at 6:32 PM BeginnerC <chuxuec(at)outlook(dot)com> 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