Skip site navigation (1) Skip section navigation (2)

PostgreSQL not working?

From: Juan Jose De Leon <juandeleo(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL not working?
Date: 2009-04-20 19:27:42
Message-ID: 306374.86744.qm@web31507.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi, I'm currently having a problem with my PostgreSQL, i'm running a DSpace application working under Solaris OS.
Everything was fine, but I began to receive repeatedly the following error messages to my email:

org.postgresql.util.PSQLException: Connection refused.
Check that the hostname and port are correct and that the postmaster is
accepting TCP/IP connections.

So I've connected to the server and tried to run the postgres console, but I can't get connected by the following error:

psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Then I tried to check if the service is running with pg_ctl status command and I've received the following error:

pg_ctl: could not open PID file "/usr/local/pgsql/data/postmaster.pid": Permission denied

And if I try to do the same after sudo root for avoiding the Permission denied problem, then I get that:

pg_ctl: fatal: libreadline.so.5: open failed: No such file or directory
Killed

I just don't know what is throwing me this error and how could I fix it. If any help, I would appreciate it.
Thanks a lot.

Juan.



      ____________________________________________________________________________________
¡Obtén la mejor experiencia en la web!
Descarga gratis el nuevo Internet Explorer 8. 
http://downloads.yahoo.com/ieak8/?l=e1

Responses

pgsql-novice by date

Next:From: AndrejDate: 2009-04-20 19:53:14
Subject: Re: PostgreSQL not working?
Previous:From: Jasen BettsDate: 2009-04-19 11:08:47
Subject: Re: Time-based trigger/procedure

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