Re: server not starting

[umerasghar@xxxxxxxxx]

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

---

From: Richard Harper <drrwharper@xxxxxxxxx>

Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

Date: Sat, 11 Aug 2012 22:26:52 -0400

To: <pgsql-admin@xxxxxxxxxxxxxx>

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