| 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: | Whole Thread | Raw Message | 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
>
| 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 |