From: | Ignacio Colmenero <ignacio(dot)colmenero(at)abracontrols(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Can't restart statistics collection and autovacuum |
Date: | 2014-03-14 18:26:36 |
Message-ID: | 532349DC.4030903@abracontrols.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Guys.
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
2014-03-13 08:46:08 UTC LOCATION: pgstat_init, pgstat.c:463
2014-03-13 08:46:08 UTC LOG: 00000: disabling statistics collector
for lack of working socket
2014-03-13 08:46:08 UTC LOCATION: pgstat_init, pgstat.c:521
2014-03-13 08:46:08 UTC WARNING: 01000: autovacuum not started
because of misconfiguration
2014-03-13 08:46:08 UTC HINT: Enable the "track_counts" option.
2014-03-13 08:46:08 UTC LOCATION: autovac_init, autovacuum.c:2809
2014-03-13 08:46:08 UTC LOG: 00000: database system was interrupted;
last known up at 2014-03-13 08:41:49 UTC
I enabled the track_counts option, but when I checked it, it still shows
as "off".
I have 2 questions:
1. Any ideas how to fix this? I've googled it and check this list and
tried everything so far with no results.
2. Any link to a script I may post on rc6.d to avoid this mishap in the
future?
PostgreSQL version is 9.1.3
OS: Ubuntu 11.10 (GNU/Linux 3.0.0-12-virtual x86_64)
--
/Ignacio Colmenero/
Database Analyst
Abra Controls Inc.
P# (403) 775-2237
ignacio(dot)colmenero(at)abracontrols(dot)com
<mailto:ignacio(dot)colmenero(at)abracontrols(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-03-14 19:13:24 | Re: Can't restart statistics collection and autovacuum |
Previous Message | Daryl Foster | 2014-03-14 16:58:55 | Re: Cannot insert to 'path' field using EclipseLink |