Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <loupicciano@comcast.net>) id 1T0YOn-00081m-Hg
	for pgsql-admin@postgresql.org; Sun, 12 Aug 2012 13:40:09 +0000
Received: from qmta03.westchester.pa.mail.comcast.net ([76.96.62.32])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <loupicciano@comcast.net>) id 1T0YOi-0002FY-RT
	for pgsql-admin@postgresql.org; Sun, 12 Aug 2012 13:40:08 +0000
Received: from omta17.westchester.pa.mail.comcast.net ([76.96.62.89])
	by qmta03.westchester.pa.mail.comcast.net with comcast
	id lmua1j0031vXlb853pg78q; Sun, 12 Aug 2012 13:40:07 +0000
Received: from sz0093.wc.mail.comcast.net ([68.87.26.138])
	by omta17.westchester.pa.mail.comcast.net with comcast
	id lpg91j00f2ymm843dpg9PK; Sun, 12 Aug 2012 13:40:09 +0000
Date: Sun, 12 Aug 2012 13:40:04 +0000 (UTC)
From: Lou Picciano <loupicciano@comcast.net>
To: pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org
Message-ID: 
 <118861044.449769.1344778804737.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
In-Reply-To: 
 <963367405.449701.1344778681227.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
Subject: Re: server not starting
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_449768_1423685865.1344778804720"
X-Originating-IP: [::ffff:76.117.178.80]
X-Mailer: Zimbra 6.0.13_GA_2944 (ZimbraWebClient - SAF3 (Mac)/6.0.13_GA_2944)
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201208/82
X-Sequence-Number: 39903

------=_Part_449768_1423685865.1344778804720
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


Also, in your postgresql.conf file, be sure you have LISTEN_ADDRESSES set t=
o '*' - for testing, at least.=20


You sure server is running? What does $ ps -af | grep postgres tell you?=20


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 mus=
t be set to log connections)=20


Can you connect using psql from the _same_ machine, using a socket connecti=
on?=20


Lou Picciano=20

----- Forwarded Message -----
From: umerasghar@gmail.com=20
To: "Richard Harper" <drrwharper@gmail.com>, pgsql-admin-owner@postgresql.o=
rg, pgsql-admin@postgresql.org=20
Sent: Saturday, August 11, 2012 11:43:00 PM=20
Subject: Re: [ADMIN] server not starting=20

Did you allow ip addresses in pg_hba.conf. Perhaps you might need to allow =
IP's in that file.=20
Sent from my BlackBerry=C2=AE Smartphone provided by Ufone=20

From: Richard Harper <drrwharper@gmail.com>=20
Sender: pgsql-admin-owner@postgresql.org=20
Date: Sat, 11 Aug 2012 22:26:52 -0400=20
To: <pgsql-admin@postgresql.org>=20
Subject: [ADMIN] server not starting=20

Since I upgraded to 9.1, the server has not been starting. psql works, and =
pg_ctl status indicates that no server is connected.=20
If I run the command: sudo -u postgres /user/lib/postgresql/9.1/bin/pg_ctl =
start -D /usr/local/pgsql/data=20
it says the server is ready to accept connections.=20
The command sudo -u postgres /user/lib/postgresql/9.1/bin/pg_ctl status -D =
/usr/local/pgsql/data=20
gives:=20


pg_ctl: server is running (PID:1751)=20
/usr/lib/postgresql/9.1/bin/postgres "-D" "/usr/local/pgsql/data"=20
However, netstat indicates no connection to port 5432, and I still cannot c=
onnect.=20
I am unable to figure out where the LISTEN_ADDRESSES is assigned, perhaps t=
hat is the problem. I am obviously new to administration.=20


Thanks for any help,=20
Dick
------=_Part_449768_1423685865.1344778804720
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'><div st=
yle=3D"font-family: Verdana; font-size: 12pt; color: #000000">Also, in your=
 postgresql.conf file, be sure you have LISTEN_ADDRESSES set to '*' - for t=
esting, at least.<div><br></div><div>You sure server is running? What does =
$ ps -af | grep postgres tell you?</div><div><br></div><div>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)</div><div><br></div><div>Can you connect using psql from the =
_same_ machine, using a socket connection?</div><div><br></div><div>Lou Pic=
ciano<br><br><hr id=3D"zwchr"><b>From: </b>umerasghar@gmail.com<br><b>To: <=
/b>"Richard Harper" &lt;drrwharper@gmail.com&gt;, pgsql-admin-owner@postgre=
sql.org, pgsql-admin@postgresql.org<br><b>Sent: </b>Saturday, August 11, 20=
12 11:43:00 PM<br><b>Subject: </b>Re: [ADMIN] server not starting<br><br>Di=
d you allow ip addresses in pg_hba.conf. Perhaps you might need to allow IP=
's in that file.<div>Sent from my BlackBerry=C2=AE Smartphone provided by U=
fone</div><hr><div><b>From: </b> Richard Harper &lt;drrwharper@gmail.com&gt=
;
</div><div><b>Sender: </b> pgsql-admin-owner@postgresql.org</div><div><b>Da=
te: </b>Sat, 11 Aug 2012 22:26:52 -0400</div><div><b>To: </b>&lt;pgsql-admi=
n@postgresql.org&gt;</div><div><b>Subject: </b>[ADMIN] server not starting<=
/div><div><br></div>Since I upgraded to 9.1, the server has not been starti=
ng. &nbsp;psql works, and pg_ctl status indicates that no server is connect=
ed.<div>If I run the command: &nbsp;sudo -u postgres /user/lib/postgresql/9=
.1/bin/pg_ctl start -D /usr/local/pgsql/data</div>
<div>it says the server is ready to accept connections.</div><div>The comma=
nd sudo -u postgres /user/lib/postgresql/9.1/bin/pg_ctl status -D /usr/loca=
l/pgsql/data&nbsp;</div><div>gives:<br><div><div>pg_ctl: server is running =
(PID:1751)</div>
<div>/usr/lib/postgresql/9.1/bin/postgres "-D" "/usr/local/pgsql/data"</div=
></div></div><div>However, netstat indicates no connection to port 5432, an=
d I still cannot connect.</div><div>I am unable to figure out where the LIS=
TEN_ADDRESSES is assigned, perhaps that is the problem. &nbsp;I am&nbsp;obv=
iously&nbsp;new to administration.&nbsp;</div>
<div><br></div><div>Thanks for any help,</div><div>Dick</div>

</div></div></div></body></html>
------=_Part_449768_1423685865.1344778804720--