# [EMAIL PROTECTED] / 2006-04-07 14:31:04 -0700:
> A further question: we are using Debian system. So when we leave the
> 'Address' box
> blank (on the Add Server page of pgAdmin), according to the help file, it
> will go to
> use the default Postgresql socket on the local machine.
> We actually have a line as 'local all all ident sameuser' in the
> pg_hba.conf
> file. But when I tried, pgAdmin couldn't log the user in and shows "Ident
> Authentication Failed". Then I modified the line pg_hba.conf file to 'local
> all all
> ident', and aaded a map line in the pg_ident.conf file to map the new user
> to user
> 'postgres'. Still not work.
Did you instruct postmaster to reread the config files?
http://www.postgresql.org/docs/8.1/static/client-authentication.html#AUTH-PG-HBA-CONF
The pg_hba.conf file is read on start-up and when the main server
process (postmaster) receives a SIGHUP signal. If you edit the file
on an active system, you will need to signal the postmaster (using
pg_ctl reload or kill -HUP) to make it re-read the file.
http://www.postgresql.org/docs/8.1/static/auth-methods.html#AUTH-IDENT
The pg_ident.conf file is read on start-up and when the main server
process (postmaster) receives a SIGHUP signal. If you edit the file
on an active system, you will need to signal the postmaster (using
pg_ctl reload or kill -HUP) to make it re-read the file.
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
