Re: pgAdmin3 question

# lm_yho@yahoo.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