summaryrefslogtreecommitdiffstats
path: root/t/10.conf
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-06 01:48:40 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-06 01:48:40 +0000
commit73e1fa4347d6c81c6e64054957ab436fa358ced1 (patch)
treef1cf86462dba1a85afd6005fca0a45b7e574c23c /t/10.conf
parentInitial commit. (diff)
downloadpostgresql-common-upstream.tar.xz
postgresql-common-upstream.zip
Adding upstream version 200+deb10u5.upstream/200+deb10u5upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 't/10.conf')
-rw-r--r--t/10.conf238
1 files changed, 238 insertions, 0 deletions
diff --git a/t/10.conf b/t/10.conf
new file mode 100644
index 0000000..493fc51
--- /dev/null
+++ b/t/10.conf
@@ -0,0 +1,238 @@
+listen_addresses = 'localhost'
+port = 5432
+max_connections = 100
+superuser_reserved_connections = 3
+unix_socket_directories = '/var/run/postgresql'
+unix_socket_group = ''
+unix_socket_permissions = 0777
+bonjour = off
+bonjour_name = ''
+authentication_timeout = 1min
+ssl = on
+ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL'
+ssl_prefer_server_ciphers = on
+ssl_ecdh_curve = 'prime256v1'
+ssl_dh_params_file = ''
+ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
+ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
+ssl_ca_file = ''
+ssl_crl_file = ''
+password_encryption = md5
+db_user_namespace = off
+row_security = on
+krb_server_keyfile = ''
+krb_caseins_users = off
+tcp_keepalives_idle = 0
+tcp_keepalives_interval = 0
+tcp_keepalives_count = 0
+shared_buffers = 128MB
+huge_pages = try
+temp_buffers = 8MB
+max_prepared_transactions = 0
+work_mem = 4MB
+maintenance_work_mem = 64MB
+replacement_sort_tuples = 150000
+autovacuum_work_mem = -1
+max_stack_depth = 2MB
+dynamic_shared_memory_type = posix
+temp_file_limit = -1
+max_files_per_process = 1000
+shared_preload_libraries = ''
+vacuum_cost_delay = 0
+vacuum_cost_page_hit = 1
+vacuum_cost_page_miss = 10
+vacuum_cost_page_dirty = 20
+vacuum_cost_limit = 200
+bgwriter_delay = 200ms
+bgwriter_lru_maxpages = 100
+bgwriter_lru_multiplier = 2.0
+bgwriter_flush_after = 512kB
+effective_io_concurrency = 1
+max_worker_processes = 8
+max_parallel_workers_per_gather = 2
+max_parallel_workers = 8
+old_snapshot_threshold = -1
+backend_flush_after = 0
+wal_level = replica
+fsync = on
+synchronous_commit = on
+wal_sync_method = fsync
+full_page_writes = on
+wal_compression = off
+wal_log_hints = off
+wal_buffers = -1
+wal_writer_delay = 200ms
+wal_writer_flush_after = 1MB
+commit_delay = 0
+commit_siblings = 5
+checkpoint_timeout = 5min
+max_wal_size = 1GB
+min_wal_size = 80MB
+checkpoint_completion_target = 0.5
+checkpoint_flush_after = 256kB
+checkpoint_warning = 30s
+archive_mode = off
+archive_command = ''
+archive_timeout = 0
+max_wal_senders = 10
+wal_keep_segments = 0
+wal_sender_timeout = 60s
+max_replication_slots = 10
+track_commit_timestamp = off
+synchronous_standby_names = ''
+vacuum_defer_cleanup_age = 0
+hot_standby = on
+max_standby_archive_delay = 30s
+max_standby_streaming_delay = 30s
+wal_receiver_status_interval = 10s
+hot_standby_feedback = off
+wal_receiver_timeout = 60s
+wal_retrieve_retry_interval = 5s
+max_logical_replication_workers = 4
+max_sync_workers_per_subscription = 2
+enable_bitmapscan = on
+enable_hashagg = on
+enable_hashjoin = on
+enable_indexscan = on
+enable_indexonlyscan = on
+enable_material = on
+enable_mergejoin = on
+enable_nestloop = on
+enable_seqscan = on
+enable_sort = on
+enable_tidscan = on
+seq_page_cost = 1.0
+random_page_cost = 4.0
+cpu_tuple_cost = 0.01
+cpu_index_tuple_cost = 0.005
+cpu_operator_cost = 0.0025
+parallel_tuple_cost = 0.1
+parallel_setup_cost = 1000.0
+min_parallel_table_scan_size = 8MB
+min_parallel_index_scan_size = 512kB
+effective_cache_size = 4GB
+geqo = on
+geqo_threshold = 12
+geqo_effort = 5
+geqo_pool_size = 0
+geqo_generations = 0
+geqo_selection_bias = 2.0
+geqo_seed = 0.0
+default_statistics_target = 100
+constraint_exclusion = partition
+cursor_tuple_fraction = 0.1
+from_collapse_limit = 8
+join_collapse_limit = 8
+force_parallel_mode = off
+log_destination = 'stderr'
+logging_collector = off
+log_directory = 'log'
+log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
+log_file_mode = 0600
+log_truncate_on_rotation = off
+log_rotation_age = 1d
+log_rotation_size = 10MB
+syslog_facility = 'LOCAL0'
+syslog_ident = 'postgres'
+syslog_sequence_numbers = on
+syslog_split_messages = on
+event_source = 'PostgreSQL'
+log_min_messages = warning
+log_min_error_statement = error
+log_min_duration_statement = -1
+debug_print_parse = off
+debug_print_rewritten = off
+debug_print_plan = off
+debug_pretty_print = on
+log_checkpoints = off
+log_connections = off
+log_disconnections = off
+log_duration = off
+log_error_verbosity = default
+log_hostname = off
+log_line_prefix = '%m [%p] %q%u@%d '
+log_lock_waits = off
+log_statement = 'none'
+log_replication_commands = off
+log_temp_files = -1
+log_timezone = 'CET'
+cluster_name = '10/main'
+update_process_title = on
+track_activities = on
+track_counts = on
+track_io_timing = off
+track_functions = none
+track_activity_query_size = 1024
+stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'
+log_parser_stats = off
+log_planner_stats = off
+log_executor_stats = off
+log_statement_stats = off
+autovacuum = on
+log_autovacuum_min_duration = -1
+autovacuum_max_workers = 3
+autovacuum_naptime = 1min
+autovacuum_vacuum_threshold = 50
+autovacuum_analyze_threshold = 50
+autovacuum_vacuum_scale_factor = 0.2
+autovacuum_analyze_scale_factor = 0.1
+autovacuum_freeze_max_age = 200000000
+autovacuum_multixact_freeze_max_age = 400000000
+autovacuum_vacuum_cost_delay = 20ms
+autovacuum_vacuum_cost_limit = -1
+client_min_messages = notice
+search_path = '"$user", public'
+default_tablespace = ''
+temp_tablespaces = ''
+check_function_bodies = on
+default_transaction_isolation = 'read committed'
+default_transaction_read_only = off
+default_transaction_deferrable = off
+session_replication_role = 'origin'
+statement_timeout = 0
+lock_timeout = 0
+idle_in_transaction_session_timeout = 0
+vacuum_freeze_min_age = 50000000
+vacuum_freeze_table_age = 150000000
+vacuum_multixact_freeze_min_age = 5000000
+vacuum_multixact_freeze_table_age = 150000000
+bytea_output = 'hex'
+xmlbinary = 'base64'
+xmloption = 'content'
+gin_fuzzy_search_limit = 0
+gin_pending_list_limit = 4MB
+datestyle = 'iso, dmy'
+intervalstyle = 'postgres'
+timezone = 'CET'
+timezone_abbreviations = 'Default'
+extra_float_digits = 0
+client_encoding = sql_ascii
+lc_messages = 'C'
+lc_monetary = 'C'
+lc_numeric = 'C'
+lc_time = 'C'
+default_text_search_config = 'pg_catalog.german'
+dynamic_library_path = '$libdir'
+local_preload_libraries = ''
+session_preload_libraries = ''
+deadlock_timeout = 1s
+max_locks_per_transaction = 64
+max_pred_locks_per_transaction = 64
+max_pred_locks_per_relation = -2
+max_pred_locks_per_page = 2
+array_nulls = on
+backslash_quote = safe_encoding
+default_with_oids = off
+escape_string_warning = on
+lo_compat_privileges = off
+operator_precedence_warning = off
+quote_all_identifiers = off
+standard_conforming_strings = on
+synchronize_seqscans = on
+transform_null_equals = off
+exit_on_error = off
+restart_after_crash = on
+data_sync_retry = off
+#include_dir = 'conf.d'
+include_if_exists = 'exists.conf'
+#include = 'special.conf'