From: Lou Picciano <loupicciano@comcast.net>
To: pgsql-admin@postgresql.org
To: pgsql-admin-owner@postgresql.org
Subject: Re: server not starting
Date: Sun, 12 Aug 2012 13:40:04 +0000 (UTC)
Message-ID: <118861044.449769.1344778804737.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> (raw)
In-Reply-To: <963367405.449701.1344778681227.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
Also, in your postgresql.conf file, be sure you have LISTEN_ADDRESSES set to '*' - for testing, at least.
You sure server is running? What does $ ps -af | grep postgres tell you?
Do you have any useful output in PG's logs? Even a failed attempt, if it's traversing your network, will usually be logged (again, postgresql.conf must be set to log connections)
Can you connect using psql from the _same_ machine, using a socket connection?
Lou Picciano
----- Forwarded Message -----
From: umerasghar@gmail.com
To: "Richard Harper" <drrwharper@gmail.com>, pgsql-admin-owner@postgresql.org, pgsql-admin@postgresql.org
Sent: Saturday, August 11, 2012 11:43:00 PM
Subject: Re: [ADMIN] server not starting
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@gmail.com>
Sender: pgsql-admin-owner@postgresql.org
Date: Sat, 11 Aug 2012 22:26:52 -0400
To: <pgsql-admin@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: loupicciano@comcast.net, pgsql-admin-owner@postgresql.org
Subject: Re: server not starting
In-Reply-To: <118861044.449769.1344778804737.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox