#loop_wait: 10 #master_start_timeout: 300 #maximum_lag_on_failover: 1048576 postgresql: parameters: # archive_command: pgbackrest --stanza=sandbox-postgres-cluster archive-push # %p || cd . # archive_mode: true # archive_timeout: 1800s # auto_explain.log_analyze: true # auto_explain.log_buffers: true # auto_explain.log_min_duration: 10s # auto_explain.log_nested_statements: true # auto_explain.log_timing: false # auto_explain.log_triggers: true # auto_explain.log_verbose: true # autovacuum: true # autovacuum_analyze_scale_factor: 0.02 # autovacuum_max_workers: 8 # autovacuum_naptime: 1s # autovacuum_vacuum_cost_delay: 20 # autovacuum_vacuum_cost_limit: 200 # autovacuum_vacuum_scale_factor: 0.01 # checkpoint_completion_target: 0.9 # checkpoint_timeout: 15min # default_statistics_target: 100 # effective_cache_size: 12GB # effective_io_concurrency: 200 # hot_standby: true # huge_pages: try # log_checkpoints: true # log_directory: /var/log/postgresql # log_filename: postgresql-%a.log # log_line_prefix: '%t [%p-%l] %r %q%u@%d ' # log_lock_waits: true # log_rotation_age: 1d # log_rotation_size: 0 # log_temp_files: 0 # log_timezone: Europe/Moscow # log_truncate_on_rotation: true # logging_collector: true # maintenance_work_mem: 1GB max_connections: 100 # max_files_per_process: 4096 # max_locks_per_transaction: 64 # max_parallel_maintenance_workers: 4 # max_parallel_workers: 8 # max_parallel_workers_per_gather: 4 # max_prepared_transactions: 0 # max_replication_slots: 10 # max_wal_senders: 10 # max_wal_size: 8GB # max_worker_processes: 8 # min_wal_size: 2GB # pg_stat_statements.max: 10000 # pg_stat_statements.save: false # pg_stat_statements.track: all # random_page_cost: 1.1 # seq_page_cost: 1 # shared_buffers: 4GB # shared_preload_libraries: pg_stat_statements,auto_explain,pg_cron,pg_partman_bgw,redis_fdw # superuser_reserved_connections: 5 # synchronous_commit: true # timezone: Europe/Moscow # track_activities: true # track_counts: true # track_functions: all # track_io_timing: true # wal_buffers: 16MB # wal_keep_segments: 1000 # wal_level: replica # wal_log_hints: true # work_mem: 10485kB # recovery_conf: # restore_command: pgbackrest --stanza=sandbox-postgres-cluster archive-get # %f %p # use_pg_rewind: true #retry_timeout: 10 #synchronous_mode: true #synchronous_mode_strict: true #synchronous_node_count: 1 #ttl: 100