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 )
begin:vcard
fn:louis
n:gonzales;louis
email;internet:louis.gonzales@xxxxxxxxxxxxxx
tel;home:248.943.0144
tel;cell:248.943.0144
x-mozilla-html:TRUE
version:2.1
end:vcard
