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

On 29/12/2007 15:37, Salvator*eL*arosa wrote:

> 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

There's your problem - if you're trying to connect to the database from 
a different machine, then you need to add another "host" line to allow it.

What you have here looks like the default pg_hba.conf that's created on 
installation - you haven't edited it at all, and so it's only allowing 
connections from the machine on which Postgres is running.

If you want to allow user "postgres" to connect to all databases from, 
say, 192.168.1.25 with a netmask of 255.255.255.0, you need to add:
  host    all    postgres    192.168.1.25/24    md5

PgAdmin (or any other client) should then prompt for the password for 
user "postgres", and the password will be md5-encrypted before being 
passed over the wire.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------