Hi I used regex search: ".*GUCNAME to find how each GUCNAME is used in messages in *.c files. GUC names are taken from the guc_tables.c code, so are grouped accordingly below. I've categorised them as being currently QUOTED, NOT QUOTED, and NONE (many are not used in any messages). ~TOTALS: messages where GUC names are quoted: - bool = 11 - int = 11 - real = 0 - string = 10 - enum = 7 - TOTAL = 39 messages where GUC names are NOT quoted: - bool = 14 - int = 60 - real = 0 - string = 59 - enum = 31 - TOTAL = 164 Details below... /////////////////////////// ------------------ ConfigureNamesBool ------------------ {"enable_seqscan", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_indexscan", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_indexonlyscan", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_bitmapscan", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_tidscan", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_sort", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_incremental_sort", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_hashagg", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_material", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_memoize", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_nestloop", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_mergejoin", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_hashjoin", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_gathermerge", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_partitionwise_join", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_partitionwise_aggregate", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_parallel_append", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_parallel_hash", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_partition_pruning", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_presorted_aggregate", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"enable_async_append", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"geqo", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"is_superuser", PGC_INTERNAL, UNGROUPED, - NONE {"bonjour", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE {"track_commit_timestamp", PGC_POSTMASTER, REPLICATION_SENDING, - QUOTED errhint("Make sure the configuration parameter \"%s\" is set on the primary server.", "track_commit_timestamp") : errhint("Make sure the configuration parameter \"%s\" is set.", "track_commit_timestamp"))); {"ssl", PGC_SIGHUP, CONN_AUTH_SSL, - NOT QUOTED errhint("Set ssl = on in postgresql.conf."), {"ssl_passphrase_command_supports_reload", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_prefer_server_ciphers", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"fsync", PGC_SIGHUP, WAL_SETTINGS, - NONE {"zero_damaged_pages", PGC_SUSET, DEVELOPER_OPTIONS, - NOT QUOTED gettext_noop(... Setting " "zero_damaged_pages to true causes the system to instead report a "... {"ignore_invalid_pages", PGC_POSTMASTER, DEVELOPER_OPTIONS, - NOT QUOTED gettext_noop(... "Setting ignore_invalid_pages to true causes " {"full_page_writes", PGC_SIGHUP, WAL_SETTINGS, - NOT QUOTED errmsg("WAL generated with full_page_writes=off was replayed ""since last restartpoint"), errhint(... "Enable full_page_writes and run CHECKPOINT on the primary, ""and then try an online backup again."))); errmsg("WAL generated with full_page_writes=off was replayed ""during online backup"),\ errhint(... "Enable full_page_writes and run CHECKPOINT on the primary, " "and then try an online backup again."))); pg_fatal("full_page_writes must be enabled in the source server"); {"wal_log_hints", PGC_POSTMASTER, WAL_SETTINGS, - QUOTED, but this quotes everything -- not just the GUC name "target server needs to use either data checksums or \"wal_log_hints = on\""); {"wal_init_zero", PGC_SUSET, WAL_SETTINGS, - NONE {"wal_recycle", PGC_SUSET, WAL_SETTINGS, - NONE {"log_checkpoints", PGC_SIGHUP, LOGGING_WHAT, - NONE {"log_connections", PGC_SU_BACKEND, LOGGING_WHAT, - NONE {"log_disconnections", PGC_SU_BACKEND, LOGGING_WHAT, - NONE {"log_replication_commands", PGC_SUSET, LOGGING_WHAT, - NONE {"debug_assertions", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"exit_on_error", PGC_USERSET, ERROR_HANDLING_OPTIONS, - NONE {"restart_after_crash", PGC_SIGHUP, ERROR_HANDLING_OPTIONS, - NOT QUOTED (errmsg("shutting down because restart_after_crash is off"))); {"remove_temp_files_after_crash", PGC_SIGHUP, DEVELOPER_OPTIONS, - NONE {"send_abort_for_crash", PGC_SIGHUP, DEVELOPER_OPTIONS, - NONE {"send_abort_for_kill", PGC_SIGHUP, DEVELOPER_OPTIONS, - NONE {"log_duration", PGC_SUSET, LOGGING_WHAT, - NONE {"debug_print_parse", PGC_USERSET, LOGGING_WHAT, - NONE {"debug_print_rewritten", PGC_USERSET, LOGGING_WHAT, - NONE {"debug_print_plan", PGC_USERSET, LOGGING_WHAT, - NONE {"debug_pretty_print", PGC_USERSET, LOGGING_WHAT, - NONE {"log_parser_stats", PGC_SUSET, STATS_MONITORING, - QUOTED GUC_check_errdetail("Cannot enable \"log_statement_stats\" when ""\"log_parser_stats\", \"log_planner_stats\", ""or \"log_executor_stats\" is true."); {"log_planner_stats", PGC_SUSET, STATS_MONITORING, - QUOTED GUC_check_errdetail("Cannot enable \"log_statement_stats\" when ""\"log_parser_stats\", \"log_planner_stats\", ""or \"log_executor_stats\" is true."); {"log_executor_stats", PGC_SUSET, STATS_MONITORING, - QUOTED GUC_check_errdetail("Cannot enable \"log_statement_stats\" when ""\"log_parser_stats\", \"log_planner_stats\", ""or \"log_executor_stats\" is true.") {"log_statement_stats", PGC_SUSET, STATS_MONITORING, - QUOTED GUC_check_errdetail("Cannot enable parameter when \"log_statement_stats\" is true."); GUC_check_errdetail("Cannot enable \"log_statement_stats\" when ""\"log_parser_stats\", \"log_planner_stats\", ""or \"log_executor_stats\" is true."); {"log_btree_build_stats", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"track_activities", PGC_SUSET, STATS_CUMULATIVE, - NONE {"track_counts", PGC_SUSET, STATS_CUMULATIVE, - NONE {"track_io_timing", PGC_SUSET, STATS_CUMULATIVE, - NONE {"track_wal_io_timing", PGC_SUSET, STATS_CUMULATIVE, - NONE {"update_process_title", PGC_SUSET, PROCESS_TITLE, - NONE {"autovacuum", PGC_SIGHUP, AUTOVACUUM, - NONE {"trace_notify", PGC_USERSET, DEVELOPER_OPTIONS, - NONE {"trace_locks", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"trace_userlocks", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"trace_lwlocks", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"debug_deadlocks", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"log_lock_waits", PGC_SUSET, LOGGING_WHAT, - NONE {"log_recovery_conflict_waits", PGC_SIGHUP, LOGGING_WHAT, - NONE {"log_hostname", PGC_SIGHUP, LOGGING_WHAT, - NONE {"transform_null_equals", PGC_USERSET, COMPAT_OPTIONS_CLIENT, - NONE {"db_user_namespace", PGC_SIGHUP, CONN_AUTH_AUTH, - QUOTED errmsg("MD5 authentication is not supported when \"db_user_namespace\" is enabled"))) errmsg("MD5 authentication is not supported when \"db_user_namespace\" is enabled"), *err_msg = "MD5 authentication is not supported when \"db_user_namespace\" is enabled"; {"default_transaction_read_only", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"transaction_read_only", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"default_transaction_deferrable", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"transaction_deferrable", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"row_security", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"check_function_bodies", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"array_nulls", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"default_with_oids", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"logging_collector", PGC_POSTMASTER, LOGGING_WHERE, - NONE {"log_truncate_on_rotation", PGC_SIGHUP, LOGGING_WHERE, - NONE {"trace_sort", PGC_USERSET, DEVELOPER_OPTIONS, - NONE {"trace_syncscan", PGC_USERSET, DEVELOPER_OPTIONS, - NONE "optimize_bounded_sort", PGC_USERSET, QUERY_TUNING_METHOD, - NONE {"wal_debug", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"integer_datetimes", PGC_INTERNAL, PRESET_OPTIONS, - NOT QUOTED pg_log_error("could not determine server setting for integer_datetimes"); pg_log_error("integer_datetimes compile flag does not match server"); {"krb_caseins_users", PGC_SIGHUP, CONN_AUTH_AUTH, - NONE {"gss_accept_delegation", PGC_SIGHUP, CONN_AUTH_AUTH, - NONE {"escape_string_warning", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"standard_conforming_strings", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NOT QUOTED errdetail("String constants with Unicode escapes cannot be used when standard_conforming_strings is off."), pg_log_info("saving standard_conforming_strings = %s", stdstrings); {"synchronize_seqscans", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"recovery_target_inclusive", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NONE {"hot_standby", PGC_POSTMASTER, REPLICATION_STANDBY, - NONE {"hot_standby_feedback", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"in_hot_standby", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"allow_system_table_mods", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"ignore_system_indexes", PGC_BACKEND, DEVELOPER_OPTIONS, - NONE {"allow_in_place_tablespaces", PGC_SUSET, DEVELOPER_OPTIONS, - NOT QUOTED errhint("Remove those directories, or set allow_in_place_tablespaces to ON transiently to let recovery complete."))); {"lo_compat_privileges", PGC_SUSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"quote_all_identifiers", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"data_checksums", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"syslog_sequence_numbers", PGC_SIGHUP, LOGGING_WHERE, - NONE {"syslog_split_messages", PGC_SIGHUP, LOGGING_WHERE, - NONE {"parallel_leader_participation", PGC_USERSET, RESOURCES_ASYNCHRONOUS, - NONE {"jit", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"jit_debugging_support", PGC_SU_BACKEND, DEVELOPER_OPTIONS, - NONE {"jit_dump_bitcode", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"jit_expressions", PGC_USERSET, DEVELOPER_OPTIONS, - NONE {"jit_profiling_support", PGC_SU_BACKEND, DEVELOPER_OPTIONS, - NONE {"jit_tuple_deforming", PGC_USERSET, DEVELOPER_OPTIONS, - NONE {"data_sync_retry", PGC_POSTMASTER, ERROR_HANDLING_OPTIONS, - NONE {"wal_receiver_create_temp_slot", PGC_SIGHUP, REPLICATION_STANDBY, - NONE ~~~ ----------------- ConfigureNamesInt ----------------- {"archive_timeout", PGC_SIGHUP, WAL_ARCHIVING, - NOT QUOTED elog(DEBUG1, "write-ahead log switch forced (archive_timeout=%d)", XLogArchiveTimeout); {"post_auth_delay", PGC_BACKEND, DEVELOPER_OPTIONS, - NONE {"default_statistics_target", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"from_collapse_limit", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"join_collapse_limit", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"geqo_threshold", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"geqo_effort", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"geqo_pool_size", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"geqo_generations", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"deadlock_timeout", PGC_SUSET, LOCK_MANAGEMENT, - NONE {"max_standby_archive_delay", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"max_standby_streaming_delay", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"recovery_min_apply_delay", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"wal_receiver_status_interval", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"wal_receiver_timeout", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"max_connections", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NOT QUOTED errhint(...consumption of semaphores by reducing its max_connections parameter.\n" "The PostgreSQL documentation contains more information about "... errhint("This error usually means that PostgreSQL's request ... perhaps by reducing shared_buffers or ""max_connections.", write_stderr("%s: superuser_reserved_connections (%d) plus reserved_connections (%d) must be less than max_connections (%d)\n", errhint("You might need to run fewer transactions at a time or increase max_connections."))); errhint("You might need to run fewer transactions at a time or increase max_connections."))); printf(_("selecting default max_connections ... ")); {"superuser_reserved_connections", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NOT QUOTED write_stderr("%s: superuser_reserved_connections (%d) plus reserved_connections (%d) must be less than max_connections (%d)\n", {"reserved_connections", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NOT QUOTED write_stderr("%s: superuser_reserved_connections (%d) plus reserved_connections (%d) must be less than max_connections (%d)\n", {"min_dynamic_shared_memory", PGC_POSTMASTER, RESOURCES_MEM, - NONE {"shared_buffers", PGC_POSTMASTER, RESOURCES_MEM, - NOT QUOTED errhint("This error usually means that PostgreSQL's request "..."memory usage, perhaps by reducing shared_buffers or ""max_connections.", printf(_("selecting default shared_buffers ... ")); {"vacuum_buffer_usage_limit", PGC_USERSET, RESOURCES_MEM, - QUOTED GUC_check_errdetail("\"vacuum_buffer_usage_limit\" must be 0 or between %d kB and %d kB",MIN_BAS_VAC_RING_SIZE_KB, MAX_BAS_VAC_RING_SIZE_KB); {"shared_memory_size", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"shared_memory_size_in_huge_pages", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"temp_buffers", PGC_USERSET, RESOURCES_MEM, - QUOTED GUC_check_errdetail("\"temp_buffers\" cannot be changed after any temporary tables have been accessed in the session."); {"port", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE? {"unix_socket_permissions", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE {"log_file_mode", PGC_SIGHUP, LOGGING_WHERE, - NONE {"data_directory_mode", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"work_mem", PGC_USERSET, RESOURCES_MEM, - NOT QUOTED gettext_noop("Multiple of work_mem to use for hash tables."), {"maintenance_work_mem", PGC_USERSET, RESOURCES_MEM, - NOT QUOTED errhint("Reduce maintenance_work_mem."))); - QUOTED errhint("Consider increasing configuration parameter \"maintenance_work_mem\" or \"autovacuum_work_mem\".\n" {"logical_decoding_work_mem", PGC_USERSET, RESOURCES_MEM, - NONE {"max_stack_depth", PGC_SUSET, RESOURCES_MEM, - QUOTED errhint("Increase the configuration parameter \"max_stack_depth\" (currently %dkB), ""after ensuring the platform's stack depth limit is adequate.", GUC_check_errdetail("\"max_stack_depth\" must not exceed %ldkB.",(stack_rlimit - STACK_DEPTH_SLOP) / 1024L); {"temp_file_limit", PGC_SUSET, RESOURCES_DISK, - NONE {"vacuum_cost_page_hit", PGC_USERSET, RESOURCES_VACUUM_DELAY, - NONE {"vacuum_cost_page_miss", PGC_USERSET, RESOURCES_VACUUM_DELAY, - NONE {"vacuum_cost_page_dirty", PGC_USERSET, RESOURCES_VACUUM_DELAY, - NONE {"vacuum_cost_limit", PGC_USERSET, RESOURCES_VACUUM_DELAY, - NONE {"autovacuum_vacuum_cost_limit", PGC_SIGHUP, AUTOVACUUM, - NONE {"max_files_per_process", PGC_POSTMASTER, RESOURCES_KERNEL, - NONE {"max_prepared_transactions", PGC_POSTMASTER, RESOURCES_MEM, - NOT QUOTED errhint("Set max_prepared_transactions to a nonzero value."))); errhint("Increase max_prepared_transactions (currently %d).", max_prepared_xacts))); errhint("Increase max_prepared_transactions (currently %d).", max_prepared_xacts))); {"trace_lock_oidmin", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"trace_lock_table", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"statement_timeout", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"lock_timeout", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"idle_in_transaction_session_timeout", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"idle_session_timeout", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"vacuum_freeze_min_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"vacuum_freeze_table_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"vacuum_multixact_freeze_min_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED errhint("Execute a database-wide VACUUM in database with OID %u with reduced vacuum_multixact_freeze_min_age and... errhint("Execute a database-wide VACUUM in that database with reduced vacuum_multixact_freeze_min_age and... {"vacuum_multixact_freeze_table_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED errhint(... with OID %u with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings.", errhint(... with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings."))); {"vacuum_failsafe_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"vacuum_multixact_failsafe_age", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"max_locks_per_transaction", PGC_POSTMASTER, LOCK_MANAGEMENT, - NOT QUOTED errhint("You might need to increase %s.", "max_locks_per_transaction"))); errhint("You might need to increase %s.", "max_locks_per_transaction"))); errhint("You might need to increase %s.", "max_locks_per_transaction"))); errhint("You might need to increase %s.", "max_locks_per_transaction"))); errhint("You might need to increase %s.", "max_locks_per_transaction"))); errhint("You might need to increase %s.", "max_locks_per_transaction"))); gettext_noop(... "max_locks_per_transaction objects per server process or prepared "...) {"max_pred_locks_per_transaction", PGC_POSTMASTER, LOCK_MANAGEMENT, - NOT QUOTED errhint("You might need to increase %s.", "max_pred_locks_per_transaction"))); errhint("You might need to increase %s.", "max_pred_locks_per_transaction"))); errhint("You might need to increase %s.", "max_pred_locks_per_transaction"))); gettext_noop(..."at most max_pred_locks_per_transaction objects per server process "...) {"max_pred_locks_per_relation", PGC_SIGHUP, LOCK_MANAGEMENT, - NONE {"max_pred_locks_per_page", PGC_SIGHUP, LOCK_MANAGEMENT, - NONE {"authentication_timeout", PGC_SIGHUP, CONN_AUTH_AUTH, - NONE {"pre_auth_delay", PGC_SIGHUP, DEVELOPER_OPTIONS, - NONE {"wal_decode_buffer_size", PGC_POSTMASTER, WAL_RECOVERY, - NONE {"wal_keep_size", PGC_SIGHUP, REPLICATION_SENDING, - NONE {"min_wal_size", PGC_SIGHUP, WAL_CHECKPOINTS, - QUOTED errmsg("\"min_wal_size\" must be at least twice \"wal_segment_size\""))); {"max_wal_size", PGC_SIGHUP, WAL_CHECKPOINTS, - QUOTED errmsg("\"max_wal_size\" must be at least twice \"wal_segment_size\""))); errhint("Consider increasing the configuration parameter \"max_wal_size\"."))); {"checkpoint_timeout", PGC_SIGHUP, WAL_CHECKPOINTS, - NONE {"checkpoint_warning", PGC_SIGHUP, WAL_CHECKPOINTS, - NONE {"checkpoint_flush_after", PGC_SIGHUP, WAL_CHECKPOINTS, - NONE {"wal_buffers", PGC_POSTMASTER, WAL_SETTINGS, - NONE {"wal_writer_delay", PGC_SIGHUP, WAL_SETTINGS, - NONE {"wal_writer_flush_after", PGC_SIGHUP, WAL_SETTINGS, - NONE {"wal_skip_threshold", PGC_USERSET, WAL_SETTINGS, - NONE {"max_wal_senders", PGC_POSTMASTER, REPLICATION_SENDING, - NOT QUOTED (errmsg("WAL streaming (max_wal_senders > 0) requires wal_level \"replica\" or \"logical\""))); errmsg("number of requested standby connections exceeds max_wal_senders (currently %d)", max_wal_senders))); {"max_replication_slots", PGC_POSTMASTER, REPLICATION_SENDING, - NOT QUOTED errhint("Free one or increase max_replication_slots."))); errmsg("replication slots can only be used if max_replication_slots > 0"))); errhint("Increase max_replication_slots and try again."))); errmsg("cannot start logical replication workers when max_replication_slots = 0"))); errmsg("cannot query or manipulate replication origin when max_replication_slots = 0"))); errmsg("could not find free replication state, increase max_replication_slots"))); errhint("Increase max_replication_slots and try again."))); errhint("Increase max_replication_slots and try again."))); {"max_slot_wal_keep_size", PGC_SIGHUP, REPLICATION_SENDING, - NOT QUOTED hint ? errhint("You might need to increase %s.", "max_slot_wal_keep_size") : 0); {"wal_sender_timeout", PGC_USERSET, REPLICATION_SENDING, - NONE {"commit_delay", PGC_SUSET, WAL_SETTINGS, - NOT QUOTED gettext_noop("Sets the minimum number of concurrent open transactions ""required before performing commit_delay.") {"commit_siblings", PGC_USERSET, WAL_SETTINGS, - NONE {"extra_float_digits", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"log_min_duration_sample", PGC_SUSET, LOGGING_WHEN, - NOT QUOTED gettext_noop("Fraction of statements exceeding log_min_duration_sample to be logged."), {"log_min_duration_statement", PGC_SUSET, LOGGING_WHEN, - NONE {"log_autovacuum_min_duration", PGC_SIGHUP, LOGGING_WHAT, - NONE {"log_parameter_max_length", PGC_SUSET, LOGGING_WHAT, - NONE {"log_parameter_max_length_on_error", PGC_USERSET, LOGGING_WHAT, - NONE {"bgwriter_delay", PGC_SIGHUP, RESOURCES_BGWRITER, - NONE {"bgwriter_lru_maxpages", PGC_SIGHUP, RESOURCES_BGWRITER, - NONE {"bgwriter_flush_after", PGC_SIGHUP, RESOURCES_BGWRITER, - NONE {"effective_io_concurrency", - NOT QUOTED GUC_check_errdetail("effective_io_concurrency must be set to 0 on platforms that lack posix_fadvise()."); gettext_noop("A variant of effective_io_concurrency that is used for maintenance work."), {"maintenance_io_concurrency", - NOT QUOTED GUC_check_errdetail("maintenance_io_concurrency must be set to 0 on platforms that lack posix_fadvise()."); {"backend_flush_after", PGC_USERSET, RESOURCES_ASYNCHRONOUS, - NONE {"max_worker_processes", - NOT QUOTED, but note probably some of these should be making use of common style "You may need to increase %s." errhint("You may need to increase max_worker_processes."))); errhint("Consider increasing configuration parameter \"max_worker_processes\"."))); (errmsg("inconsistent background worker state (max_worker_processes=%d, total_slots=%d)",...))); errhint("Consider increasing the configuration parameter \"max_worker_processes\"."))); errhint("You might need to increase %s.", "max_worker_processes"))); errhint("You may need to increase max_worker_processes."))); {"max_logical_replication_workers", - NOT QUOTED errhint("You might need to increase %s.", "max_logical_replication_workers"))); {"max_sync_workers_per_subscription", - NONE {"max_parallel_apply_workers_per_subscription", - NONE {"log_rotation_age", PGC_SIGHUP, LOGGING_WHERE, - NONE {"log_rotation_size", PGC_SIGHUP, LOGGING_WHERE, - NONE {"max_function_args", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"max_index_keys", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"max_identifier_length", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"block_size", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"segment_size", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"wal_block_size", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"wal_retrieve_retry_interval", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"wal_segment_size", PGC_INTERNAL, PRESET_OPTIONS, - QUOTED errmsg("\"min_wal_size\" must be at least twice \"wal_segment_size\""))); errmsg("\"max_wal_size\" must be at least twice \"wal_segment_size\""))); {"autovacuum_naptime", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_vacuum_threshold", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_vacuum_insert_threshold", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_analyze_threshold", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_freeze_max_age", PGC_POSTMASTER, AUTOVACUUM, - NONE {"autovacuum_multixact_freeze_max_age", PGC_POSTMASTER, AUTOVACUUM, - NONE {"autovacuum_max_workers", PGC_POSTMASTER, AUTOVACUUM, - NONE {"max_parallel_maintenance_workers", PGC_USERSET, RESOURCES_ASYNCHRONOUS, - NONE {"max_parallel_workers_per_gather", PGC_USERSET, RESOURCES_ASYNCHRONOUS, - NONE {"max_parallel_workers", PGC_USERSET, RESOURCES_ASYNCHRONOUS, - NONE {"autovacuum_work_mem", PGC_SIGHUP, RESOURCES_MEM, - QUOTED errhint("Consider increasing configuration parameter \"maintenance_work_mem\" or \"autovacuum_work_mem\".\n"...))); {"old_snapshot_threshold", PGC_POSTMASTER, RESOURCES_ASYNCHRONOUS, - NONE {"tcp_keepalives_idle", PGC_USERSET, CONN_AUTH_TCP, - NONE {"tcp_keepalives_interval", PGC_USERSET, CONN_AUTH_TCP, - NONE {"ssl_renegotiation_limit", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"tcp_keepalives_count", PGC_USERSET, CONN_AUTH_TCP, - NONE {"gin_fuzzy_search_limit", PGC_USERSET, CLIENT_CONN_OTHER, - NONE {"effective_cache_size", PGC_USERSET, QUERY_TUNING_COST, - NONE {"min_parallel_table_scan_size", PGC_USERSET, QUERY_TUNING_COST, - NONE {"min_parallel_index_scan_size", PGC_USERSET, QUERY_TUNING_COST, - NONE {"server_version_num", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"log_temp_files", PGC_SUSET, LOGGING_WHAT, - NONE {"gin_pending_list_limit", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"tcp_user_timeout", PGC_USERSET, CONN_AUTH_TCP, - NOT QUOTED, althought I am not sure if this really is the GUC (errmsg("%s(%s) failed: %m", "getsockopt", "TCP_USER_TIMEOUT"))); (errmsg("%s(%s) failed: %m", "setsockopt", "TCP_USER_TIMEOUT"))); (errmsg("%s(%s) not supported", "setsockopt", "TCP_USER_TIMEOUT"))); {"huge_page_size", PGC_POSTMASTER, RESOURCES_MEM, - NOT QUOTED GUC_check_errdetail("huge_page_size must be 0 on this platform."); GUC_check_errdetail("huge_page_size must be 0 on this platform."); {"debug_discard_caches", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"client_connection_check_interval", PGC_USERSET, CONN_AUTH_TCP, - NOT QUOTED GUC_check_errdetail("client_connection_check_interval must be set to 0 on this platform."); {"log_startup_progress_interval", PGC_SIGHUP, LOGGING_WHEN, - NONE {"scram_iterations", PGC_USERSET, CONN_AUTH_AUTH, - NONE ~~~ ------------------ ConfigureNamesReal ------------------ {"seq_page_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"random_page_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"cpu_tuple_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"cpu_index_tuple_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"cpu_operator_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"parallel_tuple_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"parallel_setup_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"jit_above_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"jit_optimize_above_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"jit_inline_above_cost", PGC_USERSET, QUERY_TUNING_COST, - NONE {"cursor_tuple_fraction", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"recursive_worktable_factor", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"geqo_selection_bias", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"geqo_seed", PGC_USERSET, QUERY_TUNING_GEQO, - NONE {"hash_mem_multiplier", PGC_USERSET, RESOURCES_MEM, - NONE {"bgwriter_lru_multiplier", PGC_SIGHUP, RESOURCES_BGWRITER, - NONE {"seed", PGC_USERSET, UNGROUPED, - NONE? {"vacuum_cost_delay", PGC_USERSET, RESOURCES_VACUUM_DELAY, - NONE {"autovacuum_vacuum_cost_delay", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_vacuum_scale_factor", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_vacuum_insert_scale_factor", PGC_SIGHUP, AUTOVACUUM, - NONE {"autovacuum_analyze_scale_factor", PGC_SIGHUP, AUTOVACUUM, - NONE {"checkpoint_completion_target", PGC_SIGHUP, WAL_CHECKPOINTS, - NONE {"log_statement_sample_rate", PGC_SUSET, LOGGING_WHEN, - NONE {"log_transaction_sample_rate", PGC_SUSET, LOGGING_WHEN, - NONE ~~~ -------------------- ConfigureNamesString -------------------- {"archive_command", PGC_SIGHUP, WAL_ARCHIVING, - NOT QUOTED errhint("Check that your archive_command is executing properly. " errmsg("both archive_command and archive_library set"), errdetail("Only one of archive_command, archive_library may be set."))); errmsg("both archive_command and archive_library set"), errdetail("Only one of archive_command, archive_library may be set."))); gettext_noop("Allows archiving of WAL files using archive_command."), - QUOTED gettext_noop("An empty string indicates that \"archive_command\" should be used.") {"archive_library", PGC_SIGHUP, WAL_ARCHIVING, - NOT QUOTED errmsg("both archive_command and archive_library set"), errdetail("Only one of archive_command, archive_library may be set."))); errmsg("both archive_command and archive_library set"), errdetail("Only one of archive_command, archive_library may be set."))) - QUOTED (errmsg("restarting archiver process because value of " "\"archive_library\" was changed"))); gettext_noop("This is used only if \"archive_library\" is not set.") {"restore_command", PGC_SIGHUP, WAL_ARCHIVE_RECOVERY, - NOT QUOTED errdetail("restore_command returned a zero exit status, but stat() failed."))); (errmsg("specified neither primary_conninfo nor restore_command"), errmsg("must specify restore_command when standby mode is not enabled"))); pg_fatal("restore_command is not set in the target cluster"); pg_log_debug("using for rewind restore_command = \'%s\'", pg_fatal("restore_command failed: %s", wait_result_to_str(rc)); {"archive_cleanup_command", PGC_SIGHUP, WAL_ARCHIVE_RECOVERY, - NONE {"recovery_end_command", PGC_SIGHUP, WAL_ARCHIVE_RECOVERY, - NOT QUOTED (errmsg("%s \"%s\": %s", commandName, command, wait_result_to_str(rc)))); {"recovery_target_timeline", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED GUC_check_errdetail("recovery_target_timeline is not a valid number."); {"recovery_target", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED errdetail("At most one of recovery_target, recovery_target_lsn, recovery_target_name, recovery_target_time, recovery_target_xid may be set."))); GUC_check_errdetail("%s is too long (maximum %d characters).", "recovery_target_name", MAXFNAMELEN - 1) GUC_check_errdetail("recovery_target_timeline is not a valid number."); {"recovery_target_xid", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED errdetail("At most one of recovery_target, recovery_target_lsn, recovery_target_name, recovery_target_time, recovery_target_xid may be set."))); {"recovery_target_time", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED errdetail("At most one of recovery_target, recovery_target_lsn, recovery_target_name, recovery_target_time, recovery_target_xid may be set."))); GUC_check_errdetail("recovery_target_timeline is not a valid number."); {"recovery_target_name", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED errdetail("At most one of recovery_target, recovery_target_lsn, recovery_target_name, recovery_target_time, recovery_target_xid may be set."))); GUC_check_errdetail("%s is too long (maximum %d characters).", "recovery_target_name", MAXFNAMELEN - 1); {"recovery_target_lsn", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NOT QUOTED errdetail("At most one of recovery_target, recovery_target_lsn, recovery_target_name, recovery_target_time, recovery_target_xid may be set."))); {"primary_conninfo", PGC_SIGHUP, REPLICATION_STANDBY, - NOT QUOTED (errmsg("specified neither primary_conninfo nor restore_command"), {"primary_slot_name", PGC_SIGHUP, REPLICATION_STANDBY, - NONE {"client_encoding", PGC_USERSET, CLIENT_CONN_LOCALE, - QUOTED GUC_check_errdetail("Cannot change \"client_encoding\" now."); - NOT QUOTED errmsg("cannot change client_encoding during a parallel operation"))); {"log_line_prefix", PGC_SIGHUP, LOGGING_WHAT, - NONE {"log_timezone", PGC_SIGHUP, LOGGING_WHAT, - NONE {"DateStyle", PGC_USERSET, CLIENT_CONN_LOCALE, - QUOTED, and note the case is difference from the GUC GUC_check_errdetail("Conflicting \"datestyle\" specifications."); errhint("Perhaps you need a different \"datestyle\" setting."))); {"default_table_access_method", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED GUC_check_errdetail("%s cannot be empty.", "default_table_access_method"); GUC_check_errdetail("%s is too long (maximum %d characters).", "default_table_access_method", NAMEDATALEN - 1); warn_or_exit_horribly(AH, "could not set default_table_access_method: %s", PQerrorMessage(AH->connection)); {"default_tablespace", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED warn_or_exit_horribly(AH, "could not set default_tablespace to %s: %s", fmtId(want), PQerrorMessage(AH->connection)); {"temp_tablespaces", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"createrole_self_grant", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"dynamic_library_path", PGC_SUSET, CLIENT_CONN_OTHER, - QUOTED errmsg("zero-length component in parameter \"dynamic_library_path\""))); errmsg("component in parameter \"dynamic_library_path\" is not an absolute path"))); {"krb_server_keyfile", PGC_SIGHUP, CONN_AUTH_AUTH, - NONE {"bonjour_name", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE {"lc_messages", PGC_SUSET, CLIENT_CONN_LOCALE, - NOT QUOTED pg_fatal("failed to set lc_messages: %s", PQerrorMessage(conn)); {"lc_monetary", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"lc_numeric", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"lc_time", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"session_preload_libraries", PGC_SUSET, CLIENT_CONN_PRELOAD, - NONE {"shared_preload_libraries", PGC_POSTMASTER, CLIENT_CONN_PRELOAD, - NOT QUOTED errmsg("pg_stat_statements must be loaded via shared_preload_libraries"))); errmsg("pg_stat_statements must be loaded via shared_preload_libraries"))); errmsg("pg_stat_statements must be loaded via shared_preload_libraries"))); errmsg("sepgsql must be loaded via shared_preload_libraries"))); errhint("Include the extension module that implements this resource manager in shared_preload_libraries."))); errdetail("Custom resource manager must be registered while initializing modules in shared_preload_libraries."))); errmsg("background worker \"%s\": must be registered in shared_preload_libraries", worker->bgw_name))); errdetail("\"%s\" must be loaded with shared_preload_libraries.", "test_slru"))) {"local_preload_libraries", PGC_USERSET, CLIENT_CONN_PRELOAD, - NONE {"search_path", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED pg_log_error("could not clear search_path: %s", PQerrorMessage(conn)); pg_log_error("failed to set search_path: %s", PQerrorMessage(conn)); pg_log_error("could not clear search_path: %s", PQerrorMessage(tmpconn)); warn_or_exit_horribly(AH, "could not set search_path to \"%s\": %s", schemaName, PQerrorMessage(AH->connection)); pg_log_info("saving search_path = %s", path->data); pg_fatal("could not clear search_path: %s", PQresultErrorMessage(res)); pg_log_error("no pgbench_accounts table found in search_path"); {"server_encoding", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"server_version", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"role", PGC_USERSET, UNGROUPED, - NONE? {"session_authorization", PGC_USERSET, UNGROUPED, - NONE {"log_destination", PGC_SIGHUP, LOGGING_WHERE, - NONE {"log_directory", PGC_SIGHUP, LOGGING_WHERE, - NONE {"log_filename", PGC_SIGHUP, LOGGING_WHERE, - NOT QUOTED errmsg("the log_filename parameter must equal 'postgresql-%%Y-%%m-%%d_%%H%%M%%S.log'"))) {"syslog_ident", PGC_SIGHUP, LOGGING_WHERE, - NONE {"event_source", PGC_POSTMASTER, LOGGING_WHERE, - NONE {"TimeZone", PGC_USERSET, CLIENT_CONN_LOCALE, - NOT QUOTED, need to re-check are these really the GUC name elog(ERROR, "unrecognized timezone type %d", (int) tp->type); (errmsg_internal("timezone directory stack overflow"))); {"timezone_abbreviations", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"unix_socket_group", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NOT QUOTED elog(WARNING, "configuration item unix_socket_group is not supported on this platform"); {"unix_socket_directories", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE {"listen_addresses", PGC_POSTMASTER, CONN_AUTH_SETTINGS, - NONE {"data_directory", PGC_POSTMASTER, FILE_LOCATIONS, - QUOTED write_stderr(... "This can be specified as \"data_directory\" in \"%s\", " ... {"config_file", PGC_POSTMASTER, FILE_LOCATIONS, - NONE {"hba_file", PGC_POSTMASTER, FILE_LOCATIONS, - QUOTED write_stderr(... "This can be specified as \"hba_file\" in \"%s\", "... {"ident_file", PGC_POSTMASTER, FILE_LOCATIONS, - QUOTED write_stderr(... "This can be specified as \"ident_file\" in \"%s\", "... {"external_pid_file", PGC_POSTMASTER, FILE_LOCATIONS, - NONE {"ssl_library", PGC_INTERNAL, PRESET_OPTIONS, - NONE {"ssl_cert_file", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_key_file", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_ca_file", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_crl_file", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_crl_dir", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"synchronous_standby_names", PGC_SIGHUP, REPLICATION_PRIMARY, - NOT QUOTED GUC_check_errdetail("synchronous_standby_names parser failed"); {"default_text_search_config", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"ssl_ciphers", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_ecdh_curve", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_dh_params_file", PGC_SIGHUP, CONN_AUTH_SSL, - NONE {"ssl_passphrase_command", PGC_SIGHUP, CONN_AUTH_SSL, - NOT QUOTED gettext_noop("Controls whether ssl_passphrase_command is called during server reload."), (errmsg("ssl_passphrase_command setting ignored by ssl_passphrase_func module"))); {"application_name", PGC_USERSET, LOGGING_WHAT, - NONE {"cluster_name", PGC_POSTMASTER, PROCESS_TITLE, - NONE {"wal_consistency_checking", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"jit_provider", PGC_POSTMASTER, CLIENT_CONN_PRELOAD, - NONE {"backtrace_functions", PGC_SUSET, DEVELOPER_OPTIONS, - NONE {"debug_io_direct", PGC_POSTMASTER, DEVELOPER_OPTIONS, - NOT QUOTED GUC_check_errdetail("debug_io_direct is not supported on this platform.") GUC_check_errdetail("debug_io_direct is not supported for WAL because XLOG_BLCKSZ is too small"); GUC_check_errdetail("debug_io_direct is not supported for data because BLCKSZ is too small"); - QUOTED GUC_check_errdetail("invalid list syntax in parameter \"%s\"", "debug_io_direct"); ~~~ ------------------ ConfigureNamesEnum ------------------ {"backslash_quote", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS, - NONE {"bytea_output", PGC_USERSET, CLIENT_CONN_STATEMENT, - NOT QUOTED elog(ERROR, "unrecognized bytea_output setting: %d", {"client_min_messages", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"compute_query_id", PGC_SUSET, STATS_MONITORING, - NONE {"constraint_exclusion", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"default_toast_compression", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"default_transaction_isolation", PGC_USERSET, CLIENT_CONN_STATEMENT, - QUOTED errdetail("\"default_transaction_isolation\" is set to \"serializable\"."), {"transaction_isolation", PGC_USERSET, CLIENT_CONN_STATEMENT, - QUOTED errdetail("\"default_transaction_isolation\" is set to \"serializable\"."), {"IntervalStyle", PGC_USERSET, CLIENT_CONN_LOCALE, - NONE {"icu_validation_level", PGC_USERSET, CLIENT_CONN_LOCALE, - QUOTED errhint("To disable ICU locale validation, set the parameter \"%s\" to \"%s\".", "icu_validation_level", "disabled"))); errhint("To disable ICU locale validation, set the parameter \"%s\" to \"%s\".", "icu_validation_level", "disabled"))); {"log_error_verbosity", PGC_SUSET, LOGGING_WHAT, - NONE {"log_min_messages", PGC_SUSET, LOGGING_WHEN, - NONE {"log_min_error_statement", PGC_SUSET, LOGGING_WHEN, - NONE {"log_statement", PGC_SUSET, LOGGING_WHAT, - NONE {"syslog_facility", PGC_SIGHUP, LOGGING_WHERE, - NONE {"session_replication_role", PGC_SUSET, CLIENT_CONN_STATEMENT, - NONE {"synchronous_commit", PGC_USERSET, WAL_SETTINGS, - NONE {"archive_mode", PGC_POSTMASTER, WAL_ARCHIVING, - NOT QUOTED errmsg("archive_mode enabled, yet archiving is not configured"))); {"recovery_target_action", PGC_POSTMASTER, WAL_RECOVERY_TARGET, - NONE {"trace_recovery_messages", PGC_SIGHUP, DEVELOPER_OPTIONS, - NONE {"track_functions", PGC_SUSET, STATS_CUMULATIVE, - NONE {"stats_fetch_consistency", PGC_USERSET, STATS_CUMULATIVE, - NONE {"wal_compression", PGC_SUSET, WAL_SETTINGS, - NONE {"wal_level", PGC_POSTMASTER, WAL_SETTINGS, - NOT QUOTED, and notice some of these option values are quoted and some are not errmsg("WAL was generated with wal_level=minimal, cannot continue recovering") errdetail("This happens if you temporarily set wal_level=minimal on the server."), errhint("Use a backup taken after setting wal_level to higher than minimal."))); errhint("wal_level must be set to \"replica\" or \"logical\" at server start."))); errhint("wal_level must be set to \"replica\" or \"logical\" at server start."))); errmsg("pg_log_standby_snapshot() can only be used if wal_level >= replica"))); errhint("wal_level must be set to \"replica\" or \"logical\" at server start."))); errmsg("wal_level is insufficient to publish logical changes"), errhint("Set wal_level to \"logical\" before creating subscriptions."))); (errmsg("WAL archival cannot be enabled when wal_level is \"minimal\""))); (errmsg("WAL streaming (max_wal_senders > 0) requires wal_level \"replica\" or \"logical\""))); errmsg("replication slots can only be used if wal_level >= replica"))); appendStringInfo(&err_detail, _("Logical decoding on standby requires wal_level >= logical on the primary server.")); errmsg("logical replication slot \"%s\" exists, but wal_level < logical", errhint("Change wal_level to be logical or higher."))); errmsg("physical replication slot \"%s\" exists, but wal_level < replica", errhint("Change wal_level to be replica or higher."))); errmsg("physical replication slot \"%s\" exists, but wal_level < replica", errhint("Change wal_level to be replica or higher."))); errmsg("logical decoding on standby requires wal_level >= logical on the primary"))); errmsg("logical decoding requires wal_level >= logical"))); errmsg("logical decoding on standby requires wal_level >= logical on the primary"))); {"dynamic_shared_memory_type", PGC_POSTMASTER, RESOURCES_MEM, - NONE {"shared_memory_type", PGC_POSTMASTER, RESOURCES_MEM, - NOT QUOTED errmsg("huge pages not supported with the current shared_memory_type setting"))); {"wal_sync_method", PGC_SIGHUP, WAL_SETTINGS, - NOT QUOTED elog(ERROR, "unrecognized wal_sync_method: %d", method); elog(PANIC, "unrecognized wal_sync_method: %d", sync_method); {"xmlbinary", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"xmloption", PGC_USERSET, CLIENT_CONN_STATEMENT, - NONE {"huge_pages", PGC_POSTMASTER, RESOURCES_MEM, - NONE {"recovery_prefetch", PGC_SIGHUP, WAL_RECOVERY, - NOT QUOTED GUC_check_errdetail("recovery_prefetch is not supported on platforms that lack posix_fadvise()."); {"debug_parallel_query", PGC_USERSET, DEVELOPER_OPTIONS, - NONE {"password_encryption", PGC_USERSET, CONN_AUTH_AUTH, - NOT QUOTED libpq_append_conn_error(conn, "password_encryption value too long"); {"plan_cache_mode", PGC_USERSET, QUERY_TUNING_OTHER, - NONE {"ssl_min_protocol_version", PGC_SIGHUP, CONN_AUTH_SSL, - QUOTED (errmsg("\"%s\" setting \"%s\" not supported by this build", "ssl_min_protocol_version", GetConfigOption("ssl_min_protocol_version", false, false)))); - NOT QUOTED libpq_append_conn_error(conn, "invalid %s value: \"%s\"", "ssl_min_protocol_version", conn->ssl_min_protocol_version); {"ssl_max_protocol_version", PGC_SIGHUP, CONN_AUTH_SSL, - QUOTED (errmsg("\"%s\" setting \"%s\" not supported by this build", "ssl_max_protocol_version", GetConfigOption("ssl_max_protocol_version", false, false)))); errdetail("\"%s\" cannot be higher than \"%s\"", "ssl_min_protocol_version", "ssl_max_protocol_version"))); - NOT QUOTED libpq_append_conn_error(conn, "invalid %s value: \"%s\"", "ssl_max_protocol_version", conn->ssl_max_protocol_version); {"recovery_init_sync_method", PGC_SIGHUP, ERROR_HANDLING_OPTIONS, - NONE {"debug_logical_replication_streaming", PGC_USERSET, DEVELOPER_OPTIONS, - NONE [end]