Re: upgrade causes psql to not work

From: BJ Freeman <bjfree(at)free-man(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade causes psql to not work
Date: 2012-07-26 17:59:32
Message-ID: 50118584.7060705@free-man.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Merlin Moncure sent the following on 7/25/2012 9:42 AM:
> On Wed, Jul 25, 2012 at 11:42 AM, Merlin Moncure<mmoncure(at)gmail(dot)com> wrote:
>> On Wed, Jul 25, 2012 at 10:48 AM, BJ Freeman<bjfree(at)free-man(dot)net> wrote:
>>> I apologize, 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.
>>
>> yeah. probably the issue is that your postgresql.conf is changed.
>> you probably want to set listen_addresses to 'all' or something like
>> that.
>
> er, '*'
>
> merlin
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2012-07-26 18:04:46 Re: BI tools and postgresql
Previous Message Daniel Verite 2012-07-26 17:08:49 Re: Smaller data types use same disk space