One machine connects, the other doesn't??? - Mailing list pgsql-admin

From Jeff
Subject One machine connects, the other doesn't???
Date
Msg-id 3FA6F94D.9050601@telus.net
Whole thread Raw
Responses Re: One machine connects, the other doesn't???  (<mallah@trade-india.com>)
Re: One machine connects, the other doesn't???  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-admin by date:

Previous
From: "Jean Huveneers"
Date:
Subject: Re: Application monitoring
Next
From: "David F. Skoll"
Date:
Subject: Forcing pg_dump NOT to use "INSERT..."