root@rpopdb01e ~ # grep '^[a-z]' /var/lib/pgsql/9.3/data/conf.d/postgresql.conf hba_file = '9.3/data/conf.d/pg_hba.conf' # host-based authentication file listen_addresses = '*' # what IP address(es) to listen on; max_connections = 4000 # (change requires restart) shared_buffers = 32GB # min 128kB temp_buffers = 512MB # min 800kB shared_preload_libraries = 'pg_stat_statements,pg_statsinfo' # (change requires restart) pg_stat_statements.max = 10000 pg_stat_statements.track = all pg_statsinfo.repository_server = 'host=pgmeta.mail.yandex.net port=6432 dbname=pgstats_rpopdb user=pgstats password=yav8Ia0m' pg_statsinfo.snapshot_interval = 1min # set snapshot interval pg_statsinfo.enable_maintenance = 'on' # enable maintenance mode('on' or 'off') pg_statsinfo.maintenance_time = '00:05:00' # Delete old snapshots every day in this time. pg_statsinfo.repository_keepday = 30 # keep old snapshots in this period in maintenance. pg_statsinfo.syslog_min_messages = 'error' pg_statsinfo.textlog_line_prefix = '%t %p %c-%l %x %q(%u, %d, %r, %a) ' # This format is same as syslog's format. pg_statsinfo.syslog_line_prefix = '%t %p %c-%l %x %q(%u, %d, %r, %a) ' # This format is same as syslog's format. wal_level = hot_standby # minimal, archive, or hot_standby checkpoint_segments = 64 # in logfile segments, min 1, 16MB each archive_mode = on # allows archiving to be done archive_command = 'test ! -f /var/lib/pgsql/9.3/archive/%f && cp %p /var/lib/pgsql/9.3/archive/%f' max_wal_senders = 10 # max number of walsender processes wal_keep_segments = 64 # in logfile segments, 16MB each; 0 disables wal_sender_timeout = 3s # in milliseconds; 0 disables synchronous_standby_names = '' # standby servers that provide sync rep hot_standby = on # "on" allows queries during recovery wal_receiver_status_interval = 1s # send replies at least this often log_destination = 'stderr' # Valid values are combinations of logging_collector = on # Enable capturing of stderr and csvlog log_directory = 'pg_log' # directory where log files are written, log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # pg_statsinfo need this log_filename setting log_truncate_on_rotation = on # If on, an existing log file with the log_rotation_age = 1d # Automatic rotation of logfiles will log_rotation_size = 0 # Automatic rotation of logfiles will log_checkpoints = on log_hostname = on log_line_prefix = '< %m >' # special values: log_lock_waits = on # log lock waits >= deadlock_timeout log_timezone = 'Europe/Moscow' track_activities = on track_counts = on track_io_timing = on track_functions = all # none, pl, all autovacuum = on # Enable autovacuum subprocess? 'on' log_autovacuum_min_duration = 0 # -1 disables, 0 logs all actions and datestyle = 'iso, dmy' timezone = 'Europe/Moscow' lc_messages = 'en_US.UTF-8' # locale for system error message lc_monetary = 'en_US.UTF-8' # locale for monetary formatting lc_numeric = 'en_US.UTF-8' # locale for number formatting lc_time = 'en_US.UTF-8' # locale for time formatting default_text_search_config = 'pg_catalog.english' root@rpopdb01e ~ #