From 9b24a4d0b7b1f420765470ff5f5ad7a7e9d6fd38 Mon Sep 17 00:00:00 2001 From: Ubuntu <kop@karlpinc.com> Date: Fri, 15 Sep 2023 21:17:23 +0000 Subject: [PATCH] Commit expected PG Azure db settings to revision control --- db/pg_settings | 366 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 366 insertions(+) create mode 100644 db/pg_settings diff --git a/db/pg_settings b/db/pg_settings new file mode 100644 index 0000000..ac99024 --- /dev/null +++ b/db/pg_settings @@ -0,0 +1,366 @@ + + DateStyle | ISO, MDY | | f + IntervalStyle | postgres | | f + TimeZone | UCT | | f + allow_in_place_tablespaces | off | | f + allow_system_table_mods | off | | f + application_name | psql | | f + archive_cleanup_command | | | f + archive_command | BlobLogUpload.sh %f %p | | f + archive_library | | | f + archive_mode | always | | f + archive_timeout | 300 | s | f + array_nulls | on | | f + authentication_timeout | 30 | s | f + autovacuum | on | | f + autovacuum_analyze_scale_factor | 0.1 | | f + autovacuum_analyze_threshold | 50 | | f + autovacuum_freeze_max_age | 200000000 | | f + autovacuum_max_workers | 3 | | f + autovacuum_multixact_freeze_max_age | 400000000 | | f + autovacuum_naptime | 60 | s | f + autovacuum_vacuum_cost_delay | 2 | ms | f + autovacuum_vacuum_cost_limit | -1 | | f + autovacuum_vacuum_insert_scale_factor | 0.2 | | f + autovacuum_vacuum_insert_threshold | 1000 | | f + autovacuum_vacuum_scale_factor | 0.2 | | f + autovacuum_vacuum_threshold | 50 | | f + autovacuum_work_mem | -1 | kB | f + azure.accepted_password_auth_method | md5 | | f + azure.allowed_error_codes | | | f + azure.crash_active_hotstandby_on_conflict_parameter | on | | f + azure.custom_path | /datadrive/pg/data | | f + azure.customer_resource_group | DBResources | | f + azure.customer_subscription_id | 94cd8cb7-d645-497b-b140-b281f40a5c96 | | f + azure.enable_is_db_alive | on | | f + azure.enable_temp_tablespaces_on_local_ssd | on | | f + azure.enforce_ha_quorom | off | | f + azure.extensions | | | f + azure.single_to_flex_migration | off | | f + azure.threat_protection_app_type_name | PostgreSQL.Flexible | | f + azure.waittime_is_db_alive | 10000 | | f + backend_flush_after | 256 | 8kB | f + backslash_quote | safe_encoding | | f + backtrace_functions | | | f + bgwriter_delay | 20 | ms | f + bgwriter_flush_after | 64 | 8kB | f + bgwriter_lru_maxpages | 100 | | f + bgwriter_lru_multiplier | 2 | | f + block_size | 8192 | | f + bonjour | off | | f + bonjour_name | | | f + bytea_output | hex | | f + check_function_bodies | on | | f + checkpoint_completion_target | 0.9 | | f + checkpoint_flush_after | 32 | 8kB | f + checkpoint_timeout | 600 | s | f + checkpoint_warning | 30 | s | f + client_connection_check_interval | 0 | ms | f + client_encoding | UTF8 | | f + client_min_messages | notice | | f + cluster_name | | | f + commit_delay | 0 | | f + commit_siblings | 5 | | f + compute_query_id | auto | | f + constraint_exclusion | partition | | f + cpu_index_tuple_cost | 0.005 | | f + cpu_operator_cost | 0.0025 | | f + cpu_tuple_cost | 0.01 | | f + cursor_tuple_fraction | 0.1 | | f + data_checksums | on | | f + data_directory_mode | 0700 | | f + data_sync_retry | off | | f + db_user_namespace | off | | f + deadlock_timeout | 1000 | ms | f + debug_assertions | off | | f + debug_discard_caches | 0 | | f + debug_pretty_print | on | | f + debug_print_parse | off | | f + debug_print_plan | off | | f + debug_print_rewritten | off | | f + default_statistics_target | 100 | | f + default_table_access_method | heap | | f + default_tablespace | | | f + default_text_search_config | pg_catalog.english | | f + default_toast_compression | pglz | | f + default_transaction_deferrable | off | | f + default_transaction_isolation | read committed | | f + default_transaction_read_only | off | | f + dynamic_shared_memory_type | posix | | f + effective_cache_size | 786432 | 8kB | f + effective_io_concurrency | 1 | | f + enable_async_append | on | | f + enable_bitmapscan | on | | f + enable_gathermerge | on | | f + enable_hashagg | on | | f + enable_hashjoin | on | | f + enable_incremental_sort | on | | f + enable_indexonlyscan | on | | f + enable_indexscan | on | | f + enable_material | on | | f + enable_memoize | on | | f + enable_mergejoin | on | | f + enable_nestloop | on | | f + enable_parallel_append | on | | f + enable_parallel_hash | on | | f + enable_partition_pruning | on | | f + enable_partitionwise_aggregate | off | | f + enable_partitionwise_join | off | | f + enable_seqscan | on | | f + enable_sort | on | | f + enable_tidscan | on | | f + escape_string_warning | on | | f + event_source | PostgreSQL | | f + exit_on_error | off | | f + extra_float_digits | 1 | | f + force_parallel_mode | off | | f + from_collapse_limit | 8 | | f + fsync | on | | f + full_page_writes | on | | f + geqo | on | | f + geqo_effort | 5 | | f + geqo_generations | 0 | | f + geqo_pool_size | 0 | | f + geqo_seed | 0 | | f + geqo_selection_bias | 2 | | f + geqo_threshold | 12 | | f + gin_fuzzy_search_limit | 0 | | f + gin_pending_list_limit | 4096 | kB | f + hash_mem_multiplier | 2 | | f + hot_standby | on | | f + hot_standby_feedback | off | | f + huge_page_size | 0 | kB | f + huge_pages | try | | f + idle_in_transaction_session_timeout | 0 | ms | f + idle_session_timeout | 0 | ms | f + ignore_checksum_failure | off | | f + ignore_invalid_pages | off | | f + ignore_system_indexes | off | | f + in_hot_standby | off | | f + integer_datetimes | on | | f + jit | off | | f + jit_above_cost | 100000 | | f + jit_debugging_support | off | | f + jit_dump_bitcode | off | | f + jit_expressions | on | | f + jit_inline_above_cost | 500000 | | f + jit_optimize_above_cost | 500000 | | f + jit_profiling_support | off | | f + jit_tuple_deforming | on | | f + join_collapse_limit | 8 | | f + krb_caseins_users | off | | f + lc_collate | C | | f + lc_ctype | C | | f + lc_messages | en_US.utf8 | | f + lc_monetary | en_US.utf-8 | | f + lc_numeric | en_US.utf-8 | | f + lc_time | en_US.utf8 | | f + listen_addresses | * | | f + lo_compat_privileges | off | | f + local_preload_libraries | | | f + lock_timeout | 0 | ms | f + log_autovacuum_min_duration | 600000 | ms | f + log_checkpoints | on | | f + log_connections | on | | f + log_destination | stderr | | f + log_disconnections | on | | f + log_duration | off | | f + log_error_verbosity | default | | f + log_executor_stats | off | | f + log_file_mode | 0600 | | f + log_hostname | off | | f + log_line_prefix | %t-%c- | | f + log_lock_waits | off | | f + log_min_duration_sample | -1 | ms | f + log_min_duration_statement | -1 | ms | f + log_min_error_statement | error | | f + log_min_messages | warning | | f + log_parameter_max_length | -1 | B | f + log_parameter_max_length_on_error | 0 | B | f + log_parser_stats | off | | f + log_planner_stats | off | | f + log_recovery_conflict_waits | off | | f + log_replication_commands | on | | f + log_rotation_age | 60 | min | f + log_rotation_size | 102400 | kB | f + log_startup_progress_interval | 10000 | ms | f + log_statement | none | | f + log_statement_sample_rate | 1 | | f + log_statement_stats | off | | f + log_temp_files | -1 | kB | f + log_timezone | UTC | | f + log_transaction_sample_rate | 0 | | f + log_truncate_on_rotation | off | | f + logging_collector | off | | f + logical_decoding_work_mem | 65536 | kB | f + maintenance_io_concurrency | 10 | | f + maintenance_work_mem | 216064 | kB | f + max_connections | 859 | | f + max_files_per_process | 1000 | | f + max_function_args | 100 | | f + max_identifier_length | 63 | | f + max_index_keys | 32 | | f + max_locks_per_transaction | 64 | | f + max_logical_replication_workers | 4 | | f + max_parallel_maintenance_workers | 64 | | f + max_parallel_workers | 8 | | f + max_parallel_workers_per_gather | 2 | | f + max_pred_locks_per_page | 2 | | f + max_pred_locks_per_relation | -2 | | f + max_pred_locks_per_transaction | 64 | | f + max_prepared_transactions | 0 | | f + max_replication_slots | 10 | | f + max_slot_wal_keep_size | -1 | MB | f + max_stack_depth | 2048 | kB | f + max_standby_archive_delay | 30000 | ms | f + max_standby_streaming_delay | 30000 | ms | f + max_sync_workers_per_subscription | 2 | | f + max_wal_senders | 10 | | f + max_wal_size | 2048 | MB | f + max_worker_processes | 8 | | f + min_dynamic_shared_memory | 0 | MB | f + min_parallel_index_scan_size | 64 | 8kB | f + min_parallel_table_scan_size | 1024 | 8kB | f + min_wal_size | 80 | MB | f + old_snapshot_threshold | -1 | min | f + parallel_leader_participation | on | | f + parallel_setup_cost | 1000 | | f + parallel_tuple_cost | 0.1 | | f + password_encryption | md5 | | f + pg_qs.host_database | azure_sys | | f + pg_qs.index_generation_interval | 15 | | f + pg_qs.interval_length_minutes | 15 | | f + pg_qs.is_enabled_fs | on | | f + pg_qs.max_plan_size | 7500 | | f + pg_qs.max_queries | 500 | | f + pg_qs.max_query_text_length | 6000 | | f + pg_qs.query_capture_mode | none | | f + pg_qs.retention_period_in_days | 7 | | f + pg_qs.store_query_plans | off | | f + pg_qs.track_utility | on | | f + pg_stat_statements.max | 5000 | | f + pg_stat_statements.save | on | | f + pg_stat_statements.track | top | | f + pg_stat_statements.track_planning | off | | f + pg_stat_statements.track_utility | on | | f + pgaadauth.log_min_messages | warning | | f + pgms_stats.is_enabled_fs | on | | f + pgms_wait_sampling.history_period | 100 | | f + pgms_wait_sampling.is_enabled_fs | on | | f + pgms_wait_sampling.query_capture_mode | none | | f + plan_cache_mode | auto | | f + port | 5432 | | f + post_auth_delay | 0 | s | f + pre_auth_delay | 0 | s | f + primary_slot_name | | | f + promote_trigger_file | | | f + quote_all_identifiers | off | | f + random_page_cost | 2 | | f + recovery_end_command | | | f + recovery_init_sync_method | fsync | | f + recovery_min_apply_delay | 0 | ms | f + recovery_prefetch | try | | f + recovery_target | | | f + recovery_target_action | pause | | f + recovery_target_inclusive | on | | f + recovery_target_lsn | | | f + recovery_target_name | | | f + recovery_target_time | | | f + recovery_target_timeline | latest | | f + recovery_target_xid | | | f + recursive_worktable_factor | 10 | | f + restart_after_crash | on | | f + restore_command | | | f + row_security | on | | f + search_path | sokwedb, lookup, upload, "$user" | | f + segment_size | 131072 | 8kB | f + seq_page_cost | 1 | | f + server_encoding | SQL_ASCII | | f + server_version | 15.3 | | f + server_version_num | 150003 | | f + session_replication_role | origin | | f + shared_buffers | 262144 | 8kB | f + shared_memory_size | 2168 | MB | f + shared_memory_size_in_huge_pages | 1084 | | f + shared_memory_type | mmap | | f + ssl | on | | f + ssl_ca_file | /datadrive/certs/ca.pem | | f + ssl_cert_file | /datadrive/certs/cert.pem | | f + ssl_crl_dir | | | f + ssl_crl_file | | | f + ssl_key_file | /datadrive/certs/key.pem | | f + ssl_library | OpenSSL | | f + ssl_passphrase_command_supports_reload | off | | f + ssl_prefer_server_ciphers | on | | f + standard_conforming_strings | on | | f + statement_timeout | 0 | ms | f + stats_fetch_consistency | cache | | f + superuser_reserved_connections | 3 | | f + synchronize_seqscans | on | | f + synchronous_commit | on | | f + synchronous_standby_names | | | f + syslog_facility | local0 | | f + syslog_ident | postgres | | f + syslog_sequence_numbers | on | | f + syslog_split_messages | on | | f + tcp_keepalives_count | 9 | | f + tcp_keepalives_idle | 120 | s | f + tcp_keepalives_interval | 30 | s | f + tcp_user_timeout | 0 | ms | f + temp_buffers | 1024 | 8kB | f + temp_file_limit | -1 | kB | f + temp_tablespaces | | | f + timezone_abbreviations | Default | | f + trace_notify | off | | f + trace_recovery_messages | log | | f + trace_sort | off | | f + track_activities | on | | f + track_activity_query_size | 1024 | B | f + track_commit_timestamp | off | | f + track_counts | on | | f + track_functions | none | | f + track_io_timing | off | | f + track_wal_io_timing | off | | f + transaction_deferrable | off | | f + transaction_isolation | read committed | | f + transaction_read_only | off | | f + transform_null_equals | off | | f + unix_socket_group | | | f + unix_socket_permissions | 0777 | | f + update_process_title | on | | f + vacuum_cost_delay | 0 | ms | f + vacuum_cost_limit | 200 | | f + vacuum_cost_page_dirty | 20 | | f + vacuum_cost_page_hit | 1 | | f + vacuum_cost_page_miss | 2 | | f + vacuum_defer_cleanup_age | 0 | | f + vacuum_failsafe_age | 1600000000 | | f + vacuum_freeze_min_age | 50000000 | | f + vacuum_freeze_table_age | 150000000 | | f + vacuum_multixact_failsafe_age | 1600000000 | | f + vacuum_multixact_freeze_min_age | 5000000 | | f + vacuum_multixact_freeze_table_age | 150000000 | | f + wal_block_size | 8192 | | f + wal_buffers | 2048 | 8kB | f + wal_compression | pglz | | f + wal_consistency_checking | | | f + wal_decode_buffer_size | 524288 | B | f + wal_init_zero | on | | f + wal_keep_size | 400 | MB | f + wal_level | replica | | f + wal_log_hints | off | | f + wal_receiver_create_temp_slot | off | | f + wal_receiver_status_interval | 10 | s | f + wal_receiver_timeout | 60000 | ms | f + wal_recycle | on | | f + wal_retrieve_retry_interval | 5000 | ms | f + wal_segment_size | 16777216 | B | f + wal_sender_timeout | 60000 | ms | f + wal_skip_threshold | 2048 | kB | f + wal_sync_method | fdatasync | | f + wal_writer_delay | 200 | ms | f + wal_writer_flush_after | 128 | 8kB | f + work_mem | 4096 | kB | f + xmlbinary | base64 | | f + xmloption | content | | f + zero_damaged_pages | off | | f -- 2.34.1