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
