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