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
[EMAIL PROTECTED]
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to