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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Salvator*eL*arosa <s_larosa(at)libero(dot)it>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Fatal error: role "postgres" no login!
Date: 2007-12-29 16:24:35
Message-ID: 477674C3.3070104@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)iol(dot)ie
---------------------------------------------------------------

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Salvator*eL*arosa 2007-12-29 17:48:16 Re: Fatal error: role "postgres" no login!
Previous Message Salvator*eL*arosa 2007-12-29 15:37:25 Re: Fatal error: role "postgres" no login!