Skip site navigation (1) Skip section navigation (2)

Re: server not starting

From: Lou Picciano <loupicciano(at)comcast(dot)net>
To: pgsql-admin(at)postgresql(dot)org, pgsql-admin-owner(at)postgresql(dot)org
Subject: Re: server not starting
Date: 2012-08-12 13:40:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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(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 
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(at)gmail(dot)com> 
Sender: pgsql-admin-owner(at)postgresql(dot)org 
Date: Sat, 11 Aug 2012 22:26:52 -0400 
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 

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, 

pgsql-admin by date

Next:From: Richard HarperDate: 2012-08-12 21:13:13
Subject: database not found
Previous:From: Matheus de OliveiraDate: 2012-08-12 12:38:37
Subject: Re: server not starting

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group