Re: Can't restart statistics collection and autovacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't restart statistics collection and autovacuum
Date
Msg-id 24008.1394824404@sss.pgh.pa.us
Whole thread Raw
In response to Can't restart statistics collection and autovacuum  (Ignacio Colmenero <ignacio.colmenero@abracontrols.com>)
Responses Re: Can't restart statistics collection and autovacuum  (Ignacio Colmenero <ignacio.colmenero@abracontrols.com>)
List pgsql-general
Ignacio Colmenero <ignacio.colmenero@abracontrols.com> writes:
> Yesterday, the database server was rebooted and database wasn't shut
> down properly.
> When it went back online, the following messages showed up:
> 2014-03-13 08:46:08 UTC   LOG:  08006: test message did not get through
> on socket for statistics collector

The only known reason for that to happen is kernel packet filtering rules
that prevent passing traffic through the stats-collector socket.  It seems
very unlikely that this "just happened" without somebody/something outside
Postgres actively breaking it.  I'd take a close look at recent system
configuration changes, particularly in the firewall area.  It wouldn't
hurt to know exactly *why* the system was rebooted, too.

            regards, tom lane


pgsql-general by date:

Previous
From: Ignacio Colmenero
Date:
Subject: Can't restart statistics collection and autovacuum
Next
From: Ignacio Colmenero
Date:
Subject: Re: Can't restart statistics collection and autovacuum