Re: postgresql on RH8 different from RH7.1?

[John Dalbec]

Date: Tue, 21 Jan 2003 16:23:23 -0600
From: "Kall, Bruce A." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: postgresql on RH8 different from RH7.1?
Reply-To: [EMAIL PROTECTED]

I just upgraded to RH8 (from RH7.1).  When I try any psql commands
with syntax like:

psql -U postgres -l

I get

psql: FATAL 1: IDENT authentication failed for user 'postgres'

But if I do a psql -l (after doing a su - postgres)

it returns that I have two databases , template0 and template1
both owned by postgres.

What am I missing?

/var/lib/pgsql/data/pg_hba.conf is now configured to do IDENT authentication on UNIX socket connections. To fix this the "right" way you should add a line to /var/lib/pgsql/data/pg_ident.conf containing
<map name> <your user name> postgres
and then change "sameuser" to your <map name> on the "local all ident" line in pg_hba.conf. It doesn't matter what you call the map as long as you're consistent.
John

Thanks,

_______________________________________________
Seawolf-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/seawolf-list