Search Postgresql Archives

Re: psql: FATAL: Ident authentication failed for user "postgres"

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

 



Dan Joo wrote:
> Hi everyone,
> 
>  
> 
> I am having problems logging into psql as a non-‘postgres’ user.
> 
>  
> 
> */home/djoo[5:38pm]$ %psql kermit -U postgres*
> 
> *psql: FATAL:  Ident authentication failed for user "postgres"*

Sure there isn't a line like this:

local   all         postgres                          ident sameuser

uncommented?

$ cat /path/to/pg_hba.conf | grep -v '^#'

Normally the 'postgres' user is 'ident' only unless you remove (or
comment out) that particular line, then restart postgres.

-- 
Postgresql & php tutorials
http://www.designmagick.com/


[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