[Sysadmins] postgresql

[alexei на taf.ru]

----- Исходное сообщение -----
> От: "Anton Gorlov" <stalker на altlinux.ru>
> Кому: "ALT Linux sysadmin discuss" <sysadmins на lists.altlinux.org>
> Отправленные: Понедельник, 25 Ноябрь 2013 г 20:17:19
> Тема: Re: [Sysadmins] postgresql
> 
> дополнение -сам процесс статиски не запускается..  Вопрос как понять
> чего ему не хватает для счастья
> 
> 
> 25.11.2013 15:07, Anton Gorlov пишет:
> > ALL -  подскажите как бы отдебажить ошибку postgresql -  не работает
> > avtovacuum по причине
> >
> > LOG:  test message did not get through on socket for statistics collector
> > LOG:  disabling statistics collector for lack of working socket
> > WARNING:  autovacuum not started because of misconfiguration
> > HINT:  Enable the "track_counts" option.
> > LOG:  incomplete startup packet
> >
> > в конфигурации разумеется
> > track_counts = on

кусок рабочего конфига:

#------------------------------------------------------------------------------
# RUNTIME STATISTICS
#------------------------------------------------------------------------------

# - Query/Index Statistics Collector -

#track_activities = on
#track_counts = on
#track_functions = none                 # none, pl, all
#track_activity_query_size = 1024       # (change requires restart)
update_process_title = on
stats_temp_directory = 'pg_stat_tmp'

# - Statistics Monitoring -

log_parser_stats = off
log_planner_stats = off
log_executor_stats = off
#log_statement_stats = off

#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------

autovacuum = on                 # Enable autovacuum subprocess?  'on'
                                        # requires track_counts to also be on.
#log_autovacuum_min_duration = -1       # -1 disables, 0 logs all actions and
                                        # their durations, > 0 logs only
                                        # actions running at least this number
                                        # of milliseconds.
#autovacuum_max_workers = 3             # max number of autovacuum subprocesses
                                        # (change requires restart)
#autovacuum_naptime = 1min              # time between autovacuum runs
#autovacuum_vacuum_threshold = 50       # min number of row updates before
                                        # vacuum
#autovacuum_analyze_threshold = 50      # min number of row updates before
                                        # analyze
#autovacuum_vacuum_scale_factor = 0.2   # fraction of table size before vacuum
#autovacuum_analyze_scale_factor = 0.1  # fraction of table size before analyze
#autovacuum_freeze_max_age = 200000000  # maximum XID age before forced vacuum
                                        # (change requires restart)
#autovacuum_vacuum_cost_delay = 20ms    # default vacuum cost delay for
                                        # autovacuum, in milliseconds;
                                        # -1 means use vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1      # default vacuum cost limit for
                                        # autovacuum, -1 means use
                                        # vacuum_cost_limit

А вообще, PG в chroot'е запускается, или нет? /tmp/.s.PGSQL.5432 создается?