One machine connects, the other doesn't???

From: Jeff <jeffroberts(at)telus(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: One machine connects, the other doesn't???
Date: 2003-11-04 00:56:45
Message-ID: 3FA6F94D.9050601@telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I have postgresql 7.2.2-1 on "BACKEND".

If I use "Shop"(192.168.24.5) I can connect using the command:

psql mydatabase -h BACKEND -U ownerofmydatabase

I am asked for the password and upon giving it all is well.

BUT.

If I use "Office"(192.168.24.4) and I try the same thing:

psql mydatabase -h BACKEND -U ownerofmydatabase

I get:

psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user
ownerofmydatabase, database mydatabase

My pg_hba.conf file has two lines

local all trust
host all 192.168.24.0 255.255.255.0 password

Any ideas???

Jeff Roberts

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Lane 2003-11-04 01:19:33 Application monitoring
Previous Message Thierry Missimilly 2003-11-03 14:28:08 Re: Postgres client/server connection