Re: Cannot Connect To Db From Local Server

On Wed, Apr 18, 2012 at 10:12 PM, Rickard, David <
drickard1967(at)library(dot)ucla(dot)edu> wrote:

> We have a legacy PostgresSQL 7.3.4 db on Solaris which has recently (as
> in last 24 hours or so) begun refusing TCP/IP (JDBC) connections from the
> same server the db is on.****
>
> The db is up and running—psql connects; I can access the db via pgAdmin
> III from a PC; I can connect via JDBC from a PC.****
>
> However: any JDBC call (whether command-line app or web app) running on
> the db server fails with this message:****
>
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting TCP/IP
> connections.****
>
> And the postmaster log contains the following message:****
>
> FATAL: unsupported frontend protocol****
>
> Mind you… I am using the same JDBC jar (pg74.216.jdbc2.jar) and connection
> URL in code on my PC and the Solaris server.
>

Hmmm, are you 100% sure that a newer jdbc driver didn't get dropped onto
your classpath? You would get a different message if you had a
tcpip_socket, listen_addresses or pg_hba.conf problem.

--Scott

> ****
>
> Our pg_hba.conf file contains the following lines:****
>
> local all all
> password****
>
> host all all 127.0.0.1 255.255.255.255
> password****
>
> host all all 0.0.0.0 0.0.0.0
> password****
>
> And “tcpip_socket = true” is enabled in postgresql.conf.****
>
> ** **
>
> Any ideas?****
>
> ** **
>
> David Rickard****
>
> UCLA Library Information Technology****
>
> drickard1967(at)library(dot)ucla(dot)edu****
>
> 310.206.9780****
>
> ** **
>