| From: | Richard Harper <drrwharper(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | server not starting |
| Date: | 2012-08-12 02:26:52 |
| Message-ID: | CAHr-pYGBMMy1=YNzZNP40Q4DJeF-aq7vovY-kAVQSEafS=huJA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Since I upgraded to 9.1, the server has not been starting. psql works, and
pg_ctl status indicates that no server is connected.
If I run the command: sudo -u postgres /user/lib/postgresql/9.1/bin/pg_ctl
start -D /usr/local/pgsql/data
it says the server is ready to accept connections.
The command sudo -u postgres /user/lib/postgresql/9.1/bin/pg_ctl status -D
/usr/local/pgsql/data
gives:
pg_ctl: server is running (PID:1751)
/usr/lib/postgresql/9.1/bin/postgres "-D" "/usr/local/pgsql/data"
However, netstat indicates no connection to port 5432, and I still cannot
connect.
I am unable to figure out where the LISTEN_ADDRESSES is assigned, perhaps
that is the problem. I am obviously new to administration.
Thanks for any help,
Dick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | umerasghar | 2012-08-12 03:43:00 | Re: server not starting |
| Previous Message | Craig James | 2012-08-11 11:26:06 | Re: JDBC keep alive issue |