0

I installed postgresql 14 version on macOS Monterey, but I get this error when entering my password. enter image description here

I tried to edit pg_hba.conf, set 'trust' method instead 'scram-sha-256' but it's doesn't help

enter image description here

Improve this question
8
  • If you're running a default installation there is no role "postgres" by default anymore (but default database name is still postgres). It's actually your system user name. You can check the roles by running psql postgres and then in the psql console \du. Commented Sep 1, 2022 at 10:38
  • I'm sorry, I'm not quite clear, do you mean that the postgres user does not exist? what should I do in this case? Commented Sep 1, 2022 at 12:44
  • run psql - terminal-based front-end for Postgres. To change username in the pgadmin right click on "PostgreSQL 14" and change username from "Postgres" to your Mac username. Login without password. Commented Sep 1, 2022 at 13:11
  • You only changed the method for IPv4 connections, but you are trying to make an IPv6 connection. Commented Sep 1, 2022 at 14:13
  • @Revuimar, you are making a sweeping statement about the role postgres that is simply not true. It is created by default in many instances. If you are referring to a specific situation then you need to elaborate on that. Commented Sep 1, 2022 at 15:20
Related questions
5
Postgresql macports cannot connect problem
606
'password authentication failed for user "postgres"'
79
Postgres.app Could not start on port 5432
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.