Search Postgresql Archives

Re: pgAdmin3 question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# lm_yho@xxxxxxxxx / 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux