From: | umerasghar(at)gmail(dot)com |
---|---|
To: | "Richard Harper" <drrwharper(at)gmail(dot)com>, pgsql-admin-owner(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: server not starting |
Date: | 2012-08-12 03:43:00 |
Message-ID: | 1399250722-1344742982-cardhu_decombobulator_blackberry.rim.net-1727298127-@b3.c10.bise7.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Did you allow ip addresses in pg_hba.conf. Perhaps you might need to allow IP's in that file.
Sent from my BlackBerry® Smartphone provided by Ufone
-----Original Message-----
From: Richard Harper <drrwharper(at)gmail(dot)com>
Sender: pgsql-admin-owner(at)postgresql(dot)orgDate: Sat, 11 Aug 2012 22:26:52
To: <pgsql-admin(at)postgresql(dot)org>
Subject: [ADMIN] server not starting
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 | Matheus de Oliveira | 2012-08-12 12:38:37 | Re: server not starting |
Previous Message | Richard Harper | 2012-08-12 02:26:52 | server not starting |