Re: pgAdmin3 question

# lm_yho(at)yahoo(dot)com / 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