Skip site navigation (1) Skip section navigation (2)

upgrade causes psql to not work

From: BJ Freeman <bjfree(at)free-man(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: upgrade causes psql to not work
Date: 2012-07-26 19:40:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
[root(at)main jdbc]# psql -h localhost -U gameserver 

psql: could not connect to server: Connection refused
         Is the server running on host "localhost" and accepting
         TCP/IP connections on port 5432?

I notice there is no localhost and th has /32 added.
I can not add a localhost to the allowed hosts

psql is running
if I do
[root(at)main jdbc]# psql  -U gameserver
with out defining the host, it works.

I believe it is using Unix pipes instead of TCP
I also can manage the psql server through webmin.

I looked on the
and could not find any docs on the jdbc string to use my old one with
localhost and do not work any more.
here is the conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all trust
# IPv6 local connections:
host all all ::1/128 trust
host all all trust
host all all trust


pgsql-jdbc by date

Next:From: Dave CramerDate: 2012-07-26 19:51:12
Subject: Re: upgrade causes psql to not work
Previous:From: Radim KolarDate: 2012-07-22 14:55:51
Subject: Re: not fetching all query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group