Re: upgrade causes psql to not work

On Wed, Jul 25, 2012 at 9:57 AM, BJ Freeman <bjfree@free-man.net> wrote:
> did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
> console:
> [root@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