Re: [GENERAL] PG quitting sporadically!!

2008-02-15 Thread Greg Smith
On Fri, 15 Feb 2008, Phoenix Kiula wrote: I am not sure what checkpoint stuff means. But I added that entry, and now my log has ONLY this: LOG: test message did not get through on socket for statistics collector LOG: disabling statistics collector for lack of working socket If you're gettin

Re: [GENERAL] PG quitting sporadically!!

2008-02-15 Thread Alvaro Herrera
Phoenix Kiula escribió: > Thanks. Comments below. (PS: I am still unable to connect to > postgresql even in SSH! I see this message: > >psql: could not connect to server: Connection timed out > Is the server running on host "localhost" and accepting > TCP/IP connections on

Re: [GENERAL] PG quitting sporadically!!

2008-02-14 Thread Douglas McNaught
> > Be aware that when 8.2.3 was released, 8.2 had only been out for two > > months. There's another 11 months worth of accumulated bug fixes in > > 8.2.6, including some that can cause the server to slow or crash. It's > > not a difficult upgrade (no changes to the database) and you shoul

Re: [GENERAL] PG quitting sporadically!!

2008-02-14 Thread Phoenix Kiula
Thanks. Comments below. (PS: I am still unable to connect to postgresql even in SSH! I see this message: psql: could not connect to server: Connection timed out Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? Yes of course the localh

Re: [GENERAL] PG quitting sporadically!!

2008-02-14 Thread Greg Smith
On Thu, 14 Feb 2008, Phoenix Kiula wrote: Suddenly, the postmaster either hogs up memory or just croaks and doesn't respond. The write process has become horribly slow. You should consider whether that's because a checkpoint is happening at that point. You didn't mention anything about your