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

[Raymond O'Donnell <rod(at)iol(dot)ie>]

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

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------