Обсуждение: PostgreSQL not working?
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
2009/4/21 Juan Jose De Leon <juandeleo@yahoo.com>: > pg_ctl: fatal: libreadline.so.5: open failed: No such file or directory > Killed Is readline installed or not? Is it in the LD_LIBRARY_PATH? -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm
Yes, value of LD_LIBRARY_PATH is as follows: :/usr/local/lib Readline files (including libreadline.so.5 are in that directory). Thanks. Juan. --- El lun 20-abr-09, Andrej <andrej.groups@gmail.com> escribió: > De: Andrej <andrej.groups@gmail.com> > Asunto: Re: [NOVICE] PostgreSQL not working? > A: "Juan Jose De Leon" <juandeleo@yahoo.com> > Cc: pgsql-novice@postgresql.org > Fecha: lunes, 20 abril, 2009, 7:53 am > 2009/4/21 Juan Jose De Leon <juandeleo@yahoo.com>: > > > pg_ctl: fatal: libreadline.so.5: open failed: No such > file or directory > > Killed > Is readline installed or not? Is it in the > LD_LIBRARY_PATH? > > > > -- > Please don't top post, and don't use HTML e-Mail :} > Make your quotes concise. > > http://www.american.edu/econ/notes/htmlmail.htm > ____________________________________________________________________________________ ¡Obtén la mejor experiencia en la web! Descarga gratis el nuevo Internet Explorer 8. http://downloads.yahoo.com/ieak8/?l=e1