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
---------------------------------------------------------------