Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working - Mailing list pgsql-general

From Stephen Frost
Subject Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working
Date
Msg-id Zd9pSzNUZyJ64U3a@tamriel.snowman.net
Whole thread Raw
In response to RE: Unable to get PostgreSQL 15 with Kerberos (GSS) working  (Matthew Dennison <mail@matty-uk.co.uk>)
Responses Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working  (Matthew Dennison <mail@matty-uk.co.uk>)
List pgsql-general
Greetings,

* Matthew Dennison (mail@matty-uk.co.uk) wrote:
> I have subsequence discovered that the psql command running from remote Windows (server/client) and RHEL8 works as
expectedusing GSS.  PGAdmin4 also works via Kerberos (was on my list of things to get working).  It's just locally on
theserver psql will not work to postgresql running on the same server. 
>
> I really don't get it, but have decided I can live without it working on the server.

Perhaps I wasn't clear- it's not going to work if you do:

psql -h localhost

Instead, try doing:

psql -h hostname.mydomain.net -U postgres -d postgres

Basically, Kerberos isn't really set up to work when the host you're
connecting to is named 'localhost' because the name of the host is how
you figure out what ticket to acquire from the KDC.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Sasmit Utkarsh
Date:
Subject: Re: Need Assistance: Command to display procedures does not work
Next
From: Adrian Klaver
Date:
Subject: Re: Need Assistance: Command to display procedures does not work