8.0 Client can't connect to 7.3 server?

Jussi Saarinen wrote:

I have following environment:

Server1, rh9, ip:192.168.1.10:
postgresql-7.3.4-3.rhl9
postgresql-libs-7.3.4-3.rhl9
postgresql-server-7.3.4-3.rhl9
postgresql-jdbc-7.3.4-3.rhl9

Server2, fc4, ip:192.168.1.11:
postgresql-libs-8.0.7-1.FC4.1
postgresql-8.0.7-1.FC4.1
postgresql-server-8.0.7-1.FC4.1
postgresql-jdbc-8.0.7-1.FC4.1
postgresql-contrib-8.0.7-1.FC4.1

I can't connect to server1 (7.3.4) using client (8.0.7) at server2.
I just get error:
psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe,
database template1

Uncommented lines at server1's pg_hba.conf (postgresql service is
restarted after every change):
local all all trust trust
host all all 192.168.1.11 255.255.255.255 trust

Server1 also have line:
tcpip_socket = true
in postgresql.conf

Any ideas what's wrong?

Two things come to mind:
1) do you have a defined postgresql user "joe" ?
2) 192.168.1.11/32 (without looking it up, I'm not sure if you can
specify the subnetmask, as an alternative to the /DecimalNumber notation)
This is certainly only an issue with the entry in pg_hba.conf, on the
server to be contacted, just missing the correct configuration.

Remember OS user "joe" != postgresql user "joe"
postgresql user "joe" must have been granted access to the database
instance you're attempting to connect to, then you can have an entry like:

host all all 192.168.1.1/32 trust ( where postgresql user "joe"
would be implied )

Jussi Saarinen <jms@iki.fi> writes:

I can't connect to server1 (7.3.4) using client (8.0.7) at server2.
I just get error:
psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe,
database template1

Uncommented lines at server1's pg_hba.conf (postgresql service is
restarted after every change):
local all all trust trust
host all all 192.168.1.11 255.255.255.255 trust

That error is not possible with this pg_hba.conf file. You're probably
editing the wrong conf file, or possibly restarting the wrong server.

regards, tom lane

On Wed, Mar 08, 2006 at 03:03:22PM -0500, Louis Gonzales wrote:

Two things come to mind:
1) do you have a defined postgresql user "joe" ?
2) 192.168.1.11/32 (without looking it up, I'm not sure if you can
specify the subnetmask, as an alternative to the /DecimalNumber notation)
This is certainly only an issue with the entry in pg_hba.conf, on the
server to be contacted, just missing the correct configuration.

Remember OS user "joe" != postgresql user "joe"
postgresql user "joe" must have been granted access to the database
instance you're attempting to connect to, then you can have an entry like:

host all all 192.168.1.1/32 trust ( where postgresql user "joe"
would be implied )

Thanks Louis!

Problem was in pg_hba.conf as error message suggested ;)
Servers are now in different subnets and my configuration was
out of date. Sorry.

--
-jussi

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.