"Stuart Grimshaw" <stuart@smgsys.fsnet.co.uk> writes:
> I'm having a problem connecting to my Postgres server with ODBC.
> When I try and connect I get the error :
> Could not connect to the server;
> Could not connect to remote socket
> I'm using Postgres v7.0, and I've allowed my local network
> (10.0.0.0/255.0.0.0) access through pg_hba.conf with :
> host all 10.0.0.0 255.0.0.0 trust
> the IP of the machine I'm connecting from is 10.0.0.2, so that's covered.
That pg_hba.conf entry looks OK, but I suspect that you are not getting
as far as having the postmaster consult that file. Looking at the code
of our ODBC driver, I see that the error message "Could not connect to
remote socket." is issued in only one place, namely if the connect()
kernel call fails. That means that you are unable to open a channel to
the postmaster at all, let alone try to be authenticated as an allowed
host/user. I suspect network-level problems, or possibly specification
of the wrong port number for the postmaster (though you say you checked
that).
Unfortunately the ODBC code neglects to notice exactly why the connect()
call failed --- it'd be mighty useful here to know what errno code the
kernel returned. I'd suggest trying it with a libpq-based client,
which will include the kernel error code in its error message in this
situation, or else altering the ODBC code to print out errno when it
gets this failure. That'd give us something more to go on.
regards, tom lane