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

Re: upgrade causes psql to not work

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: BJ Freeman <bjfree(at)free-man(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: upgrade causes psql to not work
Date: 2012-07-26 19:51:12
Message-ID: CADK3HHKj-KJ6Uc2FGz8D1pTs2xuL-jOMA4DyXPqrut4jKF6FxA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Check in postgresql.conf to make sure it is listening on the tcpip port

listen_address='...

netstat -nlp | grep 5432 will tell you for sure

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Thu, Jul 26, 2012 at 3:40 PM, BJ Freeman <bjfree(at)free-man(dot)net> wrote:
> did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
> console:
> [root(at)main jdbc]# psql -h localhost -U gameserver
> passwordfromentityengine.xml
>
> 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 127.0.0.1 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
>  passwordfromentityengine.xml
> 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 http://jdbc.postgresql.org/
> and could not find any docs on the jdbc string to use my old one with
> localhost and 127.0.0.1 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 127.0.0.1/32 trust
> # IPv6 local connections:
> host all all ::1/128 trust
> host all all 127.0.0.1 255.255.255.255 trust
> host all all 0.0.0.0 0.0.0.0 trust
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
>
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

In response to

pgsql-jdbc by date

Next:From: BJ FreemanDate: 2012-07-26 20:02:05
Subject: Re: upgrade causes psql to not work
Previous:From: BJ FreemanDate: 2012-07-26 19:40:07
Subject: upgrade causes psql to not work

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