|
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 |
