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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
