Re: [ADMIN] JDBC keep alive issue

2012-08-11 Thread Craig James
On Fri, Aug 10, 2012 at 7:19 AM, Tom Lane wrote: > Haifeng Liu writes: > > I have a program running like a daemon, which analyze data and write to > postgresql 9.1 on centos 5.8. There is only one connection between my > program and the postgresql database, and I hope the connection may keep > a

[ADMIN] server not starting

2012-08-11 Thread Richard Harper
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

Re: [ADMIN] server not starting

2012-08-11 Thread umerasghar
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 -Original Message- From: Richard Harper Sender: [email protected]: Sat, 11 Aug 2012 22:26:52 To: Subject: [ADMIN] serve