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.colmenero@abracontrols.com
