Re: 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 )