Update PostgreSQL options (PostgreSQL 18)

1 files changed, 158 insertions, 7 deletions

diff --git a/modules/apps/postgresql/server.nix b/modules/apps/postgresql/server.nix
index 085eaae..baafb35 100644
--- a/modules/apps/postgresql/server.nix
+++ b/modules/apps/postgresql/server.nix
@@ -19,9 +19,12 @@ let
 
 in {
   options = {
+    allow_alter_system = optional bool;
     application_name = optional str;
+    archive_cleanup_command = optional path;
     archive_command = optional path;
-    archive_mode = optional bool;
+    archive_library = optional path;
+    archive_mode = optional (enum [ "always" "on" "off" ]);
     archive_timeout = optional int;
     array_nulls = optional bool;
     authentication_timeout = optional int;
@@ -34,29 +37,43 @@ in {
     autovacuum_naptime = optional int;
     autovacuum_vacuum_cost_delay = optional int;
     autovacuum_vacuum_cost_limit = optional int;
+    autovacuum_vacuum_insert_scale_factor = optional float;
+    autovacuum_vacuum_insert_threshold = optional int;
+    autovacuum_vacuum_max_threshold = optional int;
     autovacuum_vacuum_scale_factor = optional float;
     autovacuum_vacuum_threshold = optional int;
     autovacuum_work_mem = optional int;
+    autovacuum_worker_slots = optional int;
+    backend_flush_after = optional int;
     backslash_quote = optional (enum [ "on" "off" "safe_encoding" ]);
     bgwriter_delay = optional int;
+    bgwriter_flush_after = optional int;
     bgwriter_lru_maxpages = optional int;
     bgwriter_lru_multiplier = optional int;
+    bonjour = optional bool;
+    bonjour_name = optional str;
     bytea_output = optional (enum [ "hex" "escape" ]);
     check_function_bodies = optional bool;
     checkpoint_completion_target = optional float;
+    checkpoint_flush_after = optional int;
     checkpoint_segments = optional int;
     checkpoint_timeout = optional int;
     checkpoint_warning = optional int;
+    client_connection_check_interval = optional int;
     client_encoding = optional str;
-    client_min_messages = optional (enum [ "DEBUG5" "DEBUG4" "DEBUG3" "DEBUG2" "DEBUG1" "LOG" "NOTICE" "WARNING" "ERROR" "FATAL" "PANIC" ]);
+    client_min_messages = optional (enum [ "DEBUG5" "DEBUG4" "DEBUG3" "DEBUG2" "DEBUG1" "LOG" "NOTICE" "WARNING" "ERROR" ]);
+    cluster_name = optional str;
     commit_delay = optional int;
     commit_siblings = optional int;
+    commit_timestamp_buffers = optional int;
+    compute_query_id = optional (enum [ "off" "on" "auto" "regress" ]);
     constraint_exclusion = optional (enum [ "on" "partition" "off" ]);
     cpu_index_tuple_cost = optional float;
     cpu_operator_cost = optional float;
     cpu_tuple_cost = optional float;
     cursor_tuple_fraction = optional float;
     data_directory = mandatory path;
+    data_sync_retry = optional bool;
     DateStyle = optional str;
     deadlock_timeout = optional int;
     debug_pretty_print = optional bool;
@@ -64,29 +81,49 @@ in {
     debug_print_plan = optional bool;
     debug_print_rewritten = optional bool;
     default_statistics_target = optional int;
+    default_table_access_method = optional str;
     default_tablespace = optional str;
     default_text_search_config = optional str;
+    default_toast_compression = optional (enum [ "pglz" "lz4" ]);
     default_transaction_deferrable = optional bool;
     default_transaction_isolation = optional (enum [ "read uncommitted" "read committed" "repeatable read" "serializable" ]);
     default_transaction_read_only = optional bool;
     default_with_oids = optional bool;
-    dynamic_shared_memory_type = optional (enum [ "posix" "sysv" "mmap" "none" ]);
+    dynamic_library_path = optional str;
+    dynamic_shared_memory_type = optional (enum [ "posix" "sysv" "mmap" ]);
     effective_cache_size = optional int;
     effective_io_concurrency = optional int;
+    enable_async_append = optional bool;
     enable_bitmapscan = optional bool;
+    enable_distinct_reordering = optional bool;
+    enable_gathermerge = optional bool;
+    enable_group_by_reordering = optional bool;
     enable_hashagg = optional bool;
     enable_hashjoin = optional bool;
+    enable_incremental_sort = optional bool;
     enable_indexonlyscan = optional bool;
     enable_indexscan = optional bool;
     enable_material = optional bool;
+    enable_memoize = optional bool;
     enable_mergejoin = optional bool;
     enable_nestloop = optional bool;
+    enable_parallel_append = optional bool;
+    enable_parallel_hash = optional bool;
+    enable_partition_pruning = optional bool;
+    enable_partitionwise_aggregate = optional bool;
+    enable_partitionwise_join = optional bool;
+    enable_presorted_aggregate = optional bool;
+    enable_self_join_elimination = optional bool;
     enable_seqscan = optional bool;
     enable_sort = optional bool;
     enable_tidscan = optional bool;
     escape_string_warning = optional bool;
+    event_source = optional str;
     exit_on_error = optional bool;
+    extension_control_path = optional str;
     extra_float_digits = optional int;
+    file_copy_method = optional (enum [ "COPY" "CLONE" ]);
+    file_extend_method = optional (enum [ "posix_fallocate" "write_zeros" ]);
     from_collapse_limit = optional int;
     fsync = optional bool;
     full_page_writes = optional bool;
@@ -97,88 +134,181 @@ in {
     geqo_seed = optional float;
     geqo_selection_bias = optional float;
     geqo_threshold = optional int;
+    gin_fuzzy_search_limit = optional int;
+    gss_accept_delegation = optional bool;
+    hash_mem_multiplier = optional float;
     hba_file = default "" lines;
     hot_standby = optional bool;
     hot_standby_feedback = optional bool;
+    huge_page_size = optional int;
     huge_pages = optional (enum [ "on" "off" "try" ]);
+    icu_validation_level = optional (enum [ "DISABLED" "DEBUG5" "DEBUG4" "DEBUG3" "DEBUG2" "DEBUG1" "LOG" "INFO" "NOTICE" "WARNING" "ERROR" ]);
     ident_file = default "" lines;
-    IntervalStyle = optional (enum [ "sql_standard" "postgres_verbose" "iso_8601" ]);
+    idle_replication_slot_timeout = optional int;
+    IntervalStyle = optional (enum [ "sql_standard" "postgres" "postgres_verbose" "iso_8601" ]);
+    io_combine_limit = optional int;
+    io_max_combine_limit = optional int;
+    io_max_concurrency = optional int;
+    io_method = optional (enum [ "worker" "io_uring" "sync" ]);
+    io_workers = optional int;
+    jit = optional bool;
+    jit_above_cost = optional float;
+    jit_inline_above_cost = optional float;
+    jit_optimize_above_cost = optional float;
+    jit_provider = optional str;
     join_collapse_limit = optional int;
+    krb_caseins_users = optional bool;
+    krb_server_keyfile = optional path;
     lc_messages = optional str;
     lc_monetary = optional str;
     lc_numeric = optional str;
     lc_time = optional str;
     listen_addresses = optional (either (listOf str) str);
     lo_compat_privileges = optional bool;
+    local_preload_libraries = optional (either (listOf str) str);
     lock_timeout = optional int;
     log_autovacuum_min_duration = optional int;
     log_checkpoints = optional bool;
-    log_connections = optional bool;
-    log_destination = optional (enum [ "stderr" "csvlog" "syslog" ]);
+    log_connections = let x = enum [ "receipt" "authentication" "authorization" "setup_durations" "all"]; in optional (either (listOf x) x);
+    log_destination = let x = enum [ "stderr" "csvlog" "syslog" "jsonlog" ]; in optional (either (listOf x) x);
     log_directory  = optional path;
     log_disconnections = optional bool;
     log_duration = optional bool;
     log_error_verbosity = optional (enum [ "TERSE" "DEFAULT" "VERBOSE" ]);
     log_executor_stats = optional bool;
+    log_file_mode = optional int;
     log_filename  = optional str;
     log_hostname = optional bool;
     log_line_prefix = optional str;
+    log_lock_failures = optional bool;
     log_lock_waits = optional bool;
+    log_min_duration_sample = optional int;
     log_min_duration_statement = optional int;
     log_min_error_statement = optional (enum [ "DEBUG5" "DEBUG4" "DEBUG3" "DEBUG2" "DEBUG1" "LOG" "NOTICE" "WARNING" "ERROR" "FATAL" "PANIC" ]);
     log_min_messages = optional (enum [ "DEBUG5" "DEBUG4" "DEBUG3" "DEBUG2" "DEBUG1" "LOG" "NOTICE" "WARNING" "ERROR" "FATAL" "PANIC" ]);
+    log_parameter_max_length = optional int;
+    log_parameter_max_length_on_error = optional int;
     log_parser_stats = optional bool;
     log_planner_stats = optional bool;
+    log_recovery_conflict_waits = optional bool;
+    log_replication_commands = optional bool;
     log_rotation_age = optional int;
     log_rotation_size = optional int;
+    log_startup_progress_interval = optional int;
     log_statement = optional (enum [ "none" "ddl" "mod" "all" ]);
+    log_statement_sample_rate = optional float;
     log_statement_stats = optional bool;
     log_temp_files = optional int;
     log_timezone = optional str;
+    log_transaction_sample_rate = optional float;
     log_truncate_on_rotation = optional bool;
     logging_collector = optional bool;
+    logical_decoding_work_mem = optional int;
+    maintenance_io_concurrency = optional int;
     maintenance_work_mem = optional int;
+    max_active_replication_origins = optional int;
     max_connections = optional int;
     max_files_per_process = optional int;
     max_locks_per_transaction = optional int;
+    max_logical_replication_workers = optional int;
+    max_notify_queue_pages = optional int;
+    max_parallel_apply_workers_per_subscription = optional int;
+    max_parallel_maintenance_workers = optional int;
+    max_parallel_workers = optional int;
+    max_parallel_workers_per_gather = optional int;
+    max_pred_locks_per_page = optional int;
+    max_pred_locks_per_relation = optional int;
     max_pred_locks_per_transaction = optional int;
     max_prepared_transactions = optional int;
     max_replication_slots = optional int;
+    max_slot_wal_keep_size = optional int;
     max_stack_depth = optional int;
     max_standby_archive_delay = optional int;
     max_standby_streaming_delay = optional int;
+    max_sync_workers_per_subscription = optional int;
     max_wal_senders = optional int;
+    max_wal_size = optional int;
     max_worker_processes = optional int;
+    min_dynamic_shared_memory = optional int;
+    min_parallel_index_scan_size = optional int;
+    min_parallel_table_scan_size = optional int;
+    min_wal_size = optional int;
+    multixact_member_buffers = optional int;
+    multixact_offset_buffers = optional int;
+    notify_buffers = optional int;
+    oauth_validator_libraries = optional str;
+    parallel_leader_participation = optional bool;
+    parallel_setup_cost = optional float;
+    parallel_tuple_cost = optional float;
     password_encryption = optional (enum [ "md5" "scram-sha-256" ]);
+    plan_cache_mode = optional (enum [ "auto" "force_custom_plan" "force_generic_plan" ]);
     port = default 5432 int;
+    primary_conninfo = optional str;
+    primary_slot_name = optional str;
     quote_all_identifiers = optional bool;
     random_page_cost = optional float;
+    recovery_end_command = optional path;
+    recovery_init_sync_method = optional (enum ["fsync" "syncfs"]);
+    recovery_min_apply_delay = optional int;
+    recovery_prefetch = optional (enum [ "on" "try" "off" ]);
+    recovery_target = optional str;
+    recovery_target_action = optional (enum ["pause" "promote" "shutdown"]);
+    recovery_target_inclusive = optional bool;
+    recovery_target_lsn = optional str;
+    recovery_target_name = optional str;
+    recovery_target_time = optional str;
+    recovery_target_timeline = optional str;
+    recovery_target_xid = optional str;
+    recursive_worktable_factor = optional float;
+    reserved_connections = optional int;
     restart_after_crash = optional bool;
+    restore_command = optional path;
+    row_security = optional bool;
+    scram_iterations = optional int;
     search_path = optional (either (listOf str) str);
     seq_page_cost = optional float;
+    serializable_buffers = optional int;
+    session_preload_libraries = optional (either (listOf str) str);
     session_replication_role = optional (enum [ "origin" "replica" "local" ]);
     shared_buffers = optional int;
+    shared_memory_type = optional (enum [ "sysv" "mmap" ]);
+    shared_preload_libraries = optional (either (listOf str) str);
     sql_inheritance = optional bool;
     ssl = optional bool;
     ssl_ca_file = optional path;
     ssl_cert_file = optional path;
     ssl_ciphers = optional str;
+    ssl_crl_dir = optional path;
     ssl_crl_file = optional path;
+    ssl_dh_params_file = optional str;
     ssl_ecdh_curve = optional str;
+    ssl_groups = optional str;
     ssl_key_file = optional path;
+    ssl_max_protocol_version = optional (enum [ "TLSv1" "TLSv1.1" "TLSv1.2" "TLSv1.3" ]);
+    ssl_min_protocol_version = optional (enum [ "TLSv1" "TLSv1.1" "TLSv1.2" "TLSv1.3" ]);
     ssl_prefer_server_ciphers = optional bool;
     ssl_renegotiation_limit = optional int;
+    ssl_tls13_ciphers = optional str;
     standard_conforming_strings = optional bool;
     statement_timeout = optional int;
+    stats_fetch_consistency = optional (enum [ "none" "cache" "snapshot" ]);
     stats_temp_directory = optional path;
+    subtransaction_buffers = optional int;
+    summarize_wal = optional bool;
     superuser_reserved_connections = optional int;
+    sync_replication_slots = optional bool;
     synchronize_seqscans = optional bool;
-    synchronous_commit = optional (enum [ "on" "remote_write" "local" "off" ]);
+    synchronized_standby_slots = optional (either (listOf str) str);
+    synchronous_commit = optional (enum [ "on" "remote_write" "remote_apply" "local" "off" ]);
     synchronous_standby_names = optional (either (listOf str) str);
+    syslog_facility = optional (enum [ "LOCAL0" "LOCAL1" "LOCAL2" "LOCAL3" "LOCAL4" "LOCAL5" "LOCAL6" "LOCAL7" ]);
     syslog_ident = optional str;
+    syslog_sequence_numbers = optional bool;
+    syslog_split_messages = optional bool;
     tcp_keepalives_count = optional int;
     tcp_keepalives_idle = optional int;
     tcp_keepalives_interval = optional int;
+    tcp_user_timeout = optional int;
     temp_buffers = optional int;
     temp_file_limit = optional int;
     temp_tablespaces = optional str;
@@ -186,30 +316,51 @@ in {
     timezone_abbreviations = optional str;
     track_activities = optional bool;
     track_activity_query_size = optional int;
+    track_commit_timestamp = optional bool;
+    track_cost_delay_timing = optional bool;
     track_counts = optional bool;
     track_functions = optional (enum [ "none" "pl" "all" ]);
     track_io_timing = optional bool;
+    track_wal_io_timing = optional bool;
+    transaction_buffers = optional int;
     transform_null_equals = optional bool;
+    unix_socket_group = optional str;
+    unix_socket_permissions = optional int;
     update_process_title = optional bool;
+    vacuum_buffer_usage_limit = optional int;
     vacuum_cost_delay = optional int;
     vacuum_cost_limit = optional int;
     vacuum_cost_page_dirty = optional int;
     vacuum_cost_page_hit = optional int;
     vacuum_cost_page_miss = optional int;
     vacuum_defer_cleanup_age = optional int;
+    vacuum_failsafe_age = optional int;
     vacuum_freeze_min_age = optional int;
     vacuum_freeze_table_age = optional int;
+    vacuum_max_eager_freeze_failure_rate = optional float;
+    vacuum_multixact_failsafe_age = optional int;
     vacuum_multixact_freeze_min_age = optional int;
     vacuum_multixact_freeze_table_age = optional int;
+    vacuum_truncate = optional bool;
     wal_buffers = optional int;
+    wal_compression = optional (enum [ "pglz" "lz4" "zstd" "off" ]);
+    wal_decode_buffer_size = optional int;
+    wal_init_zero = optional bool;
     wal_keep_segments = optional int;
+    wal_keep_size = optional int;
     wal_level = optional (enum [ "minimal" "replica" "logical" ]);
     wal_log_hints = optional bool;
+    wal_receiver_create_temp_slot = optional bool;
     wal_receiver_status_interval = optional int;
     wal_receiver_timeout = optional int;
+    wal_recycle = optional bool;
+    wal_retrieve_retry_interval = optional int;
     wal_sender_timeout = optional int;
+    wal_skip_threshold = optional int;
+    wal_summary_keep_time = optional int;
     wal_sync_method = optional (enum [ "open_datasync" "fdatasync" "fsync" "fsync_writethrough" "open_sync" ]);
     wal_writer_delay = optional int;
+    wal_writer_flush_after = optional int;
     work_mem = optional int;
     xmlbinary = optional (enum [ "base64" "hex" ]);
     xmloption = optional (enum [ "DOCUMENT" "CONTENT" ]);