Skip site navigation (1) Skip section navigation (2)

Re: Fatal error: role "postgres" no login!

From: Salvator*eL*arosa <s_larosa(at)libero(dot)it>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Fatal error: role "postgres" no login!
Date: 2007-12-29 15:37:25
Message-ID: 14538577.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgadmin-support


Raymond O'Donnell wrote:
> 
> On 29/12/2007 12:24, Salvator*eL*arosa wrote:
>> ERROR CONNECTING TO THE SERVER:
>> FATAL: role"postgres" is not permitted to log in
> 
> Have you a line in your server's pg_hba.conf file allowing remote 
> connections by the role "postgres"? Something like:
> 
>      host   all   postgres     192.168.1.25/24      md5
> 
> The configuration is well documented in the file itself, and also in the 
> PostgreSQL docs under "Client Authentication" (if memory serves).
> 
> HTH
> 
> 

My pg_hba.conf is:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust
                                                                   
the same error get me it......

-- 
View this message in context: http://www.nabble.com/Fatal-error%3A-role-%22postgres%22-no-login%21-tp14537100p14538577.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


In response to

Responses

pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2007-12-29 16:24:35
Subject: Re: Fatal error: role "postgres" no login!
Previous:From: Raymond O'DonnellDate: 2007-12-29 13:57:35
Subject: Re: Fatal error: role "postgres" no login!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group