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 20:27:48
Message-ID: CADK3HHLuyrJnw=WdBZusnfZs4s+Y_R86y-FoBUTHW0s2-qizcQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
OK, so there is your problem. It is only listening on 69.94.133.32

I usually set listen_address = '*'

Dave Cramer

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


On Thu, Jul 26, 2012 at 4:02 PM, BJ Freeman <bjfree(at)free-man(dot)net> wrote:
> Dave
> sorry was not subscribe before i sent this, I am now
>
>> netstat -nlp | grep 5432
> tcp        0      0 69.94.133.32:5432  0.0.0.0:*             LISTEN
> 2699/postmaster
>
> unix  2      [ ACC ]     STREAM     LISTENING     9964   2699/postmaster
> /tmp/.s.PGSQL.5432
>
>
> BJ Freeman sent the following on 7/26/2012 12:40 PM:
>
>> 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: Brady MathisDate: 2012-07-27 19:46:20
Subject: Opening view that uses a function - empty column
Previous:From: BJ FreemanDate: 2012-07-26 20:02:05
Subject: Re: upgrade causes psql to not work

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