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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-12-29 16:24:35 | Re: Fatal error: role "postgres" no login! |
Previous Message | Raymond O'Donnell | 2007-12-29 13:57:35 | Re: Fatal error: role "postgres" no login! |