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.colmen...@abracontrols.com
<mailto:ignacio.colmen...@abracontrols.com>
