Re: PG quitting sporadically!!

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 port 5432?
>
> Yes of course the localhost is running the pgsql server and that port
> is allowed!

My educated guess is that your network is behaving funny, or your
firewall is crazy.  Or your kernel has bugs.  The fact that the
connections work sometimes is one clue; this is the other:

> LOG:  test message did not get through on socket for statistics collector
> LOG:  disabling statistics collector for lack of working socket

This is a bad sign.  For one thing, it means autovacuum, if enabled, is
not really working at all (which can, in turn, explain slowness).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support