Re: postgresql on RH8 different from RH7.1?

> 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,
> 
>