Re: upgrade causes psql to not work

From: BJ Freeman <bjfree(at)free-man(dot)net>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: upgrade causes psql to not work
Date: 2012-07-25 15:48:26
Message-ID: 5010154A.9060309@free-man.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Merlin Moncure sent the following on 7/25/2012 8:16 AM:
> On Wed, Jul 25, 2012 at 9:57 AM, 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
>
> well, your server is not running (you can confirm this with ps axf).
> this is not an issue with pg_hba.conf.
>
> what happens when you try to launch the service manually?
>
> merlin
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message McGehee, Robert 2012-07-25 16:09:17 Re: Smaller data types use same disk space
Previous Message Merlin Moncure 2012-07-25 15:16:50 Re: upgrade causes psql to not work