Postgres Pro
Downloads
Home   >   mailing lists

8.0 Client can't connect to 7.3 server? - Mailing list pgsql-general

From Jussi Saarinen
Subject 8.0 Client can't connect to 7.3 server?
Date
Msg-id 20060308101505.GA8168@jms.gotdns.org
Whole thread Raw
Responses Re: 8.0 Client can't connect to 7.3 server?  (Louis Gonzales <louis.gonzales@linuxlouis.net>)
Re: 8.0 Client can't connect to 7.3 server?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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?

--
-jussi


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

pgsql-general by date:

Previous
From: "Paul Newman"
Date:
Subject: Triggers and Multiple Schemas.
Next
From: "Nik"
Date:
Subject: Out of memory error on pg_restore