Can't connect to server

Hi,

As I can see in the error message :
"localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"."
Pgadmin4 try to connect via the loopback in IPv6 (::1) and fail for postgres user.
Have a look to pg_hba.conf, the file which describes access to postgres cluster.

Le 18 mars 2023 07:10:47 GMT+01:00, "Wu, Abigaile" <wuching3@msu.edu> a écrit :

On 3/17/23 23:10, Wu, Abigaile wrote:

I am writing to seek your assistance with a problem I am facing while
using pgAdmin4. After downloading the PostgreSQL 15, I downloaded the
latest version of Pgadmin 4 and then I click the server and choose
PostgreSQL 15. Whenever I try to log in to the server after entering my
password, I receive the following error message:

"Connection to server at "localhost"(::1), port 5432 failed: could not
initiate GSSAPI security context: The operation or option is not
available: credential handle connection to server at "localhost" (::1),
port 5432 failed: FATAL: password authentication failed for user
"postgres"."

Could you please advise me on how to resolve this issue? I would be
grateful if you could provide me with any instructions or guidance on
what steps I can take to fix this problem and gain access to the server.

OS and version?

Where did you install Postgres 15 from?

Where did you install pgAdmin4 from?

What are the contents of your pg_hba.conf file?

Thank you for your time and assistance. I look forward to hearing from
you soon.

*Abigaile Wu*

Pronouns: She/Her/Hers

*Full-Time MBA Candidate 2023*

*Graduate Assistant - Admission Team
*

Broad College of Business

Michigan State University

*C*: (517) 329 - 5793

*E*: wuching3@msu.edu

*WHO WILL MAKE BUSINESS HAPPEN?*

*SPARTANS WILL.*

--
Adrian Klaver
adrian.klaver@aklaver.com

On Sat, Mar 18, 2023 at 2:11 AM Wu, Abigaile <wuching3@msu.edu> wrote:

I am writing to seek your assistance with a problem I am facing while
using pgAdmin4. After downloading the PostgreSQL 15, I downloaded the
latest version of Pgadmin 4 and then I click the server and choose
PostgreSQL 15. Whenever I try to log in to the server after entering my
password, I receive the following error message:

"Connection to server at "localhost"(::1), port 5432 failed: could not
initiate GSSAPI security context: The operation or option is not available:
credential handle

This is probably just a nuisance message. It thought it might be able to
authenticate via Kerberos and so tried that one first, but discovered it
couldn't. Unless you know that that is what you were trying to do, you can
ignore it.

connection to server at "localhost" (::1), port 5432 failed: FATAL:
password authentication failed for user "postgres"."

Look in the database server's log files to see if there are more details
about this authentication error. When you set up the system, is "postgres"
the name you picked for the admin user? That is the default and most
common, but you could have changed it if you wanted to.

Cheers,

Jeff