hi,
I am not sure if this is a bug.
My PG_HBA.CONF
----------------------------
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 192.168.0.0/16 trust
hostssl dbm all 192.168.200.201 255.255.255.255 md5
int ret=3DPQconnectdb("hostaddr=3D192.168.200.10 dbname=3Ddbm user=3Dpostgr=
es
sslmode=3Dprefer");
' ret' prints -1.
Now when I change the above function to one with sslmode=3Dallow, the
connection is established and query runs.
I do have (ssl=3Dtrue) in postgresql.conf and have tested the
certificates and they are working right. I also restart the postmaster
after every change in postgresql.conf and pg_hba.conf.
I would prefer the connections are SSL and hence would like to use the
default "prefer" sslmode.
vish