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

2022-06-05 Thread David G. Johnston
On Sun, Jun 5, 2022 at 4:06 PM Frank Finner wrote: > 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

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

2022-06-05 Thread Frank Finner
On 2022-06-04 00:32, 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

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

2022-06-04 Thread Jeff Janes
On Fri, Jun 3, 2022 at 6:32 PM 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

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

2022-06-03 Thread Reid Thompson
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

Why password authentication failed for user "postgres"?

2022-06-03 Thread BeginnerC
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