DBパラメータグループ
実行内容
DBパラメータグループのパラメータ一覧をファイルに出力する
コマンドプロンプト
aws rds describe-db-parameters --db-parameter-group-name default.postgres13 > default.postgres13.json
jqコマンドを使ってJSON形式のファイルをCSV形式のファイルに変換する
コマンドプロンプト
default.postgres13.json | jq -r ".Parameters[] | [.ParameterName,.ParameterValue,.AllowedValues,.IsModifiable,.Source,.ApplyType,.DataType,.Description,.ApplyMethod,.MinimumEngineVersion] | @csv" > default.postgres13.csv
実行結果
PostgreSQLのDBパラメータグループのパラメータ一覧
CSVファイル
"application_name",,,true,"engine-default","dynamic","string","Sets the application name to be reported in statistics and logs.","pending-reboot",
"archive_command","/etc/rds/dbbin/pgscripts/rds_wal_archive %p",,false,"system","dynamic","string","Sets the shell command that will be called to archive a WAL file.","pending-reboot",
"archive_timeout","300","0-2147483647",false,"system","dynamic","integer","(s) Forces a switch to the next xlog file if a new file has not been started within N seconds.","pending-reboot",
"array_nulls",,"0,1",true,"engine-default","dynamic","boolean","Enable input of NULL elements in arrays.","pending-reboot",
"authentication_timeout",,"1-600",true,"engine-default","dynamic","integer","(s) Sets the maximum allowed time to complete client authentication.","pending-reboot",
"auto_explain.log_analyze",,"0,1",true,"engine-default","dynamic","boolean","Use EXPLAIN ANALYZE for plan logging.","pending-reboot",
"auto_explain.log_buffers",,"0,1",true,"engine-default","dynamic","boolean","Log buffers usage.","pending-reboot",
"auto_explain.log_format",,"text,xml,json,yaml",true,"engine-default","dynamic","string","EXPLAIN format to be used for plan logging.","pending-reboot",
"auto_explain.log_min_duration",,"-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the minimum execution time above which plans will be logged.","pending-reboot",
"auto_explain.log_nested_statements",,"0,1",true,"engine-default","dynamic","boolean","Log nested statements.","pending-reboot",
"auto_explain.log_timing",,"0,1",true,"engine-default","dynamic","boolean","Collect timing data, not just row counts.","pending-reboot",
"auto_explain.log_triggers",,"0,1",true,"engine-default","dynamic","boolean","Include trigger statistics in plans.","pending-reboot",
"auto_explain.log_verbose",,"0,1",true,"engine-default","dynamic","boolean","Use EXPLAIN VERBOSE for plan logging.","pending-reboot",
"auto_explain.sample_rate",,"0-1",true,"engine-default","dynamic","float","Fraction of queries to process.","pending-reboot",
"autovacuum",,"0,1",true,"engine-default","dynamic","boolean","Starts the autovacuum subprocess.","pending-reboot",
"autovacuum_analyze_scale_factor","0.05","0-100",true,"system","dynamic","float","Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples.","pending-reboot",
"autovacuum_analyze_threshold",,"0-2147483647",true,"engine-default","dynamic","integer","Minimum number of tuple inserts, updates or deletes prior to analyze.","pending-reboot",
"autovacuum_freeze_max_age",,"100000000-750000000",true,"engine-default","static","integer","Age at which to autovacuum a table to prevent transaction ID wraparound.","pending-reboot",
"autovacuum_max_workers","GREATEST({DBInstanceClassMemory/64371566592},3)","1-8388607",true,"system","static","integer","Sets the maximum number of simultaneously running autovacuum worker processes.","pending-reboot",
"autovacuum_multixact_freeze_max_age",,"10000000-2000000000",true,"engine-default","static","integer","Multixact age at which to autovacuum a table to prevent multixact wraparound.","pending-reboot",
"autovacuum_naptime","15","1-2147483",true,"system","dynamic","integer","(s) Time to sleep between autovacuum runs.","pending-reboot",
"autovacuum_vacuum_cost_delay",,"-1-100",true,"engine-default","dynamic","integer","(ms) Vacuum cost delay in milliseconds, for autovacuum.","pending-reboot",
"autovacuum_vacuum_cost_limit","GREATEST({log(DBInstanceClassMemory/21474836480)*600},200)","-1-10000",true,"engine-default","dynamic","integer","Vacuum cost amount available before napping, for autovacuum.","pending-reboot",
"autovacuum_vacuum_insert_scale_factor",,"0-100",true,"engine-default","dynamic","float","Number of tuple inserts prior to vacuum as a fraction of reltuples.","pending-reboot",
"autovacuum_vacuum_insert_threshold",,"-1-2147483647",true,"engine-default","dynamic","integer","Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums.","pending-reboot",
"autovacuum_vacuum_scale_factor","0.1","0-100",true,"system","dynamic","float","Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.","pending-reboot",
"autovacuum_vacuum_threshold",,"0-2147483647",true,"engine-default","dynamic","integer","Minimum number of tuple updates or deletes prior to vacuum.","pending-reboot",
"autovacuum_work_mem",,"-1-2147483647",true,"engine-default","dynamic","integer","(kB) Sets the maximum memory to be used by each autovacuum worker process.","pending-reboot",
"backend_flush_after",,"0-256",true,"engine-default","dynamic","integer","(8Kb) Number of pages after which previously performed writes are flushed to disk.","pending-reboot",
"backslash_quote",,"safe_encoding,on,off",true,"engine-default","dynamic","string","Sets whether \ is allowed in string literals.","pending-reboot",
"backtrace_functions",,,false,"system","dynamic","string","Log backtrace for errors in these functions.","pending-reboot",
"bgwriter_delay",,"10-10000",true,"engine-default","dynamic","integer","(ms) Background writer sleep time between rounds.","pending-reboot",
"bgwriter_flush_after",,"0-256",true,"engine-default","dynamic","integer","(8Kb) Number of pages after which previously performed writes are flushed to disk.","pending-reboot",
"bgwriter_lru_maxpages",,"0-1000",true,"engine-default","dynamic","integer","Background writer maximum number of LRU pages to flush per round.","pending-reboot",
"bgwriter_lru_multiplier",,"0-10",true,"engine-default","dynamic","float","Multiple of the average buffer usage to free per round.","pending-reboot",
"bytea_output",,"escape,hex",true,"engine-default","dynamic","string","Sets the output format for bytea.","pending-reboot",
"check_function_bodies",,"0,1",true,"engine-default","dynamic","boolean","Check function bodies during CREATE FUNCTION.","pending-reboot",
"checkpoint_completion_target","0.9","0-1",true,"system","dynamic","float","Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.","pending-reboot",
"checkpoint_flush_after",,"0-256",true,"engine-default","dynamic","integer","(8kB) Number of pages after which previously performed writes are flushed to disk.","pending-reboot",
"checkpoint_timeout",,"30-3600",true,"engine-default","dynamic","integer","(s) Sets the maximum time between automatic WAL checkpoints.","pending-reboot",
"checkpoint_warning",,"0-2147483647",true,"engine-default","dynamic","integer","(s) Enables warnings if checkpoint segments are filled more frequently than this.","pending-reboot",
"client_encoding","UTF8",,true,"system","dynamic","string","Sets the clients character set encoding.","pending-reboot",
"client_min_messages",,"debug5,debug4,debug3,debug2,debug1,log,notice,warning,error",true,"engine-default","dynamic","string","Sets the message levels that are sent to the client.","pending-reboot",
"commit_delay",,"0-100000",true,"engine-default","dynamic","integer","Sets the delay in microseconds between transaction commit and flushing WAL to disk.","pending-reboot",
"commit_siblings",,"0-1000",true,"engine-default","dynamic","integer","Sets the minimum concurrent open transactions before performing commit_delay.","pending-reboot",
"config_file","/rdsdbdata/config/postgresql.conf",,false,"system","static","string","Sets the servers main configuration file.","pending-reboot",
"constraint_exclusion",,"partition,on,off",true,"engine-default","dynamic","string","Enables the planner to use constraints to optimize queries.","pending-reboot",
"cpu_index_tuple_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planners estimate of the cost of processing each index entry during an index scan.","pending-reboot",
"cpu_operator_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planners estimate of the cost of processing each operator or function call.","pending-reboot",
"cpu_tuple_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planners estimate of the cost of processing each tuple (row).","pending-reboot",
"cron.database_name","postgres",,true,"engine-default","static","string","Sets the database to store pg_cron metadata tables","pending-reboot",
"cron.log_run","on","on,off",true,"engine-default","static","string","Log all jobs runs into the job_run_details table","pending-reboot",
"cron.log_statement","on","on,off",true,"engine-default","static","string","Log all cron statements prior to execution.","pending-reboot",
"cron.max_running_jobs","5","0-100",true,"engine-default","static","integer","Maximum number of jobs that can run concurrently.","pending-reboot",
"cron.use_background_workers","on",,false,"system","static","string","Enables background workers for pg_cron","pending-reboot",
"cursor_tuple_fraction",,"0-1",true,"engine-default","dynamic","float","Sets the planners estimate of the fraction of a cursors rows that will be retrieved.","pending-reboot",
"data_directory","/rdsdbdata/db",,false,"system","static","string","Sets the servers data directory.","pending-reboot",
"datestyle",,,true,"engine-default","dynamic","string","Sets the display format for date and time values.","pending-reboot",
"db_user_namespace",,"0,1",false,"engine-default","dynamic","boolean","Enables per-database user names.","pending-reboot",
"deadlock_timeout",,"1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the time to wait on a lock before checking for deadlock.","pending-reboot",
"debug_pretty_print",,"0,1",true,"engine-default","dynamic","boolean","Indents parse and plan tree displays.","pending-reboot",
"debug_print_parse",,"0,1",true,"engine-default","dynamic","boolean","Logs each querys parse tree.","pending-reboot",
"debug_print_plan",,"0,1",true,"engine-default","dynamic","boolean","Logs each querys execution plan.","pending-reboot",
"debug_print_rewritten",,"0,1",true,"engine-default","dynamic","boolean","Logs each querys rewritten parse tree.","pending-reboot",
"default_statistics_target",,"1-10000",true,"engine-default","dynamic","integer","Sets the default statistics target.","pending-reboot",
"default_tablespace",,,true,"engine-default","dynamic","string","Sets the default tablespace to create tables and indexes in.","pending-reboot",
"default_transaction_deferrable",,"0,1",true,"engine-default","dynamic","boolean","Sets the default deferrable status of new transactions.","pending-reboot",
"default_transaction_isolation",,"serializable,repeatable read,read committed,read uncommitted",true,"engine-default","dynamic","string","Sets the transaction isolation level of each new transaction.","pending-reboot",
"default_transaction_read_only",,"0,1",true,"engine-default","dynamic","boolean","Sets the default read-only status of new transactions.","pending-reboot",
"effective_cache_size","{DBInstanceClassMemory/16384}","1-2147483647",true,"system","dynamic","integer","(8kB) Sets the planners assumption about the size of the disk cache.","pending-reboot",
"effective_io_concurrency",,"0-1000",true,"engine-default","dynamic","integer","Number of simultaneous requests that can be handled efficiently by the disk subsystem.","pending-reboot",
"enable_bitmapscan",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of bitmap-scan plans.","pending-reboot",
"enable_gathermerge",,"0,1",true,"engine-default","dynamic","boolean","Enables the planner's use of gather merge plans.","pending-reboot",
"enable_hashagg",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of hashed aggregation plans.","pending-reboot",
"enable_hashjoin",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of hash join plans.","pending-reboot",
"enable_incremental_sort",,"0,1",true,"engine-default","dynamic","boolean","Enables the planner's use of incremental sort steps.","pending-reboot",
"enable_indexonlyscan",,"0,1",true,"engine-default","dynamic","boolean","Enables the planner's use of index-only-scan plans.","pending-reboot",
"enable_indexscan",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of index-scan plans.","pending-reboot",
"enable_material",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of materialization.","pending-reboot",
"enable_mergejoin",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of merge join plans.","pending-reboot",
"enable_nestloop",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of nested-loop join plans.","pending-reboot",
"enable_parallel_append",,"0,1",true,"engine-default","dynamic","boolean","Enables the planner's use of parallel append plans.","pending-reboot",
"enable_parallel_hash",,"0,1",true,"engine-default","dynamic","boolean","Enables the planner's user of parallel hash plans.","pending-reboot",
"enable_partition_pruning",,"0,1",true,"engine-default","dynamic","boolean","Enable plan-time and run-time partition pruning.","pending-reboot",
"enable_partitionwise_aggregate",,"0,1",true,"engine-default","dynamic","boolean","Enables partitionwise aggregation and grouping.","pending-reboot",
"enable_partitionwise_join",,"0,1",true,"engine-default","dynamic","boolean","Enables partitionwise join.","pending-reboot",
"enable_seqscan",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of sequential-scan plans.","pending-reboot",
"enable_sort",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of explicit sort steps.","pending-reboot",
"enable_tidscan",,"0,1",true,"engine-default","dynamic","boolean","Enables the planners use of TID scan plans.","pending-reboot",
"escape_string_warning",,"0,1",true,"engine-default","dynamic","boolean","Warn about backslash escapes in ordinary string literals.","pending-reboot",
"exit_on_error",,"0,1",false,"engine-default","dynamic","boolean","Terminate session on any error.","pending-reboot",
"extra_float_digits",,"-15-3",true,"engine-default","dynamic","integer","Sets the number of digits displayed for floating-point values.","pending-reboot",
"force_parallel_mode",,"0,1",true,"engine-default","dynamic","boolean","Forces use of parallel query facilities.","pending-reboot",
"from_collapse_limit",,"1-2147483647",true,"engine-default","dynamic","integer","Sets the FROM-list size beyond which subqueries are not collapsed.","pending-reboot",
"fsync","1","0,1",false,"system","dynamic","boolean","Forces synchronization of updates to disk.","pending-reboot",
"full_page_writes","1","0,1",false,"system","dynamic","boolean","Writes full pages to WAL when first modified after a checkpoint.","pending-reboot",
"geqo",,"0,1",true,"engine-default","dynamic","boolean","Enables genetic query optimization.","pending-reboot",
"geqo_effort",,"1-10",true,"engine-default","dynamic","integer","GEQO: effort is used to set the default for other GEQO parameters.","pending-reboot",
"geqo_generations",,"0-2147483647",true,"engine-default","dynamic","integer","GEQO: number of iterations of the algorithm.","pending-reboot",
"geqo_pool_size",,"0-2147483647",true,"engine-default","dynamic","integer","GEQO: number of individuals in the population.","pending-reboot",
"geqo_seed",,"0-1",true,"engine-default","dynamic","float","GEQO: seed for random path selection.","pending-reboot",
"geqo_selection_bias",,"1.5-2",true,"engine-default","dynamic","float","GEQO: selective pressure within the population.","pending-reboot",
"geqo_threshold",,"2-2147483647",true,"engine-default","dynamic","integer","Sets the threshold of FROM items beyond which GEQO is used.","pending-reboot",
"gin_fuzzy_search_limit",,"0-2147483647",true,"engine-default","dynamic","integer","Sets the maximum allowed result for exact search by GIN.","pending-reboot",
"gin_pending_list_limit",,"64-2147483647",true,"engine-default","dynamic","integer","(kB) Sets the maximum size of the pending list for GIN index.","pending-reboot",
"hash_mem_multiplier",,"1-1000",true,"engine-default","dynamic","float","Multiple of work_mem to use for hash tables.","pending-reboot",
"hba_file","/rdsdbdata/config/pg_hba.conf",,false,"system","static","string","Sets the servers hba configuration file.","pending-reboot",
"hll.force_groupagg",,"0,1",true,"engine-default","dynamic","boolean","Force group aggregation for hll","pending-reboot",
"hot_standby_feedback",,"0,1",true,"engine-default","dynamic","boolean","Allows feedback from a hot standby to the primary that will avoid query conflicts.","pending-reboot",
"huge_pages","on","on,off",true,"system","static","string","Use of huge pages on Linux.","pending-reboot",
"ident_file","/rdsdbdata/config/pg_ident.conf",,false,"system","static","string","Sets the servers ident configuration file.","pending-reboot",
"idle_in_transaction_session_timeout","86400000","0-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the maximum allowed duration of any idling transaction.","pending-reboot",
"ignore_invalid_pages","0","0,1",false,"engine-default","static","boolean","Continues recovery after an invalid pages failure.","pending-reboot",
"intervalstyle",,"postgres,postgres_verbose,sql_standard,iso_8601",true,"engine-default","dynamic","string","Sets the display format for interval values.","pending-reboot",
"jit","0","0,1",true,"system","dynamic","boolean","Allow JIT compilation.","pending-reboot",
"jit_above_cost",,"-1-1.79769e+308",true,"engine-default","dynamic","float","Perform JIT compilation if query is more expensive.","pending-reboot",
"jit_inline_above_cost",,"-1-1.79769e+308",true,"engine-default","dynamic","float","Perform JIT inlining if query is more expensive.","pending-reboot",
"jit_optimize_above_cost",,"-1-1.79769e+308",true,"engine-default","dynamic","float","Optimize JITed functions if query is more expensive.","pending-reboot",
"join_collapse_limit",,"1-2147483647",true,"engine-default","dynamic","integer","Sets the FROM-list size beyond which JOIN constructs are not flattened.","pending-reboot",
"lc_messages",,,true,"engine-default","dynamic","string","Sets the language in which messages are displayed.","pending-reboot",
"lc_monetary",,,true,"engine-default","dynamic","string","Sets the locale for formatting monetary amounts.","pending-reboot",
"lc_numeric",,,true,"engine-default","dynamic","string","Sets the locale for formatting numbers.","pending-reboot",
"lc_time",,,true,"engine-default","dynamic","string","Sets the locale for formatting date and time values.","pending-reboot",
"listen_addresses","*",,false,"system","static","string","Sets the host name or IP address(es) to listen to.","pending-reboot",
"lo_compat_privileges","0","0,1",false,"system","dynamic","boolean","Enables backward compatibility mode for privilege checks on large objects.","pending-reboot",
"log_autovacuum_min_duration","10000","-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the minimum execution time above which autovacuum actions will be logged.","pending-reboot",
"log_checkpoints","1","0,1",true,"engine-default","dynamic","boolean","Logs each checkpoint.","pending-reboot",
"log_connections",,"0,1",true,"engine-default","dynamic","boolean","Logs each successful connection.","pending-reboot",
"log_destination","stderr","stderr,csvlog",true,"system","dynamic","string","Sets the destination for server log output.","pending-reboot",
"log_directory","/rdsdbdata/log/error",,false,"system","dynamic","string","Sets the destination directory for log files.","pending-reboot",
"log_disconnections",,"0,1",true,"engine-default","dynamic","boolean","Logs end of a session, including duration.","pending-reboot",
"log_duration",,"0,1",true,"engine-default","dynamic","boolean","Logs the duration of each completed SQL statement.","pending-reboot",
"log_error_verbosity",,"terse,default,verbose",true,"engine-default","dynamic","string","Sets the verbosity of logged messages.","pending-reboot",
"log_executor_stats",,"0,1",true,"engine-default","dynamic","boolean","Writes executor performance statistics to the server log.","pending-reboot",
"log_file_mode","0644",,false,"system","dynamic","string","Sets the file permissions for log files.","pending-reboot",
"log_filename","postgresql.log.%Y-%m-%d-%H","postgresql.log.%Y-%m-%d,postgresql.log.%Y-%m-%d-%H",true,"system","dynamic","string","Sets the file name pattern for log files.","pending-reboot",
"logging_collector","1","0,1",false,"system","static","boolean","Start a subprocess to capture stderr output and/or csvlogs into log files.","pending-reboot",
"log_hostname",,"0,1",true,"engine-default","dynamic","boolean","Logs the host name in the connection logs.","pending-reboot",
"logical_decoding_work_mem",,"64-2147483647",true,"engine-default","dynamic","integer","(kB) Sets the maximum memory to be used for logical decoding.","pending-reboot",
"log_line_prefix","%t:%r:%u@%d:[%p]:",,false,"system","dynamic","string","Controls information prefixed to each log line.","pending-reboot",
"log_lock_waits",,"0,1",true,"engine-default","dynamic","boolean","Logs long lock waits.","pending-reboot",
"log_min_duration_sample",,"-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.","pending-reboot",
"log_min_duration_statement",,"-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the minimum execution time above which statements will be logged.","pending-reboot",
"log_min_error_statement",,"debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",true,"engine-default","dynamic","string","Causes all statements generating error at or above this level to be logged.","pending-reboot",
"log_min_messages",,"debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal",true,"engine-default","dynamic","string","Sets the message levels that are logged.","pending-reboot",
"log_parameter_max_length",,"-1-1073741823",true,"engine-default","dynamic","integer","When logging statements, limit logged parameter values to first N bytes.","pending-reboot",
"log_parameter_max_length_on_error",,"-1-1073741823",true,"engine-default","dynamic","integer","When reporting an error, limit logged parameter values to first N bytes.","pending-reboot",
"log_parser_stats",,"0,1",true,"engine-default","dynamic","boolean","Writes parser performance statistics to the server log.","pending-reboot",
"log_planner_stats",,"0,1",true,"engine-default","dynamic","boolean","Writes planner performance statistics to the server log.","pending-reboot",
"log_replication_commands",,"0,1",true,"engine-default","dynamic","boolean","Logs each replication command.","pending-reboot",
"log_rotation_age","60","1-1440",true,"system","dynamic","integer","(min) Automatic log file rotation will occur after N minutes.","pending-reboot",
"log_rotation_size",,"0-2097151",true,"engine-default","dynamic","integer","(kB) Automatic log file rotation will occur after N kilobytes.","pending-reboot",
"log_statement",,"none,ddl,mod,all",true,"engine-default","dynamic","string","Sets the type of statements logged.","pending-reboot",
"log_statement_sample_rate",,"0-1",true,"engine-default","dynamic","float","Fraction of statements exceeding log_min_duration_sample to be logged.","pending-reboot",
"log_statement_stats",,"0,1",true,"engine-default","dynamic","boolean","Writes cumulative performance statistics to the server log.","pending-reboot",
"log_temp_files",,"-1-2147483647",true,"engine-default","dynamic","integer","(kB) Log the use of temporary files larger than this number of kilobytes.","pending-reboot",
"log_timezone","UTC",,false,"system","dynamic","string","Sets the time zone to use in log messages.","pending-reboot",
"log_transaction_sample_rate",,"0.0-1.0",true,"engine-default","dynamic","float","Set the fraction of transactions to log for new transactions.","pending-reboot",
"log_truncate_on_rotation","0","0,1",false,"engine-default","dynamic","boolean","Truncate existing log files of same name during log rotation.","pending-reboot",
"maintenance_io_concurrency",,"0-1000",true,"engine-default","dynamic","integer","A variant of effective_io_concurrency that is used for maintenance work.","pending-reboot",
"maintenance_work_mem","GREATEST({DBInstanceClassMemory*1024/63963136},65536)","1024-2147483647",true,"engine-default","dynamic","integer","(kB) Sets the maximum memory to be used for maintenance operations.","pending-reboot",
"max_connections","LEAST({DBInstanceClassMemory/9531392},5000)","6-8388607",true,"system","static","integer","Sets the maximum number of concurrent connections.","pending-reboot",
"max_files_per_process",,"64-2147483647",true,"engine-default","static","integer","Sets the maximum number of simultaneously open files for each server process.","pending-reboot",
"max_locks_per_transaction","64","10-2147483647",true,"engine-default","static","integer","Sets the maximum number of locks per transaction.","pending-reboot",
"max_logical_replication_workers",,"0-262143",true,"engine-default","static","integer","Maximum number of logical replication worker processes.","pending-reboot",
"max_parallel_maintenance_workers",,"0-1024",true,"engine-default","dynamic","integer","Sets the maximum number of parallel processes per maintenance operation.","pending-reboot",
"max_parallel_workers","GREATEST(${DBInstanceVCPU/2},8)","0-1024",true,"engine-default","dynamic","integer","Sets the maximum number of parallel workers than can be active at one time.","pending-reboot",
"max_parallel_workers_per_gather",,"0-1024",true,"engine-default","dynamic","integer","Sets the maximum number of parallel processes per executor node.","pending-reboot",
"max_pred_locks_per_page",,"0-2147483647",true,"engine-default","dynamic","integer","Sets the maximum number of predicate-locked tuples per page.","pending-reboot",
"max_pred_locks_per_relation",,"-2147483648-2147483647",true,"engine-default","dynamic","integer","Sets the maximum number of predicate-locked pages and tuples per relation.","pending-reboot",
"max_pred_locks_per_transaction",,"10-2147483647",true,"engine-default","static","integer","Sets the maximum number of predicate locks per transaction.","pending-reboot",
"max_prepared_transactions","0","0-8388607",true,"engine-default","static","integer","Sets the maximum number of simultaneously prepared transactions.","pending-reboot",
"max_replication_slots","20","5-8388607",true,"system","static","integer","Sets the maximum number of replication slots that the server can support.","pending-reboot",
"max_slot_wal_keep_size",,"-1-2147483647",true,"engine-default","dynamic","integer","(MB) Sets the maximum WAL size that can be reserved by replication slots.","pending-reboot",
"max_stack_depth","6144","100-2147483647",true,"system","dynamic","integer","(kB) Sets the maximum stack depth, in kilobytes.","pending-reboot",
"max_standby_archive_delay",,"-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.","pending-reboot",
"max_standby_streaming_delay",,"-1-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.","pending-reboot",
"max_sync_workers_per_subscription",,"0-262143",true,"engine-default","dynamic","integer","Maximum number of synchronization workers per subscription","pending-reboot",
"max_wal_senders","20","5-8388607",true,"system","static","integer","Sets the maximum number of simultaneously running WAL sender processes.","pending-reboot",
"max_wal_size","2048","128-201326592",true,"system","dynamic","integer","(MB) Sets the WAL size that triggers a checkpoint.","pending-reboot",
"max_worker_processes","GREATEST(${DBInstanceVCPU*2},8)","0-262143",true,"engine-default","static","integer","Sets the maximum number of concurrent worker processes.","pending-reboot",
"min_parallel_index_scan_size",,"0-715827882",true,"engine-default","dynamic","integer","(8kB) Sets the minimum amount of index data for a parallel scan.","pending-reboot",
"min_parallel_table_scan_size",,"0-715827882",true,"engine-default","dynamic","integer","(8kB) Sets the minimum amount of table data for a parallel scan.","pending-reboot",
"min_wal_size","192","128-201326592",true,"system","dynamic","integer","(MB) Sets the minimum size to shrink the WAL to.","pending-reboot",
"old_snapshot_threshold",,"-1-86400",true,"engine-default","static","integer","(min) Time before a snapshot is too old to read pages changed after the snapshot was taken.","pending-reboot",
"operator_precedence_warning",,"0,1",true,"engine-default","dynamic","boolean","Emit a warning for constructs that changed meaning since PostgreSQL 9.4.","pending-reboot",
"orafce.nls_date_format",,,true,"engine-default","dynamic","string","Emulate oracle's date output behaviour.","pending-reboot",
"orafce.timezone",,,true,"engine-default","dynamic","string","Specify timezone used for sysdate function.","pending-reboot",
"parallel_leader_participation",,"0,1",true,"engine-default","dynamic","boolean","Controls whether Gather and Gather Merge also run subplans.","pending-reboot",
"parallel_setup_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planner's estimate of the cost of starting up worker processes for parallel query.","pending-reboot",
"parallel_tuple_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.","pending-reboot",
"password_encryption","md5","md5,scram-sha-256",true,"system","dynamic","string","Encrypt passwords.","pending-reboot",
"pgaudit.log",,"ddl,function,misc,read,role,write,none,all,-ddl,-function,-misc,-read,-role,-write",true,"engine-default","dynamic","list","Specifies which classes of statements will be logged by session audit logging.","pending-reboot",
"pgaudit.log_catalog",,"0,1",true,"engine-default","dynamic","boolean","Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog.","pending-reboot",
"pgaudit.log_level",,"debug5,debug4,debug3,debug2,debug1,info,notice,warning,log",true,"engine-default","dynamic","string","Specifies the log level that will be used for log entries.","pending-reboot",
"pgaudit.log_parameter",,"0,1",true,"engine-default","dynamic","boolean","Specifies that audit logging should include the parameters that were passed with the statement.","pending-reboot",
"pgaudit.log_relation",,"0,1",true,"engine-default","dynamic","boolean","Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.","pending-reboot",
"pgaudit.log_statement_once",,"0,1",true,"engine-default","dynamic","boolean","Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.","pending-reboot",
"pgaudit.role",,"rds_pgaudit",true,"engine-default","dynamic","string","Specifies the master role to use for object audit logging.","pending-reboot",
"pg_bigm.enable_recheck","on","on,off",true,"engine-default","dynamic","string","It specifies whether to perform Recheck which is an internal process of full text search.","pending-reboot","13.2"
"pg_bigm.gin_key_limit","0","0-2147483647",true,"engine-default","dynamic","integer","It specifies the maximum number of 2-grams of the search keyword to be used for full text search.","pending-reboot","13.2"
"pg_bigm.similarity_limit","0.3","0-1",true,"engine-default","dynamic","float","It specifies the minimum threshold used by the similarity search.","pending-reboot","13.2"
"pg_hint_plan.debug_print",,"off,on,detailed,verbose",true,"engine-default","dynamic","string","Logs results of hint parsing.","pending-reboot",
"pg_hint_plan.enable_hint",,"0,1",true,"engine-default","dynamic","boolean","Force planner to use plans specified in the hint comment preceding to the query.","pending-reboot",
"pg_hint_plan.enable_hint_table",,"0,1",true,"engine-default","dynamic","boolean","Force planner to not get hint by using table lookups.","pending-reboot",
"pg_hint_plan.message_level",,"debug5,debug4,debug3,debug2,debug1,log,info,notice,warning,error",true,"engine-default","dynamic","string","Message level of debug messages.","pending-reboot",
"pg_hint_plan.parse_messages",,"debug5,debug4,debug3,debug2,debug1,log,info,notice,warning,error",true,"engine-default","dynamic","string","Message level of parse errors.","pending-reboot",
"pglogical.batch_inserts",,"0,1",true,"engine-default","static","boolean","Batch inserts if possible","pending-reboot",
"pglogical.conflict_log_level",,"debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",true,"engine-default","dynamic","string","Sets log level used for logging resolved conflicts.","pending-reboot",
"pglogical.conflict_resolution",,"error,apply_remote,keep_local,last_update_wins,first_update_wins",true,"engine-default","dynamic","string","Sets method used for conflict resolution for resolvable conflicts.","pending-reboot",
"pglogical.extra_connection_options",,,true,"engine-default","dynamic","string","connection options to add to all peer node connections","pending-reboot",
"pglogical.synchronous_commit",,"0,1",true,"engine-default","static","boolean","pglogical specific synchronous commit value","pending-reboot",
"pglogical.use_spi",,"0,1",true,"engine-default","static","boolean","Use SPI instead of low-level API for applying changes","pending-reboot",
"pg_prewarm.autoprewarm",,"0,1",true,"engine-default","static","boolean","Starts the autoprewarm worker.","pending-reboot",
"pg_prewarm.autoprewarm_interval",,"0-2147483",true,"engine-default","dynamic","integer","Sets the interval between dumps of shared buffers","pending-reboot",
"pg_similarity.block_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.block_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Block similarity function.","pending-reboot",
"pg_similarity.block_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Block similarity function.","pending-reboot",
"pg_similarity.cosine_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.cosine_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Cosine similarity function.","pending-reboot",
"pg_similarity.cosine_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Cosine similarity function.","pending-reboot",
"pg_similarity.dice_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.dice_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Dice similarity measure.","pending-reboot",
"pg_similarity.dice_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Dice similarity measure.","pending-reboot",
"pg_similarity.euclidean_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.euclidean_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Euclidean similarity measure.","pending-reboot",
"pg_similarity.euclidean_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Euclidean similarity measure.","pending-reboot",
"pg_similarity.hamming_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.hamming_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Block similarity metric.","pending-reboot",
"pg_similarity.jaccard_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.jaccard_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Jaccard similarity measure.","pending-reboot",
"pg_similarity.jaccard_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Jaccard similarity measure.","pending-reboot",
"pg_similarity.jaro_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.jaro_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Jaro similarity measure.","pending-reboot",
"pg_similarity.jarowinkler_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.jarowinkler_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Jarowinkler similarity measure.","pending-reboot",
"pg_similarity.levenshtein_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.levenshtein_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Levenshtein similarity measure.","pending-reboot",
"pg_similarity.matching_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.matching_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Matching Coefficient similarity measure.","pending-reboot",
"pg_similarity.matching_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Matching Coefficient similarity measure.","pending-reboot",
"pg_similarity.mongeelkan_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.mongeelkan_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Monge-Elkan similarity measure.","pending-reboot",
"pg_similarity.mongeelkan_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Monge-Elkan similarity measure.","pending-reboot",
"pg_similarity.nw_gap_penalty",,"-9223370000000000000-9223370000000000000",true,"engine-default","dynamic","float","Sets the gap penalty used by the Needleman-Wunsch similarity measure.","pending-reboot",
"pg_similarity.nw_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.nw_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Needleman-Wunsch similarity measure.","pending-reboot",
"pg_similarity.overlap_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.overlap_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Overlap Coefficient similarity measure.","pending-reboot",
"pg_similarity.overlap_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Overlap Coefficientsimilarity measure.","pending-reboot",
"pg_similarity.qgram_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.qgram_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Q-Gram similarity measure.","pending-reboot",
"pg_similarity.qgram_tokenizer",,"alnum,gram,word,camelcase",true,"engine-default","dynamic","string","Sets the tokenizer for Q-Gram measure.","pending-reboot",
"pg_similarity.swg_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.swg_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Smith-Waterman-Gotoh similarity measure.","pending-reboot",
"pg_similarity.sw_is_normalized",,"0,1",true,"engine-default","dynamic","boolean","Sets if the result value is normalized or not.","pending-reboot",
"pg_similarity.sw_threshold",,"0-1",true,"engine-default","dynamic","float","Sets the threshold used by the Smith-Waterman similarity measure.","pending-reboot",
"pg_stat_statements.max",,"100-2147483647",true,"engine-default","static","integer","Sets the maximum number of statements tracked by pg_stat_statements.","pending-reboot",
"pg_stat_statements.save",,"0,1",true,"engine-default","dynamic","boolean","Save pg_stat_statements statistics across server shutdowns.","pending-reboot",
"pg_stat_statements.track",,"NONE,TOP,ALL",true,"engine-default","dynamic","string","Selects which statements are tracked by pg_stat_statements.","pending-reboot",
"pg_stat_statements.track_planning",,"0,1",true,"engine-default","dynamic","boolean","Selects whether planning duration is tracked by pg_stat_statements.","pending-reboot",
"pg_stat_statements.track_utility",,"0,1",true,"engine-default","dynamic","boolean","Selects whether utility commands are tracked by pg_stat_statements.","pending-reboot",
"pg_transport.num_workers",,"1-32",true,"engine-default","dynamic","integer","Number of workers to use for a physical transport.","pending-reboot",
"pg_transport.timing",,"0,1",true,"engine-default","dynamic","boolean","Specifies whether to report timing information during transport.","pending-reboot","13.1"
"pg_transport.work_mem",,"65536-2147483647",true,"engine-default","dynamic","integer","(kB) Amount of memory each worker can allocate for a physical transport.","pending-reboot",
"plan_cache_mode",,"auto,force_generic_plan,force_custom_plan",true,"engine-default","dynamic","string","Controls the planner selection of custom or generic plan.","pending-reboot",
"port","{EndPointPort}","1-65535",false,"system","static","integer","Sets the TCP port the server listens on.","pending-reboot",
"postgis.gdal_enabled_drivers","ENABLE_ALL","ENABLE_ALL,DISABLE_ALL",true,"system","static","string","Enable for disable GDAL drivers used with PostGIS in Postgres 9.3.5 and above.","pending-reboot",
"quote_all_identifiers",,"0,1",true,"engine-default","dynamic","boolean","When generating SQL fragments, quote all identifiers.","pending-reboot",
"random_page_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planners estimate of the cost of a nonsequentially fetched disk page.","pending-reboot",
"rdkit.dice_threshold",,"0-1",true,"engine-default","dynamic","float","Lower threshold of Dice similarity. Molecules with similarity lower than threshold are not similar by # operation.","pending-reboot",
"rdkit.do_chiral_sss",,"0,1",true,"engine-default","dynamic","boolean","Should stereochemistry be taken into account in substructure matching. If false, no stereochemistry information is used in substructure matches.","pending-reboot",
"rdkit.tanimoto_threshold",,"0-1",true,"engine-default","dynamic","float","Lower threshold of Tanimoto similarity. Molecules with similarity lower than threshold are not similar by % operation.","pending-reboot",
"rds.accepted_password_auth_method","md5+scram","md5+scram,scram",true,"system","dynamic","string","Force authentication for connections with password stored locally","pending-reboot",
"rds.adaptive_autovacuum","1","0,1",true,"system","dynamic","boolean","RDS parameter to enable/disable adaptive autovacuum.","pending-reboot",
"rds.allowed_extensions",,,true,"system","dynamic","string","Comma-delimited list of extensions that may be installed.","pending-reboot","13.2"
"rds.custom_dns_resolution","0","0,1",true,"system","static","boolean","Allow DNS resolution in Customer VPC.","pending-reboot",
"rds.extensions","address_standardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool_plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control, fuzzystrmatch, hll, hstore, hstore_plperl, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, oracle_fdw, orafce, pageinspect, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_transport, pg_trgm, pg_visibility, plcoffee, plls, plperl, plpgsql, plprofiler, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, sslinfo, tablefunc, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp",,false,"system","static","string","List of extensions provided by RDS","pending-reboot",
"rds.force_admin_logging_level",,"disabled,debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",true,"system","dynamic","string","See log messages for RDS admin user actions in customer databases.","pending-reboot",
"rds.force_autovacuum_logging_level","WARNING","disabled,debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",true,"system","dynamic","string","See log messages related to autovacuum operations.","pending-reboot",
"rds.force_ssl","0","0,1",true,"system","dynamic","boolean","Force SSL connections.","pending-reboot",
"rds.logical_replication","0","0,1",true,"engine-default","static","boolean","Enables logical decoding.","pending-reboot",
"rds.log_retention_period","4320","1440-10080",true,"system","dynamic","integer","Amazon RDS will delete PostgreSQL log that are older than N minutes.","pending-reboot",
"rds.max_tcp_buffers","33554432","4096-1000000000",false,"system","dynamic","integer","Sets the maximum size for tcp buffers.","pending-reboot",
"rds.pg_stat_ramdisk_size","0","0-8196",true,"system","static","integer","Size of the stats ramdisk in MB. A nonzero value signals HM to set up the ramdisk.","pending-reboot",
"rds.rds_superuser_reserved_connections","2","0-8388607",true,"system","static","integer","Sets the number of connection slots reserved for rds_superusers.","pending-reboot",
"rds.restrict_password_commands",,"0,1",true,"system","static","boolean","restricts password-related commands to members of rds_password","pending-reboot",
"rds.superuser_variables","session_replication_role",,false,"system","static","string","List of superuser-only variables for which we elevate rds_superuser modification statements.","pending-reboot",
"restart_after_crash",,"0,1",false,"engine-default","dynamic","boolean","Reinitialize server after backend crash.","pending-reboot",
"row_security",,"0,1",true,"engine-default","dynamic","boolean","Enable row security.","pending-reboot",
"search_path",,,true,"engine-default","dynamic","string","Sets the schema search order for names that are not schema-qualified.","pending-reboot",
"seq_page_cost",,"0-1.79769e+308",true,"engine-default","dynamic","float","Sets the planners estimate of the cost of a sequentially fetched disk page.","pending-reboot",
"session_replication_role",,"origin,replica,local",true,"engine-default","dynamic","string","Sets the sessions behavior for triggers and rewrite rules.","pending-reboot",
"shared_buffers","{DBInstanceClassMemory/32768}","16-1073741823",true,"system","static","integer","(8kB) Sets the number of shared memory buffers used by the server.","pending-reboot",
"shared_preload_libraries","pg_stat_statements","auto_explain,orafce,pgaudit,pglogical,pg_bigm,pg_cron,pg_hint_plan,pg_prewarm,pg_similarity,pg_stat_statements,pg_transport,plprofiler",true,"system","static","list","Lists shared libraries to preload into server.","pending-reboot",
"ssl","1","0,1",true,"system","dynamic","boolean","Enables SSL connections.","pending-reboot",
"ssl_ca_file","/rdsdbdata/rds-metadata/ca-cert.pem",,false,"system","dynamic","string","Location of the SSL server authority file.","pending-reboot",
"ssl_cert_file","/rdsdbdata/rds-metadata/server-cert.pem",,false,"system","dynamic","string","Location of the SSL server certificate file.","pending-reboot",
"ssl_ciphers",,,false,"engine-default","dynamic","string","Sets the list of allowed SSL ciphers.","pending-reboot",
"ssl_key_file","/rdsdbdata/rds-metadata/server-key.pem",,false,"system","dynamic","string","Location of the SSL server private key file","pending-reboot",
"ssl_max_protocol_version",,"TLSv1,TLSv1.1,TLSv1.2",true,"engine-default","dynamic","string","Sets the maximum SSL/TLS protocol version to use.","pending-reboot",
"ssl_min_protocol_version","TLSv1.2","TLSv1,TLSv1.1,TLSv1.2",true,"system","dynamic","string","Sets the minimum SSL/TLS protocol version to use.","pending-reboot",
"standard_conforming_strings",,"0,1",true,"engine-default","dynamic","boolean","Causes ... strings to treat backslashes literally.","pending-reboot",
"statement_timeout",,"0-2147483647",true,"engine-default","dynamic","integer","(ms) Sets the maximum allowed duration of any statement.","pending-reboot",
"stats_temp_directory","/rdsdbdata/db/pg_stat_tmp",,false,"system","dynamic","string","Writes temporary statistics files to the specified directory.","pending-reboot",
"superuser_reserved_connections","3","0-8388607",false,"system","static","integer","Sets the number of connection slots reserved for superusers.","pending-reboot",
"synchronize_seqscans",,"0,1",true,"engine-default","dynamic","boolean","Enable synchronized sequential scans.","pending-reboot",
"synchronous_commit","on","local,on,off",true,"system","dynamic","string","Sets the current transactions synchronization level.","pending-reboot",
"tcp_keepalives_count",,"0-2147483647",true,"engine-default","dynamic","integer","Maximum number of TCP keepalive retransmits.","pending-reboot",
"tcp_keepalives_idle",,"0-2147483647",true,"engine-default","dynamic","integer","(s) Time between issuing TCP keepalives.","pending-reboot",
"tcp_keepalives_interval",,"0-2147483647",true,"engine-default","dynamic","integer","(s) Time between TCP keepalive retransmits.","pending-reboot",
"temp_buffers",,"100-1073741823",true,"engine-default","dynamic","integer","(8kB) Sets the maximum number of temporary buffers used by each session.","pending-reboot",
"temp_file_limit",,"-1-2147483647",true,"engine-default","dynamic","integer","(kB) Limits the total size of all temporary files used by each process.","pending-reboot",
"temp_tablespaces",,,true,"engine-default","dynamic","string","Sets the tablespace(s) to use for temporary tables and sort files.","pending-reboot",
"timezone","UTC",,true,"system","dynamic","string","Sets the time zone for displaying and interpreting time stamps.","pending-reboot",
"track_activities",,"0,1",true,"engine-default","dynamic","boolean","Collects information about executing commands.","pending-reboot",
"track_activity_query_size","4096","100-1048576",true,"engine-default","static","integer","Sets the size reserved for pg_stat_activity.current_query, in bytes.","pending-reboot",
"track_commit_timestamp",,"0,1",true,"engine-default","static","boolean","Collects transaction commit time.","pending-reboot",
"track_counts",,"0,1",true,"engine-default","dynamic","boolean","Collects statistics on database activity.","pending-reboot",
"track_functions","pl","none,pl,all",true,"engine-default","dynamic","string","Collects function-level statistics on database activity.","pending-reboot",
"track_io_timing","1","0,1",true,"system","dynamic","boolean","Collects timing statistics on database IO activity.","pending-reboot",
"transform_null_equals",,"0,1",true,"engine-default","dynamic","boolean","Treats expr=NULL as expr IS NULL.","pending-reboot",
"unix_socket_directories","/tmp",,false,"system","static","string","Sets the directory where the Unix-domain socket will be created.","pending-reboot",
"unix_socket_group","rdsdb",,false,"system","static","string","Sets the owning group of the Unix-domain socket.","pending-reboot",
"unix_socket_permissions","0700","0-511",false,"system","static","integer","Sets the access permissions of the Unix-domain socket.","pending-reboot",
"update_process_title",,"0,1",true,"engine-default","dynamic","boolean","Updates the process title to show the active SQL command.","pending-reboot",
"vacuum_cleanup_index_scale_factor",,"0-10000000000",true,"engine-default","dynamic","integer","Number of tuple inserts prior to index cleanup as a fraction of reltuples.","pending-reboot",
"vacuum_cost_delay",,"0-100",true,"engine-default","dynamic","integer","(ms) Vacuum cost delay in milliseconds.","pending-reboot",
"vacuum_cost_limit",,"1-10000",true,"engine-default","dynamic","integer","Vacuum cost amount available before napping.","pending-reboot",
"vacuum_cost_page_dirty",,"0-10000",true,"engine-default","dynamic","integer","Vacuum cost for a page dirtied by vacuum.","pending-reboot",
"vacuum_cost_page_hit",,"0-10000",true,"engine-default","dynamic","integer","Vacuum cost for a page found in the buffer cache.","pending-reboot",
"vacuum_cost_page_miss","5","0-10000",true,"system","dynamic","integer","Vacuum cost for a page not found in the buffer cache.","pending-reboot",
"vacuum_defer_cleanup_age",,"0-1000000",true,"engine-default","dynamic","integer","Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.","pending-reboot",
"vacuum_freeze_min_age",,"0-1000000000",true,"engine-default","dynamic","integer","Minimum age at which VACUUM should freeze a table row.","pending-reboot",
"vacuum_freeze_table_age",,"0-2000000000",true,"engine-default","dynamic","integer","Age at which VACUUM should scan whole table to freeze tuples.","pending-reboot",
"vacuum_multixact_freeze_min_age",,"0-1000000000",true,"engine-default","dynamic","integer","Minimum age at which VACUUM should freeze a MultiXactId in a table row.","pending-reboot",
"vacuum_multixact_freeze_table_age",,"0-2000000000",true,"engine-default","dynamic","integer","Multixact age at which VACUUM should scan whole table to freeze tuples.","pending-reboot",
"wal_buffers",,"-1-262143",true,"engine-default","static","integer","(8kB) Sets the number of disk-page buffers in shared memory for WAL.","pending-reboot",
"wal_compression","1","0,1",true,"engine-default","static","boolean","Compresses full-page writes written in WAL file.","pending-reboot",
"wal_keep_size","2048","0-2147483647",true,"system","dynamic","integer","(MB) Sets the size of WAL files held for standby servers.","pending-reboot",
"wal_receiver_create_temp_slot","0","0,1",false,"engine-default","dynamic","boolean","Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.","pending-reboot",
"wal_receiver_status_interval",,"0-2147483",true,"engine-default","dynamic","integer","(s) Sets the maximum interval between WAL receiver status reports to the primary.","pending-reboot",
"wal_receiver_timeout","30000","0-3600000",true,"engine-default","dynamic","integer","(ms) Sets the maximum wait time to receive data from the primary.","pending-reboot",
"wal_sender_timeout","30000","0-3600000",true,"engine-default","dynamic","integer","(ms) Sets the maximum time to wait for WAL replication.","pending-reboot",
"wal_skip_threshold",,"0-2147483647",true,"engine-default","dynamic","integer","(kB) Size of new file to fsync instead of writing WAL.","pending-reboot",
"wal_sync_method",,"fsync,fdatasync,open_sync,open_datasync",false,"system","dynamic","string","Selects the method used for forcing WAL updates to disk.","pending-reboot",
"wal_writer_delay",,"1-10000",true,"engine-default","dynamic","integer","(ms) WAL writer sleep time between WAL flushes.","pending-reboot",
"wal_writer_flush_after",,"0-2147483647",true,"engine-default","dynamic","integer","(8Kb) Amount of WAL written out by WAL writer triggering a flush.","pending-reboot",
"work_mem",,"64-2147483647",true,"engine-default","dynamic","integer","(kB) Sets the maximum memory to be used for query workspaces.","pending-reboot",
"xmlbinary",,"base64,hex",true,"engine-default","dynamic","string","Sets how binary values are to be encoded in XML.","pending-reboot",
"xmloption",,"content,document",true,"engine-default","dynamic","string","Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.","pending-reboot",
pg_settings
実行内容
pg_settingsの一覧をファイルに出力する
SQL
COPY (SELECT * FROM pg_settings) TO pg_settings.csv WITH CSV HEADER;
実行結果
PostgreSQLのpg_settings一覧
CSVファイル
name,setting,unit,category,short_desc,extra_desc,context,vartype,source,min_val,max_val,enumvals,boot_val,reset_val,sourcefile,sourceline,pending_restart
allow_system_table_mods,off,,Developer Options,Allows modifications of the structure of system tables.,,sighup,bool,default,,,,off,off,,,f
application_name,psql,,Reporting and Logging / What to Log,Sets the application name to be reported in statistics and logs.,,user,string,client,,,,"",psql,,,f
archive_cleanup_command,"",,Write-Ahead Log / Archive Recovery,Sets the shell command that will be executed at every restart point.,,sighup,string,default,,,,"","",,,f
archive_command,/etc/rds/dbbin/pgscripts/rds_wal_archive %p,,Write-Ahead Log / Archiving,Sets the shell command that will be called to archive a WAL file.,,sighup,string,configuration file,,,,"",/etc/rds/dbbin/pgscripts/rds_wal_archive %p,/rdsdbdata/config/postgresql.conf,1,f
archive_mode,on,,Write-Ahead Log / Archiving,Allows archiving of WAL files using archive_command.,,postmaster,enum,configuration file,,,"{always,on,off}",off,on,/rdsdbdata/config/postgresql.conf,83,f
archive_timeout,300,s,Write-Ahead Log / Archiving,Forces a switch to the next WAL file if a new file has not been started within N seconds.,,sighup,integer,configuration file,0,1073741823,,0,300,/rdsdbdata/config/postgresql.conf,2,f
array_nulls,on,,Version and Platform Compatibility / Previous PostgreSQL Versions,Enable input of NULL elements in arrays.,"When turned on, unquoted NULL in an array input value means a null value; otherwise it is taken literally.",user,bool,default,,,,on,on,,,f
authentication_timeout,60,s,Connections and Authentication / Authentication,Sets the maximum allowed time to complete client authentication.,,sighup,integer,default,1,600,,60,60,,,f
autovacuum,on,,Autovacuum,Starts the autovacuum subprocess.,,sighup,bool,default,,,,on,on,,,f
autovacuum_analyze_scale_factor,0.05,,Autovacuum,"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.",,sighup,real,configuration file,0,100,,0.1,0.05,/rdsdbdata/config/postgresql.conf,3,f
autovacuum_analyze_threshold,50,,Autovacuum,"Minimum number of tuple inserts, updates, or deletes prior to analyze.",,sighup,integer,default,0,2147483647,,50,50,,,f
autovacuum_freeze_max_age,200000000,,Autovacuum,Age at which to autovacuum a table to prevent transaction ID wraparound.,,postmaster,integer,default,100000,2000000000,,200000000,200000000,,,f
autovacuum_max_workers,3,,Autovacuum,Sets the maximum number of simultaneously running autovacuum worker processes.,,postmaster,integer,configuration file,1,262143,,3,3,/rdsdbdata/config/postgresql.conf,4,f
autovacuum_multixact_freeze_max_age,400000000,,Autovacuum,Multixact age at which to autovacuum a table to prevent multixact wraparound.,,postmaster,integer,default,10000,2000000000,,400000000,400000000,,,f
autovacuum_naptime,15,s,Autovacuum,Time to sleep between autovacuum runs.,,sighup,integer,configuration file,1,2147483,,60,15,/rdsdbdata/config/postgresql.conf,5,f
autovacuum_vacuum_cost_delay,2,ms,Autovacuum,"Vacuum cost delay in milliseconds, for autovacuum.",,sighup,real,default,-1,100,,2,2,,,f
autovacuum_vacuum_cost_limit,200,,Autovacuum,"Vacuum cost amount available before napping, for autovacuum.",,sighup,integer,configuration file,-1,10000,,-1,200,/rdsdbdata/config/postgresql.conf,6,f
autovacuum_vacuum_insert_scale_factor,0.2,,Autovacuum,Number of tuple inserts prior to vacuum as a fraction of reltuples.,,sighup,real,default,0,100,,0.2,0.2,,,f
autovacuum_vacuum_insert_threshold,1000,,Autovacuum,"Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums.",,sighup,integer,default,-1,2147483647,,1000,1000,,,f
autovacuum_vacuum_scale_factor,0.1,,Autovacuum,Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.,,sighup,real,configuration file,0,100,,0.2,0.1,/rdsdbdata/config/postgresql.conf,7,f
autovacuum_vacuum_threshold,50,,Autovacuum,Minimum number of tuple updates or deletes prior to vacuum.,,sighup,integer,default,0,2147483647,,50,50,,,f
autovacuum_work_mem,-1,kB,Resource Usage / Memory,Sets the maximum memory to be used by each autovacuum worker process.,,sighup,integer,default,-1,2147483647,,-1,-1,,,f
backend_flush_after,0,8kB,Resource Usage / Asynchronous Behavior,Number of pages after which previously performed writes are flushed to disk.,,user,integer,default,0,256,,0,0,,,f
backslash_quote,safe_encoding,,Version and Platform Compatibility / Previous PostgreSQL Versions,"Sets whether ""\'"" is allowed in string literals.",,user,enum,default,,,"{safe_encoding,on,off}",safe_encoding,safe_encoding,,,f
backtrace_functions,"",,Developer Options,Log backtrace for errors in these functions.,,superuser,string,default,,,,"","",,,f
bgwriter_delay,200,ms,Resource Usage / Background Writer,Background writer sleep time between rounds.,,sighup,integer,default,10,10000,,200,200,,,f
bgwriter_flush_after,64,8kB,Resource Usage / Background Writer,Number of pages after which previously performed writes are flushed to disk.,,sighup,integer,default,0,256,,64,64,,,f
bgwriter_lru_maxpages,100,,Resource Usage / Background Writer,Background writer maximum number of LRU pages to flush per round.,,sighup,integer,default,0,1073741823,,100,100,,,f
bgwriter_lru_multiplier,2,,Resource Usage / Background Writer,Multiple of the average buffer usage to free per round.,,sighup,real,default,0,10,,2,2,,,f
block_size,8192,,Preset Options,Shows the size of a disk block.,,internal,integer,default,8192,8192,,8192,8192,,,f
bonjour,off,,Connections and Authentication / Connection Settings,Enables advertising the server via Bonjour.,,postmaster,bool,default,,,,off,off,,,f
bonjour_name,"",,Connections and Authentication / Connection Settings,Sets the Bonjour service name.,,postmaster,string,default,,,,"","",,,f
bytea_output,hex,,Client Connection Defaults / Statement Behavior,Sets the output format for bytea.,,user,enum,default,,,"{escape,hex}",hex,hex,,,f
check_function_bodies,on,,Client Connection Defaults / Statement Behavior,Check function bodies during CREATE FUNCTION.,,user,bool,default,,,,on,on,,,f
checkpoint_completion_target,0.9,,Write-Ahead Log / Checkpoints,"Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.",,sighup,real,configuration file,0,1,,0.5,0.9,/rdsdbdata/config/postgresql.conf,8,f
checkpoint_flush_after,32,8kB,Write-Ahead Log / Checkpoints,Number of pages after which previously performed writes are flushed to disk.,,sighup,integer,default,0,256,,32,32,,,f
checkpoint_timeout,300,s,Write-Ahead Log / Checkpoints,Sets the maximum time between automatic WAL checkpoints.,,sighup,integer,default,30,86400,,300,300,,,f
checkpoint_warning,30,s,Write-Ahead Log / Checkpoints,Enables warnings if checkpoint segments are filled more frequently than this.,Write a message to the server log if checkpoints caused by the filling of checkpoint segment files happens more frequently than this number of seconds. Zero turns off the warning.,sighup,integer,default,0,2147483647,,30,30,,,f
client_encoding,UTF8,,Client Connection Defaults / Locale and Formatting,Sets the client's character set encoding.,,user,string,configuration file,,,,SQL_ASCII,UTF8,/rdsdbdata/config/postgresql.conf,9,f
client_min_messages,notice,,Client Connection Defaults / Statement Behavior,Sets the message levels that are sent to the client.,"Each level includes all the levels that follow it. The later the level, the fewer messages are sent.",user,enum,default,,,"{debug5,debug4,debug3,debug2,debug1,log,notice,warning,error}",notice,notice,,,f
cluster_name,"",,Process Title,"Sets the name of the cluster, which is included in the process title.",,postmaster,string,default,,,,"","",,,f
commit_delay,0,,Write-Ahead Log / Settings,Sets the delay in microseconds between transaction commit and flushing WAL to disk.,,superuser,integer,default,0,100000,,0,0,,,f
commit_siblings,5,,Write-Ahead Log / Settings,Sets the minimum concurrent open transactions before performing commit_delay.,,user,integer,default,0,1000,,5,5,,,f
config_file,/rdsdbdata/config/postgresql.conf,,File Locations,Sets the server's main configuration file.,,postmaster,string,override,,,,,/rdsdbdata/config/postgresql.conf,,,f
constraint_exclusion,partition,,Query Tuning / Other Planner Options,Enables the planner to use constraints to optimize queries.,Table scans will be skipped if their constraints guarantee that no rows match the query.,user,enum,default,,,"{partition,on,off}",partition,partition,,,f
cpu_index_tuple_cost,0.005,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of processing each index entry during an index scan.,,user,real,default,0,1.79769e+308,,0.005,0.005,,,f
cpu_operator_cost,0.0025,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of processing each operator or function call.,,user,real,default,0,1.79769e+308,,0.0025,0.0025,,,f
cpu_tuple_cost,0.01,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of processing each tuple (row).,,user,real,default,0,1.79769e+308,,0.01,0.01,,,f
cursor_tuple_fraction,0.1,,Query Tuning / Other Planner Options,Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.,,user,real,default,0,1,,0.1,0.1,,,f
data_checksums,on,,Preset Options,Shows whether data checksums are turned on for this cluster.,,internal,bool,override,,,,off,on,,,f
data_directory,/rdsdbdata/db,,File Locations,Sets the server's data directory.,,postmaster,string,override,,,,,/rdsdbdata/db,,,f
data_directory_mode,0700,,Preset Options,Mode of the data directory.,The parameter value is a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).),internal,integer,default,0,511,,448,448,,,f
data_sync_retry,off,,Error Handling,Whether to continue running after a failure to sync data files.,,postmaster,bool,default,,,,off,off,,,f
DateStyle,"ISO, MDY",,Client Connection Defaults / Locale and Formatting,Sets the display format for date and time values.,Also controls interpretation of ambiguous date inputs.,user,string,default,,,,"ISO, MDY","ISO, MDY",,,f
db_user_namespace,off,,Connections and Authentication / Authentication,Enables per-database user names.,,sighup,bool,default,,,,off,off,,,f
deadlock_timeout,1000,ms,Lock Management,Sets the time to wait on a lock before checking for deadlock.,,superuser,integer,default,1,2147483647,,1000,1000,,,f
debug_assertions,off,,Preset Options,Shows whether the running server has assertion checks enabled.,,internal,bool,default,,,,off,off,,,f
debug_pretty_print,on,,Reporting and Logging / What to Log,Indents parse and plan tree displays.,,user,bool,default,,,,on,on,,,f
debug_print_parse,off,,Reporting and Logging / What to Log,Logs each query's parse tree.,,user,bool,default,,,,off,off,,,f
debug_print_plan,off,,Reporting and Logging / What to Log,Logs each query's execution plan.,,user,bool,default,,,,off,off,,,f
debug_print_rewritten,off,,Reporting and Logging / What to Log,Logs each query's rewritten parse tree.,,user,bool,default,,,,off,off,,,f
default_statistics_target,100,,Query Tuning / Other Planner Options,Sets the default statistics target.,This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS.,user,integer,default,1,10000,,100,100,,,f
default_table_access_method,heap,,Client Connection Defaults / Statement Behavior,Sets the default table access method for new tables.,,user,string,default,,,,heap,heap,,,f
default_tablespace,"",,Client Connection Defaults / Statement Behavior,Sets the default tablespace to create tables and indexes in.,An empty string selects the database's default tablespace.,user,string,default,,,,"","",,,f
default_text_search_config,pg_catalog.simple,,Client Connection Defaults / Locale and Formatting,Sets default text search configuration.,,user,string,default,,,,pg_catalog.simple,pg_catalog.simple,,,f
default_transaction_deferrable,off,,Client Connection Defaults / Statement Behavior,Sets the default deferrable status of new transactions.,,user,bool,default,,,,off,off,,,f
default_transaction_isolation,read committed,,Client Connection Defaults / Statement Behavior,Sets the transaction isolation level of each new transaction.,,user,enum,default,,,"{serializable,""repeatable read"",""read committed"",""read uncommitted""}",read committed,read committed,,,f
default_transaction_read_only,off,,Client Connection Defaults / Statement Behavior,Sets the default read-only status of new transactions.,,user,bool,default,,,,off,off,,,f
dynamic_library_path,$libdir,,Client Connection Defaults / Other Defaults,Sets the path for dynamically loadable modules.,"If a dynamically loadable module needs to be opened and the specified name does not have a directory component (i.e., the name does not contain a slash), the system will search this path for the specified file.",superuser,string,default,,,,$libdir,$libdir,,,f
dynamic_shared_memory_type,posix,,Resource Usage / Memory,Selects the dynamic shared memory implementation used.,,postmaster,enum,default,,,"{posix,sysv,mmap}",posix,posix,,,f
effective_cache_size,484081,8kB,Query Tuning / Planner Cost Constants,Sets the planner's assumption about the total size of the data caches.,"That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. This is measured in disk pages, which are normally 8 kB each.",user,integer,configuration file,1,2147483647,,524288,484081,/rdsdbdata/config/postgresql.conf,17,f
effective_io_concurrency,1,,Resource Usage / Asynchronous Behavior,Number of simultaneous requests that can be handled efficiently by the disk subsystem.,,user,integer,default,0,1000,,1,1,,,f
enable_bitmapscan,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of bitmap-scan plans.,,user,bool,default,,,,on,on,,,f
enable_gathermerge,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of gather merge plans.,,user,bool,default,,,,on,on,,,f
enable_hashagg,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of hashed aggregation plans.,,user,bool,default,,,,on,on,,,f
enable_hashjoin,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of hash join plans.,,user,bool,default,,,,on,on,,,f
enable_incremental_sort,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of incremental sort steps.,,user,bool,default,,,,on,on,,,f
enable_indexonlyscan,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of index-only-scan plans.,,user,bool,default,,,,on,on,,,f
enable_indexscan,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of index-scan plans.,,user,bool,default,,,,on,on,,,f
enable_material,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of materialization.,,user,bool,default,,,,on,on,,,f
enable_mergejoin,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of merge join plans.,,user,bool,default,,,,on,on,,,f
enable_nestloop,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of nested-loop join plans.,,user,bool,default,,,,on,on,,,f
enable_parallel_append,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of parallel append plans.,,user,bool,default,,,,on,on,,,f
enable_parallel_hash,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of parallel hash plans.,,user,bool,default,,,,on,on,,,f
enable_partition_pruning,on,,Query Tuning / Planner Method Configuration,Enables plan-time and run-time partition pruning.,Allows the query planner and executor to compare partition bounds to conditions in the query to determine which partitions must be scanned.,user,bool,default,,,,on,on,,,f
enable_partitionwise_aggregate,off,,Query Tuning / Planner Method Configuration,Enables partitionwise aggregation and grouping.,,user,bool,default,,,,off,off,,,f
enable_partitionwise_join,off,,Query Tuning / Planner Method Configuration,Enables partitionwise join.,,user,bool,default,,,,off,off,,,f
enable_seqscan,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of sequential-scan plans.,,user,bool,default,,,,on,on,,,f
enable_sort,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of explicit sort steps.,,user,bool,default,,,,on,on,,,f
enable_tidscan,on,,Query Tuning / Planner Method Configuration,Enables the planner's use of TID scan plans.,,user,bool,default,,,,on,on,,,f
escape_string_warning,on,,Version and Platform Compatibility / Previous PostgreSQL Versions,Warn about backslash escapes in ordinary string literals.,,user,bool,default,,,,on,on,,,f
event_source,PostgreSQL,,Reporting and Logging / Where to Log,Sets the application name used to identify PostgreSQL messages in the event log.,,postmaster,string,default,,,,PostgreSQL,PostgreSQL,,,f
exit_on_error,off,,Error Handling,Terminate session on any error.,,user,bool,default,,,,off,off,,,f
external_pid_file,"",,File Locations,Writes the postmaster PID to the specified file.,,postmaster,string,default,,,,,,,,f
extra_float_digits,1,,Client Connection Defaults / Locale and Formatting,Sets the number of digits displayed for floating-point values.,"This affects real, double precision, and geometric data types. A zero or negative parameter value is added to the standard number of digits (FLT_DIG or DBL_DIG as appropriate). Any value greater than zero selects precise output mode.",user,integer,default,-15,3,,1,1,,,f
force_parallel_mode,off,,Query Tuning / Other Planner Options,Forces use of parallel query facilities.,"If possible, run query using a parallel worker and with parallel restrictions.",user,enum,default,,,"{off,on,regress}",off,off,,,f
from_collapse_limit,8,,Query Tuning / Other Planner Options,Sets the FROM-list size beyond which subqueries are not collapsed.,The planner will merge subqueries into upper queries if the resulting FROM list would have no more than this many items.,user,integer,default,1,2147483647,,8,8,,,f
fsync,on,,Write-Ahead Log / Settings,Forces synchronization of updates to disk.,The server will use the fsync() system call in several places to make sure that updates are physically written to disk. This insures that a database cluster will recover to a consistent state after an operating system or hardware crash.,sighup,bool,configuration file,,,,on,on,/rdsdbdata/config/postgresql.conf,18,f
full_page_writes,on,,Write-Ahead Log / Settings,Writes full pages to WAL when first modified after a checkpoint.,"A page write in process during an operating system crash might be only partially written to disk. During recovery, the row changes stored in WAL are not enough to recover. This option writes pages when first modified after a checkpoint to WAL so full recovery is possible.",sighup,bool,configuration file,,,,on,on,/rdsdbdata/config/postgresql.conf,19,f
geqo,on,,Query Tuning / Genetic Query Optimizer,Enables genetic query optimization.,This algorithm attempts to do planning without exhaustive searching.,user,bool,default,,,,on,on,,,f
geqo_effort,5,,Query Tuning / Genetic Query Optimizer,GEQO: effort is used to set the default for other GEQO parameters.,,user,integer,default,1,10,,5,5,,,f
geqo_generations,0,,Query Tuning / Genetic Query Optimizer,GEQO: number of iterations of the algorithm.,Zero selects a suitable default value.,user,integer,default,0,2147483647,,0,0,,,f
geqo_pool_size,0,,Query Tuning / Genetic Query Optimizer,GEQO: number of individuals in the population.,Zero selects a suitable default value.,user,integer,default,0,2147483647,,0,0,,,f
geqo_seed,0,,Query Tuning / Genetic Query Optimizer,GEQO: seed for random path selection.,,user,real,default,0,1,,0,0,,,f
geqo_selection_bias,2,,Query Tuning / Genetic Query Optimizer,GEQO: selective pressure within the population.,,user,real,default,1.5,2,,2,2,,,f
geqo_threshold,12,,Query Tuning / Genetic Query Optimizer,Sets the threshold of FROM items beyond which GEQO is used.,,user,integer,default,2,2147483647,,12,12,,,f
gin_fuzzy_search_limit,0,,Client Connection Defaults / Other Defaults,Sets the maximum allowed result for exact search by GIN.,,user,integer,default,0,2147483647,,0,0,,,f
gin_pending_list_limit,4096,kB,Client Connection Defaults / Statement Behavior,Sets the maximum size of the pending list for GIN index.,,user,integer,default,64,2147483647,,4096,4096,,,f
hash_mem_multiplier,1,,Resource Usage / Memory,Multiple of work_mem to use for hash tables.,,user,real,default,1,1000,,1,1,,,f
hba_file,/rdsdbdata/config/pg_hba.conf,,File Locations,"Sets the server's ""hba"" configuration file.",,postmaster,string,override,,,,,/rdsdbdata/config/pg_hba.conf,,,f
hot_standby,off,,Replication / Standby Servers,Allows connections and queries during recovery.,,postmaster,bool,configuration file,,,,on,off,/rdsdbdata/config/postgresql.conf,78,f
hot_standby_feedback,off,,Replication / Standby Servers,Allows feedback from a hot standby to the primary that will avoid query conflicts.,,sighup,bool,default,,,,off,off,,,f
huge_pages,on,,Resource Usage / Memory,Use of huge pages on Linux or Windows.,,postmaster,enum,configuration file,,,"{off,on,try}",try,on,/rdsdbdata/config/postgresql.conf,85,f
ident_file,/rdsdbdata/config/pg_ident.conf,,File Locations,"Sets the server's ""ident"" configuration file.",,postmaster,string,override,,,,,/rdsdbdata/config/pg_ident.conf,,,f
idle_in_transaction_session_timeout,86400000,ms,Client Connection Defaults / Statement Behavior,Sets the maximum allowed duration of any idling transaction.,A value of 0 turns off the timeout.,user,integer,configuration file,0,2147483647,,0,86400000,/rdsdbdata/config/postgresql.conf,22,f
ignore_checksum_failure,off,,Developer Options,Continues processing after a checksum failure.,"Detection of a checksum failure normally causes PostgreSQL to report an error, aborting the current transaction. Setting ignore_checksum_failure to true causes the system to ignore the failure (but still report a warning), and continue processing. This behavior could cause crashes or other serious problems. Only has an effect if checksums are enabled.",superuser,bool,default,,,,off,off,,,f
ignore_invalid_pages,off,,Developer Options,Continues recovery after an invalid pages failure.,"Detection of WAL records having references to invalid pages during recovery causes PostgreSQL to raise a PANIC-level error, aborting the recovery. Setting ignore_invalid_pages to true causes the system to ignore invalid page references in WAL records (but still report a warning), and continue recovery. This behavior may cause crashes, data loss, propagate or hide corruption, or other serious problems. Only has an effect during recovery or in standby mode.",postmaster,bool,configuration file,,,,off,off,/rdsdbdata/config/postgresql.conf,23,f
ignore_system_indexes,off,,Developer Options,Disables reading from system indexes.,"It does not prevent updating the indexes, so it is safe to use. The worst consequence is slowness.",backend,bool,default,,,,off,off,,,f
integer_datetimes,on,,Preset Options,Datetimes are integer based.,,internal,bool,default,,,,on,on,,,f
IntervalStyle,postgres,,Client Connection Defaults / Locale and Formatting,Sets the display format for interval values.,,user,enum,default,,,"{postgres,postgres_verbose,sql_standard,iso_8601}",postgres,postgres,,,f
jit,off,,Query Tuning / Other Planner Options,Allow JIT compilation.,,user,bool,configuration file,,,,on,off,/rdsdbdata/config/postgresql.conf,24,f
jit_above_cost,100000,,Query Tuning / Planner Cost Constants,Perform JIT compilation if query is more expensive.,-1 disables JIT compilation.,user,real,default,-1,1.79769e+308,,100000,100000,,,f
jit_debugging_support,off,,Developer Options,Register JIT compiled function with debugger.,,superuser-backend,bool,default,,,,off,off,,,f
jit_dump_bitcode,off,,Developer Options,Write out LLVM bitcode to facilitate JIT debugging.,,superuser,bool,default,,,,off,off,,,f
jit_expressions,on,,Developer Options,Allow JIT compilation of expressions.,,user,bool,default,,,,on,on,,,f
jit_inline_above_cost,500000,,Query Tuning / Planner Cost Constants,Perform JIT inlining if query is more expensive.,-1 disables inlining.,user,real,default,-1,1.79769e+308,,500000,500000,,,f
jit_optimize_above_cost,500000,,Query Tuning / Planner Cost Constants,Optimize JITed functions if query is more expensive.,-1 disables optimization.,user,real,default,-1,1.79769e+308,,500000,500000,,,f
jit_profiling_support,off,,Developer Options,Register JIT compiled function with perf profiler.,,superuser-backend,bool,default,,,,off,off,,,f
jit_provider,llvmjit,,Client Connection Defaults / Shared Library Preloading,JIT provider to use.,,postmaster,string,default,,,,llvmjit,llvmjit,,,f
jit_tuple_deforming,on,,Developer Options,Allow JIT compilation of tuple deforming.,,user,bool,default,,,,on,on,,,f
join_collapse_limit,8,,Query Tuning / Other Planner Options,Sets the FROM-list size beyond which JOIN constructs are not flattened.,The planner will flatten explicit JOIN constructs into lists of FROM items whenever a list of no more than this many items would result.,user,integer,default,1,2147483647,,8,8,,,f
krb_caseins_users,off,,Connections and Authentication / Authentication,Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.,,sighup,bool,default,,,,off,off,,,f
krb_server_keyfile,/rdsdbdata/config/keytab,,Connections and Authentication / Authentication,Sets the location of the Kerberos server key file.,,sighup,string,configuration file,,,,FILE:/rdsdbbin/postgres-13.4.R1/etc/krb5.keytab,/rdsdbdata/config/keytab,/rdsdbdata/config/postgresql.conf,25,f
lc_collate,en_US.UTF-8,,Client Connection Defaults / Locale and Formatting,Shows the collation order locale.,,internal,string,override,,,,C,en_US.UTF-8,,,f
lc_ctype,en_US.UTF-8,,Client Connection Defaults / Locale and Formatting,Shows the character classification and case conversion locale.,,internal,string,override,,,,C,en_US.UTF-8,,,f
lc_messages,"",,Client Connection Defaults / Locale and Formatting,Sets the language in which messages are displayed.,,superuser,string,default,,,,"","",,,f
lc_monetary,C,,Client Connection Defaults / Locale and Formatting,Sets the locale for formatting monetary amounts.,,user,string,default,,,,C,C,,,f
lc_numeric,C,,Client Connection Defaults / Locale and Formatting,Sets the locale for formatting numbers.,,user,string,default,,,,C,C,,,f
lc_time,C,,Client Connection Defaults / Locale and Formatting,Sets the locale for formatting date and time values.,,user,string,default,,,,C,C,,,f
listen_addresses,*,,Connections and Authentication / Connection Settings,Sets the host name or IP address(es) to listen to.,,postmaster,string,command line,,,,localhost,*,,,f
lo_compat_privileges,off,,Version and Platform Compatibility / Previous PostgreSQL Versions,Enables backward compatibility mode for privilege checks on large objects.,"Skips privilege checks when reading or modifying large objects, for compatibility with PostgreSQL releases prior to 9.0.",superuser,bool,configuration file,,,,off,off,/rdsdbdata/config/postgresql.conf,27,f
local_preload_libraries,"",,Client Connection Defaults / Shared Library Preloading,Lists unprivileged shared libraries to preload into each backend.,,superuser,string,default,,,,"","",,,f
lock_timeout,0,ms,Client Connection Defaults / Statement Behavior,Sets the maximum allowed duration of any wait for a lock.,A value of 0 turns off the timeout.,user,integer,default,0,2147483647,,0,0,,,f
log_autovacuum_min_duration,10000,ms,Reporting and Logging / What to Log,Sets the minimum execution time above which autovacuum actions will be logged.,Zero prints all actions. -1 turns autovacuum logging off.,sighup,integer,configuration file,-1,2147483647,,-1,10000,/rdsdbdata/config/postgresql.conf,28,f
log_checkpoints,on,,Reporting and Logging / What to Log,Logs each checkpoint.,,sighup,bool,configuration file,,,,off,on,/rdsdbdata/config/postgresql.conf,29,f
log_connections,off,,Reporting and Logging / What to Log,Logs each successful connection.,,superuser-backend,bool,default,,,,off,off,,,f
log_destination,stderr,,Reporting and Logging / Where to Log,Sets the destination for server log output.,"Valid values are combinations of ""stderr"", ""syslog"", ""csvlog"", and ""eventlog"", depending on the platform.",sighup,string,configuration file,,,,stderr,stderr,/rdsdbdata/config/postgresql.conf,88,f
log_directory,/rdsdbdata/log/error,,Reporting and Logging / Where to Log,Sets the destination directory for log files.,Can be specified as relative to the data directory or as absolute path.,sighup,string,configuration file,,,,log,/rdsdbdata/log/error,/rdsdbdata/config/postgresql.conf,30,f
log_disconnections,off,,Reporting and Logging / What to Log,"Logs end of a session, including duration.",,superuser-backend,bool,default,,,,off,off,,,f
log_duration,off,,Reporting and Logging / What to Log,Logs the duration of each completed SQL statement.,,rds_superuser,bool,default,,,,off,off,,,f
log_error_verbosity,default,,Reporting and Logging / What to Log,Sets the verbosity of logged messages.,,rds_superuser,enum,default,,,"{terse,default,verbose}",default,default,,,f
log_executor_stats,off,,Statistics / Monitoring,Writes executor performance statistics to the server log.,,rds_superuser,bool,default,,,,off,off,,,f
log_file_mode,0644,,Reporting and Logging / Where to Log,Sets the file permissions for log files.,The parameter value is expected to be a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).),sighup,integer,configuration file,0,511,,384,420,/rdsdbdata/config/postgresql.conf,31,f
log_filename,postgresql.log.%Y-%m-%d-%H,,Reporting and Logging / Where to Log,Sets the file name pattern for log files.,,sighup,string,configuration file,,,,postgresql-%Y-%m-%d_%H%M%S.log,postgresql.log.%Y-%m-%d-%H,/rdsdbdata/config/postgresql.conf,32,f
log_hostname,off,,Reporting and Logging / What to Log,Logs the host name in the connection logs.,"By default, connection logs only show the IP address of the connecting host. If you want them to show the host name you can turn this on, but depending on your host name resolution setup it might impose a non-negligible performance penalty.",sighup,bool,default,,,,off,off,,,f
log_line_prefix,%t:%r:%u@%d:[%p]:,,Reporting and Logging / What to Log,Controls information prefixed to each log line.,"If blank, no prefix is used.",sighup,string,configuration file,,,,%m [%p] ,%t:%r:%u@%d:[%p]:,/rdsdbdata/config/postgresql.conf,34,f
log_lock_waits,off,,Reporting and Logging / What to Log,Logs long lock waits.,,rds_superuser,bool,default,,,,off,off,,,f
log_min_duration_sample,-1,ms,Reporting and Logging / When to Log,Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.,Zero logs a sample of all queries. -1 turns this feature off.,rds_superuser,integer,default,-1,2147483647,,-1,-1,,,f
log_min_duration_statement,-1,ms,Reporting and Logging / When to Log,Sets the minimum execution time above which all statements will be logged.,Zero prints all queries. -1 turns this feature off.,rds_superuser,integer,default,-1,2147483647,,-1,-1,,,f
log_min_error_statement,error,,Reporting and Logging / When to Log,Causes all statements generating error at or above this level to be logged.,"Each level includes all the levels that follow it. The later the level, the fewer messages are sent.",rds_superuser,enum,default,,,"{debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic}",error,error,,,f
log_min_messages,warning,,Reporting and Logging / When to Log,Sets the message levels that are logged.,"Each level includes all the levels that follow it. The later the level, the fewer messages are sent.",rds_superuser,enum,default,,,"{debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic}",warning,warning,,,f
log_parameter_max_length,-1,B,Reporting and Logging / What to Log,"When logging statements, limit logged parameter values to first N bytes.",-1 to print values in full.,superuser,integer,default,-1,1073741823,,-1,-1,,,f
log_parameter_max_length_on_error,0,B,Reporting and Logging / What to Log,"When reporting an error, limit logged parameter values to first N bytes.",-1 to print values in full.,user,integer,default,-1,1073741823,,0,0,,,f
log_parser_stats,off,,Statistics / Monitoring,Writes parser performance statistics to the server log.,,rds_superuser,bool,default,,,,off,off,,,f
log_planner_stats,off,,Statistics / Monitoring,Writes planner performance statistics to the server log.,,rds_superuser,bool,default,,,,off,off,,,f
log_replication_commands,off,,Reporting and Logging / What to Log,Logs each replication command.,,rds_superuser,bool,default,,,,off,off,,,f
log_rotation_age,60,min,Reporting and Logging / Where to Log,Automatic log file rotation will occur after N minutes.,,sighup,integer,configuration file,0,35791394,,1440,60,/rdsdbdata/config/postgresql.conf,35,f
log_rotation_size,10240,kB,Reporting and Logging / Where to Log,Automatic log file rotation will occur after N kilobytes.,,sighup,integer,default,0,2097151,,10240,10240,,,f
log_statement,none,,Reporting and Logging / What to Log,Sets the type of statements logged.,,rds_superuser,enum,default,,,"{none,ddl,mod,all}",none,none,,,f
log_statement_sample_rate,1,,Reporting and Logging / When to Log,Fraction of statements exceeding log_min_duration_sample to be logged.,Use a value between 0.0 (never log) and 1.0 (always log).,rds_superuser,real,default,0,1,,1,1,,,f
log_statement_stats,off,,Statistics / Monitoring,Writes cumulative performance statistics to the server log.,,rds_superuser,bool,default,,,,off,off,,,f
log_temp_files,-1,kB,Reporting and Logging / What to Log,Log the use of temporary files larger than this number of kilobytes.,Zero logs all files. The default is -1 (turning this feature off).,rds_superuser,integer,default,-1,2147483647,,-1,-1,,,f
log_timezone,UTC,,Reporting and Logging / What to Log,Sets the time zone to use in log messages.,,sighup,string,configuration file,,,,GMT,UTC,/rdsdbdata/config/postgresql.conf,36,f
log_transaction_sample_rate,0,,Reporting and Logging / When to Log,Set the fraction of transactions to log for new transactions.,Logs all statements from a fraction of transactions. Use a value between 0.0 (never log) and 1.0 (log all statements for all transactions).,superuser,real,default,0,1,,0,0,,,f
log_truncate_on_rotation,off,,Reporting and Logging / Where to Log,Truncate existing log files of same name during log rotation.,,sighup,bool,configuration file,,,,off,off,/rdsdbdata/config/postgresql.conf,37,f
logging_collector,on,,Reporting and Logging / Where to Log,Start a subprocess to capture stderr output and/or csvlogs into log files.,,postmaster,bool,configuration file,,,,off,on,/rdsdbdata/config/postgresql.conf,33,f
logical_decoding_work_mem,65536,kB,Resource Usage / Memory,Sets the maximum memory to be used for logical decoding.,This much memory can be used by each internal reorder buffer before spilling to disk.,user,integer,default,64,2147483647,,65536,65536,,,f
maintenance_io_concurrency,10,,Resource Usage / Asynchronous Behavior,A variant of effective_io_concurrency that is used for maintenance work.,,user,integer,default,0,1000,,10,10,,,f
maintenance_work_mem,126972,kB,Resource Usage / Memory,Sets the maximum memory to be used for maintenance operations.,This includes operations such as VACUUM and CREATE INDEX.,user,integer,configuration file,1024,2147483647,,65536,126972,/rdsdbdata/config/postgresql.conf,38,f
max_connections,832,,Connections and Authentication / Connection Settings,Sets the maximum number of concurrent connections.,,postmaster,integer,configuration file,1,262143,,100,832,/rdsdbdata/config/postgresql.conf,39,f
max_files_per_process,1000,,Resource Usage / Kernel Resources,Sets the maximum number of simultaneously open files for each server process.,,postmaster,integer,default,64,2147483647,,1000,1000,,,f
max_function_args,100,,Preset Options,Shows the maximum number of function arguments.,,internal,integer,default,100,100,,100,100,,,f
max_identifier_length,63,,Preset Options,Shows the maximum identifier length.,,internal,integer,default,63,63,,63,63,,,f
max_index_keys,32,,Preset Options,Shows the maximum number of index keys.,,internal,integer,default,32,32,,32,32,,,f
max_locks_per_transaction,64,,Lock Management,Sets the maximum number of locks per transaction.,The shared lock table is sized on the assumption that at most max_locks_per_transaction * max_connections distinct objects will need to be locked at any one time.,postmaster,integer,configuration file,10,2147483647,,64,64,/rdsdbdata/config/postgresql.conf,40,f
max_logical_replication_workers,4,,Replication / Subscribers,Maximum number of logical replication worker processes.,,postmaster,integer,default,0,262143,,4,4,,,f
max_parallel_maintenance_workers,2,,Resource Usage / Asynchronous Behavior,Sets the maximum number of parallel processes per maintenance operation.,,user,integer,default,0,1024,,2,2,,,f
max_parallel_workers,8,,Resource Usage / Asynchronous Behavior,Sets the maximum number of parallel workers that can be active at one time.,,user,integer,configuration file,0,1024,,8,8,/rdsdbdata/config/postgresql.conf,41,f
max_parallel_workers_per_gather,2,,Resource Usage / Asynchronous Behavior,Sets the maximum number of parallel processes per executor node.,,user,integer,default,0,1024,,2,2,,,f
max_pred_locks_per_page,2,,Lock Management,Sets the maximum number of predicate-locked tuples per page.,"If more than this number of tuples on the same page are locked by a connection, those locks are replaced by a page-level lock.",sighup,integer,default,0,2147483647,,2,2,,,f
max_pred_locks_per_relation,-2,,Lock Management,Sets the maximum number of predicate-locked pages and tuples per relation.,"If more than this total of pages and tuples in the same relation are locked by a connection, those locks are replaced by a relation-level lock.",sighup,integer,default,-2147483648,2147483647,,-2,-2,,,f
max_pred_locks_per_transaction,64,,Lock Management,Sets the maximum number of predicate locks per transaction.,The shared predicate lock table is sized on the assumption that at most max_pred_locks_per_transaction * max_connections distinct objects will need to be locked at any one time.,postmaster,integer,default,10,2147483647,,64,64,,,f
max_prepared_transactions,0,,Resource Usage / Memory,Sets the maximum number of simultaneously prepared transactions.,,postmaster,integer,configuration file,0,262143,,0,0,/rdsdbdata/config/postgresql.conf,42,f
max_replication_slots,20,,Replication / Sending Servers,Sets the maximum number of simultaneously defined replication slots.,,postmaster,integer,configuration file,0,262143,,10,20,/rdsdbdata/config/postgresql.conf,82,f
max_slot_wal_keep_size,-1,MB,Replication / Sending Servers,Sets the maximum WAL size that can be reserved by replication slots.,"Replication slots will be marked as failed, and segments released for deletion or recycling, if this much space is occupied by WAL on disk.",sighup,integer,default,-1,2147483647,,-1,-1,,,f
max_stack_depth,6144,kB,Resource Usage / Memory,"Sets the maximum stack depth, in kilobytes.",,superuser,integer,configuration file,100,2147483647,,100,6144,/rdsdbdata/config/postgresql.conf,43,f
max_standby_archive_delay,30000,ms,Replication / Standby Servers,Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.,,sighup,integer,default,-1,2147483647,,30000,30000,,,f
max_standby_streaming_delay,30000,ms,Replication / Standby Servers,Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.,,sighup,integer,default,-1,2147483647,,30000,30000,,,f
max_sync_workers_per_subscription,2,,Replication / Subscribers,Maximum number of table synchronization workers per subscription.,,sighup,integer,default,0,262143,,2,2,,,f
max_wal_senders,20,,Replication / Sending Servers,Sets the maximum number of simultaneously running WAL sender processes.,,postmaster,integer,configuration file,0,262143,,10,20,/rdsdbdata/config/postgresql.conf,89,f
max_wal_size,2048,MB,Write-Ahead Log / Checkpoints,Sets the WAL size that triggers a checkpoint.,,sighup,integer,configuration file,2,2147483647,,1024,2048,/rdsdbdata/config/postgresql.conf,44,f
max_worker_processes,8,,Resource Usage / Asynchronous Behavior,Maximum number of concurrent worker processes.,,postmaster,integer,configuration file,0,262143,,8,8,/rdsdbdata/config/postgresql.conf,45,f
min_parallel_index_scan_size,64,8kB,Query Tuning / Planner Cost Constants,Sets the minimum amount of index data for a parallel scan.,"If the planner estimates that it will read a number of index pages too small to reach this limit, a parallel scan will not be considered.",user,integer,default,0,715827882,,64,64,,,f
min_parallel_table_scan_size,1024,8kB,Query Tuning / Planner Cost Constants,Sets the minimum amount of table data for a parallel scan.,"If the planner estimates that it will read a number of table pages too small to reach this limit, a parallel scan will not be considered.",user,integer,default,0,715827882,,1024,1024,,,f
min_wal_size,192,MB,Write-Ahead Log / Checkpoints,Sets the minimum size to shrink the WAL to.,,sighup,integer,configuration file,2,2147483647,,80,192,/rdsdbdata/config/postgresql.conf,46,f
old_snapshot_threshold,-1,min,Resource Usage / Asynchronous Behavior,Time before a snapshot is too old to read pages changed after the snapshot was taken.,A value of -1 disables this feature.,postmaster,integer,default,-1,86400,,-1,-1,,,f
operator_precedence_warning,off,,Version and Platform Compatibility / Previous PostgreSQL Versions,Emit a warning for constructs that changed meaning since PostgreSQL 9.4.,,user,bool,default,,,,off,off,,,f
parallel_leader_participation,on,,Resource Usage / Asynchronous Behavior,Controls whether Gather and Gather Merge also run subplans.,"Should gather nodes also run subplans, or just gather tuples?",user,bool,default,,,,on,on,,,f
parallel_setup_cost,1000,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of starting up worker processes for parallel query.,,user,real,default,0,1.79769e+308,,1000,1000,,,f
parallel_tuple_cost,0.1,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.,,user,real,default,0,1.79769e+308,,0.1,0.1,,,f
password_encryption,md5,,Connections and Authentication / Authentication,Chooses the algorithm for encrypting passwords.,,user,enum,configuration file,,,"{md5,scram-sha-256}",md5,md5,/rdsdbdata/config/postgresql.conf,47,f
pg_stat_statements.max,5000,,Customized Options,Sets the maximum number of statements tracked by pg_stat_statements.,,postmaster,integer,default,100,2147483647,,5000,5000,,,f
pg_stat_statements.save,on,,Customized Options,Save pg_stat_statements statistics across server shutdowns.,,sighup,bool,default,,,,on,on,,,f
pg_stat_statements.track,top,,Customized Options,Selects which statements are tracked by pg_stat_statements.,,superuser,enum,default,,,"{none,top,all}",top,top,,,f
pg_stat_statements.track_planning,off,,Customized Options,Selects whether planning duration is tracked by pg_stat_statements.,,superuser,bool,default,,,,off,off,,,f
pg_stat_statements.track_utility,on,,Customized Options,Selects whether utility commands are tracked by pg_stat_statements.,,superuser,bool,default,,,,on,on,,,f
plan_cache_mode,auto,,Query Tuning / Other Planner Options,Controls the planner's selection of custom or generic plan.,"Prepared statements can have custom and generic plans, and the planner will attempt to choose which is better. This can be set to override the default behavior.",user,enum,default,,,"{auto,force_generic_plan,force_custom_plan}",auto,auto,,,f
port,5432,,Connections and Authentication / Connection Settings,Sets the TCP port the server listens on.,,postmaster,integer,configuration file,1,65535,,5432,5432,/rdsdbdata/config/postgresql.conf,51,f
post_auth_delay,0,s,Developer Options,Waits N seconds on connection startup after authentication.,This allows attaching a debugger to the process.,backend,integer,default,0,2147,,0,0,,,f
pre_auth_delay,0,s,Developer Options,Waits N seconds on connection startup before authentication.,This allows attaching a debugger to the process.,sighup,integer,default,0,60,,0,0,,,f
primary_slot_name,"",,Replication / Standby Servers,Sets the name of the replication slot to use on the sending server.,,sighup,string,default,,,,"","",,,f
promote_trigger_file,"",,Replication / Standby Servers,Specifies a file name whose presence ends recovery in the standby.,,sighup,string,default,,,,"","",,,f
quote_all_identifiers,off,,Version and Platform Compatibility / Previous PostgreSQL Versions,"When generating SQL fragments, quote all identifiers.",,user,bool,default,,,,off,off,,,f
random_page_cost,4,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of a nonsequentially fetched disk page.,,user,real,default,0,1.79769e+308,,4,4,,,f
rds.allowed_extensions,*,,Customized Options,Comma-delimited list of extensions that may be installed.,"If set to ""*"", all extensions may be installed.",sighup,string,default,,,,*,*,,,f
rds.check_extension_connections,on,,Customized Options,Controls whether connections made from extensions are verified.,,sighup,bool,default,,,,on,on,,,f
rds.extension_events_dir_path,/rdsdbdata/extensions/events,,Customized Options,Path of extension event files directory.,,sighup,string,default,,,,/rdsdbdata/extensions/events,/rdsdbdata/extensions/events,,,f
rds.extension_installation_tracking_enabled,on,,Customized Options,Enables extension installation tracking.,,sighup,bool,default,,,,on,on,,,f
rds.extensions,"address_standardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool_plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control, fuzzystrmatch, hll, hstore, hstore_plperl, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, oracle_fdw, orafce, pageinspect, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_transport, pg_trgm, pg_visibility, plcoffee, plls, plperl, plpgsql, plprofiler, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, sslinfo, tablefunc, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp",,Customized Options,Extensions rds_superusers may install.,,superuser,string,configuration file,,,,,"address_standardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool_plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control, fuzzystrmatch, hll, hstore, hstore_plperl, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, oracle_fdw, orafce, pageinspect, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_transport, pg_trgm, pg_visibility, plcoffee, plls, plperl, plpgsql, plprofiler, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, sslinfo, tablefunc, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp",/rdsdbdata/config/postgresql.conf,53,f
rds.force_admin_logging_level,disabled,,Customized Options,Emit log messages from the RDS admin user irrespective of other logging configuration.,Each level includes all the levels that follow it.Set to disabled to disable this feature and fall back to using log_min_messages.,sighup,enum,default,,,"{debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic,disabled}",disabled,disabled,,,f
rds.force_autovacuum_logging_level,warning,,Customized Options,Emit autovacuum log messages irrespective of other logging configuration.,Each level includes all the levels that follow it.Set to disabled to disable this feature and fall back to using log_min_messages.,sighup,enum,configuration file,,,"{debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic,disabled}",disabled,warning,/rdsdbdata/config/postgresql.conf,54,f
rds.instance_store_replication_tooling,off,,Customized Options,Enables additional replication tooling for storing pg_wal on an instance store volume.,,postmaster,bool,default,,,,off,off,,,f
rds.internal_databases,"rdsadmin,template0",,Customized Options,Special RDS internal use databases that are protected.,,sighup,string,configuration file,,,,"rdsadmin,template0","rdsadmin,template0",/rdsdbdata/config/postgresql.conf,90,f
rds.logical_replication,off,,Customized Options,Enables logical decoding.,,postmaster,bool,configuration file,,,,off,off,/rdsdbdata/config/postgresql.conf,86,f
rds.rds_superuser_reserved_connections,2,,Connections and Authentication / Connection Settings,Sets the number of connection slots reserved for rds_superusers.,,postmaster,integer,configuration file,0,262143,,2,2,/rdsdbdata/config/postgresql.conf,55,f
rds.recovery_target_lsn,"",,Customized Options,PITR should succeed if the latest replayed LSN is >= this value.,,sighup,string,default,,,,"","",,,f
rds.restrict_logical_slot_creation,off,,Replication / Sending Servers,Restrict logical slot creation over streaming replication protocol.,,superuser,bool,default,,,,off,off,,,f
rds.restrict_password_commands,off,,Customized Options,Restricts password-related commands to members of rds_password.,,postmaster,bool,default,,,,off,off,,,f
rds.superuser_variables,session_replication_role,,Customized Options,Variables rds_superusers may modify.,,superuser,string,configuration file,,,,,session_replication_role,/rdsdbdata/config/postgresql.conf,56,f
rds.syncrep_query_cancels,off,,Customized Options,Enables query cancellations while waiting for synchronous replication.,,sighup,bool,default,,,,off,off,,,f
rds.tablespace_path_prefix,/rdsdbdata/db/base/tablespace,,Customized Options,Location of tablespace directories.,,postmaster,string,default,,,,/rdsdbdata/db/base/tablespace,/rdsdbdata/db/base/tablespace,,,f
rds.wal_allocator_dir,/rdslocalstorage/prealloc,,Customized Options,Directory for preallocating WAL segments,,postmaster,string,default,,,,/rdslocalstorage/prealloc,/rdslocalstorage/prealloc,,,f
rds.wal_allocator_max_size,192,MB,Customized Options,Sets the maximum amount of WAL to pre-allocate,,sighup,integer,default,0,102400,,192,192,,,f
rds.walreceiver_send_archived_lsn_interval,5,s,Customized Options,Configures the interval to send archived lsn from replica to primary,,sighup,integer,default,1,30,,5,5,,,f
recovery_end_command,"",,Write-Ahead Log / Archive Recovery,Sets the shell command that will be executed once at the end of recovery.,,sighup,string,default,,,,"","",,,f
recovery_min_apply_delay,0,ms,Replication / Standby Servers,Sets the minimum delay for applying changes during recovery.,,sighup,integer,default,0,2147483647,,0,0,,,f
recovery_target,"",,Write-Ahead Log / Recovery Target,"Set to ""immediate"" to end recovery as soon as a consistent state is reached.",,postmaster,string,default,,,,"","",,,f
recovery_target_action,pause,,Write-Ahead Log / Recovery Target,Sets the action to perform upon reaching the recovery target.,,postmaster,enum,default,,,"{pause,promote,shutdown}",pause,pause,,,f
recovery_target_inclusive,on,,Write-Ahead Log / Recovery Target,Sets whether to include or exclude transaction with recovery target.,,postmaster,bool,default,,,,on,on,,,f
recovery_target_lsn,"",,Write-Ahead Log / Recovery Target,Sets the LSN of the write-ahead log location up to which recovery will proceed.,,postmaster,string,default,,,,"","",,,f
recovery_target_name,"",,Write-Ahead Log / Recovery Target,Sets the named restore point up to which recovery will proceed.,,postmaster,string,default,,,,"","",,,f
recovery_target_time,"",,Write-Ahead Log / Recovery Target,Sets the time stamp up to which recovery will proceed.,,postmaster,string,default,,,,"","",,,f
recovery_target_timeline,latest,,Write-Ahead Log / Recovery Target,Specifies the timeline to recover into.,,postmaster,string,default,,,,latest,latest,,,f
recovery_target_xid,"",,Write-Ahead Log / Recovery Target,Sets the transaction ID up to which recovery will proceed.,,postmaster,string,default,,,,"","",,,f
restart_after_crash,on,,Error Handling,Reinitialize server after backend crash.,,sighup,bool,default,,,,on,on,,,f
restore_command,"",,Write-Ahead Log / Archive Recovery,Sets the shell command that will be called to retrieve an archived WAL file.,,postmaster,string,default,,,,"","",,,f
row_security,on,,Client Connection Defaults / Statement Behavior,Enable row security.,"When enabled, row security will be applied to all users.",user,bool,default,,,,on,on,,,f
search_path,public,,Client Connection Defaults / Statement Behavior,Sets the schema search order for names that are not schema-qualified.,,user,string,session,,,,"""$user"", public","""$user"", public",,,f
segment_size,131072,8kB,Preset Options,Shows the number of pages per disk file.,,internal,integer,default,131072,131072,,131072,131072,,,f
seq_page_cost,1,,Query Tuning / Planner Cost Constants,Sets the planner's estimate of the cost of a sequentially fetched disk page.,,user,real,default,0,1.79769e+308,,1,1,,,f
server_encoding,UTF8,,Client Connection Defaults / Locale and Formatting,Sets the server (database) character set encoding.,,internal,string,override,,,,SQL_ASCII,UTF8,,,f
server_version,13.4,,Preset Options,Shows the server version.,,internal,string,default,,,,13.4,13.4,,,f
server_version_num,130004,,Preset Options,Shows the server version as an integer.,,internal,integer,default,130004,130004,,130004,130004,,,f
session_preload_libraries,"",,Client Connection Defaults / Shared Library Preloading,Lists shared libraries to preload into each backend.,,superuser,string,configuration file,,,,"","",/rdsdbdata/config/postgresql.conf,80,f
session_replication_role,origin,,Client Connection Defaults / Statement Behavior,Sets the session's behavior for triggers and rewrite rules.,,rds_superuser,enum,default,,,"{origin,replica,local}",origin,origin,,,f
shared_buffers,242040,8kB,Resource Usage / Memory,Sets the number of shared memory buffers used by the server.,,postmaster,integer,configuration file,16,1073741823,,1024,242040,/rdsdbdata/config/postgresql.conf,57,f
shared_memory_type,mmap,,Resource Usage / Memory,Selects the shared memory implementation used for the main shared memory region.,,postmaster,enum,default,,,"{sysv,mmap}",mmap,mmap,,,f
shared_preload_libraries,"rdsutils,pg_stat_statements",,Client Connection Defaults / Shared Library Preloading,Lists shared libraries to preload into server.,,postmaster,string,configuration file,,,,"","rdsutils,pg_stat_statements",/rdsdbdata/config/postgresql.conf,79,f
ssl,on,,Connections and Authentication / SSL,Enables SSL connections.,,sighup,bool,configuration file,,,,off,on,/rdsdbdata/config/postgresql.conf,58,f
ssl_ca_file,/rdsdbdata/rds-metadata/ca-cert.pem,,Connections and Authentication / SSL,Location of the SSL certificate authority file.,,sighup,string,configuration file,,,,"",/rdsdbdata/rds-metadata/ca-cert.pem,/rdsdbdata/config/postgresql.conf,59,f
ssl_cert_file,/rdsdbdata/rds-metadata/server-cert.pem,,Connections and Authentication / SSL,Location of the SSL server certificate file.,,sighup,string,configuration file,,,,server.crt,/rdsdbdata/rds-metadata/server-cert.pem,/rdsdbdata/config/postgresql.conf,60,f
ssl_ciphers,HIGH:!aNULL:!3DES,,Connections and Authentication / SSL,Sets the list of allowed SSL ciphers.,,sighup,string,default,,,,HIGH:!aNULL:!3DES,HIGH:!aNULL:!3DES,,,f
ssl_crl_file,"",,Connections and Authentication / SSL,Location of the SSL certificate revocation list file.,,sighup,string,default,,,,"","",,,f
ssl_dh_params_file,"",,Connections and Authentication / SSL,Location of the SSL DH parameters file.,,sighup,string,default,,,,"","",,,f
ssl_ecdh_curve,prime256v1,,Connections and Authentication / SSL,Sets the curve to use for ECDH.,,sighup,string,default,,,,prime256v1,prime256v1,,,f
ssl_key_file,/rdsdbdata/rds-metadata/server-key.pem,,Connections and Authentication / SSL,Location of the SSL server private key file.,,sighup,string,configuration file,,,,server.key,/rdsdbdata/rds-metadata/server-key.pem,/rdsdbdata/config/postgresql.conf,61,f
ssl_library,OpenSSL,,Preset Options,Name of the SSL library.,,internal,string,default,,,,OpenSSL,OpenSSL,,,f
ssl_max_protocol_version,"",,Connections and Authentication / SSL,Sets the maximum SSL/TLS protocol version to use.,,sighup,enum,default,,,"{"""",TLSv1,TLSv1.1,TLSv1.2,TLSv1.3}","","",,,f
ssl_min_protocol_version,TLSv1.2,,Connections and Authentication / SSL,Sets the minimum SSL/TLS protocol version to use.,,sighup,enum,configuration file,,,"{TLSv1,TLSv1.1,TLSv1.2,TLSv1.3}",TLSv1.2,TLSv1.2,/rdsdbdata/config/postgresql.conf,62,f
ssl_passphrase_command,"",,Connections and Authentication / SSL,Command to obtain passphrases for SSL.,,sighup,string,default,,,,"","",,,f
ssl_passphrase_command_supports_reload,off,,Connections and Authentication / SSL,Also use ssl_passphrase_command during server reload.,,sighup,bool,default,,,,off,off,,,f
ssl_prefer_server_ciphers,on,,Connections and Authentication / SSL,Give priority to server ciphersuite order.,,sighup,bool,default,,,,on,on,,,f
standard_conforming_strings,on,,Version and Platform Compatibility / Previous PostgreSQL Versions,Causes '...' strings to treat backslashes literally.,,user,bool,default,,,,on,on,,,f
statement_timeout,0,ms,Client Connection Defaults / Statement Behavior,Sets the maximum allowed duration of any statement.,A value of 0 turns off the timeout.,user,integer,default,0,2147483647,,0,0,,,f
stats_temp_directory,/rdsdbdata/db/pg_stat_tmp,,Statistics / Query and Index Statistics Collector,Writes temporary statistics files to the specified directory.,,sighup,string,configuration file,,,,pg_stat_tmp,/rdsdbdata/db/pg_stat_tmp,/rdsdbdata/config/postgresql.conf,81,f
superuser_reserved_connections,3,,Connections and Authentication / Connection Settings,Sets the number of connection slots reserved for superusers.,,postmaster,integer,configuration file,0,262143,,3,3,/rdsdbdata/config/postgresql.conf,63,f
synchronize_seqscans,on,,Version and Platform Compatibility / Previous PostgreSQL Versions,Enable synchronized sequential scans.,,user,bool,default,,,,on,on,,,f
synchronous_commit,on,,Write-Ahead Log / Settings,Sets the current transaction's synchronization level.,,user,enum,configuration file,,,"{local,remote_write,remote_apply,on,off}",on,on,/rdsdbdata/config/postgresql.conf,64,f
synchronous_standby_names,"",,Replication / Master Server,Number of synchronous standbys and list of names of potential synchronous ones.,,sighup,string,default,,,,"","",,,f
syslog_facility,local0,,Reporting and Logging / Where to Log,"Sets the syslog ""facility"" to be used when syslog enabled.",,sighup,enum,default,,,"{local0,local1,local2,local3,local4,local5,local6,local7}",local0,local0,,,f
syslog_ident,postgres,,Reporting and Logging / Where to Log,Sets the program name used to identify PostgreSQL messages in syslog.,,sighup,string,default,,,,postgres,postgres,,,f
syslog_sequence_numbers,on,,Reporting and Logging / Where to Log,Add sequence number to syslog messages to avoid duplicate suppression.,,sighup,bool,default,,,,on,on,,,f
syslog_split_messages,on,,Reporting and Logging / Where to Log,Split messages sent to syslog by lines and to fit into 1024 bytes.,,sighup,bool,default,,,,on,on,,,f
tcp_keepalives_count,2,,Client Connection Defaults / Other Defaults,Maximum number of TCP keepalive retransmits.,This controls the number of consecutive keepalive retransmits that can be lost before a connection is considered dead. A value of 0 uses the system default.,user,integer,default,0,2147483647,,0,0,,,f
tcp_keepalives_idle,300,s,Client Connection Defaults / Other Defaults,Time between issuing TCP keepalives.,A value of 0 uses the system default.,user,integer,default,0,2147483647,,0,0,,,f
tcp_keepalives_interval,30,s,Client Connection Defaults / Other Defaults,Time between TCP keepalive retransmits.,A value of 0 uses the system default.,user,integer,default,0,2147483647,,0,0,,,f
tcp_user_timeout,0,ms,Client Connection Defaults / Other Defaults,TCP user timeout.,A value of 0 uses the system default.,user,integer,default,0,2147483647,,0,0,,,f
temp_buffers,1024,8kB,Resource Usage / Memory,Sets the maximum number of temporary buffers used by each session.,,user,integer,default,100,1073741823,,1024,1024,,,f
temp_file_limit,-1,kB,Resource Usage / Disk,Limits the total size of all temporary files used by each process.,-1 means no limit.,rds_superuser,integer,default,-1,2147483647,,-1,-1,,,f
temp_tablespaces,"",,Client Connection Defaults / Statement Behavior,Sets the tablespace(s) to use for temporary tables and sort files.,,user,string,default,,,,"","",,,f
TimeZone,UTC,,Client Connection Defaults / Locale and Formatting,Sets the time zone for displaying and interpreting time stamps.,,user,string,configuration file,,,,GMT,UTC,/rdsdbdata/config/postgresql.conf,65,f
timezone_abbreviations,Default,,Client Connection Defaults / Locale and Formatting,Selects a file of time zone abbreviations.,,user,string,default,,,,,Default,,,f
trace_notify,off,,Developer Options,Generates debugging output for LISTEN and NOTIFY.,,user,bool,default,,,,off,off,,,f
trace_recovery_messages,log,,Developer Options,Enables logging of recovery-related debugging information.,"Each level includes all the levels that follow it. The later the level, the fewer messages are sent.",sighup,enum,default,,,"{debug5,debug4,debug3,debug2,debug1,log,notice,warning,error}",log,log,,,f
trace_sort,off,,Developer Options,Emit information about resource usage in sorting.,,user,bool,default,,,,off,off,,,f
track_activities,on,,Statistics / Query and Index Statistics Collector,Collects information about executing commands.,"Enables the collection of information on the currently executing command of each session, along with the time at which that command began execution.",rds_superuser,bool,default,,,,on,on,,,f
track_activity_query_size,4096,B,Resource Usage / Memory,"Sets the size reserved for pg_stat_activity.query, in bytes.",,postmaster,integer,configuration file,100,1048576,,1024,4096,/rdsdbdata/config/postgresql.conf,66,f
track_commit_timestamp,off,,Replication,Collects transaction commit time.,,postmaster,bool,default,,,,off,off,,,f
track_counts,on,,Statistics / Query and Index Statistics Collector,Collects statistics on database activity.,,rds_superuser,bool,default,,,,on,on,,,f
track_functions,pl,,Statistics / Query and Index Statistics Collector,Collects function-level statistics on database activity.,,rds_superuser,enum,configuration file,,,"{none,pl,all}",none,pl,/rdsdbdata/config/postgresql.conf,67,f
track_io_timing,on,,Statistics / Query and Index Statistics Collector,Collects timing statistics for database I/O activity.,,rds_superuser,bool,configuration file,,,,off,on,/rdsdbdata/config/postgresql.conf,68,f
transaction_deferrable,off,,Client Connection Defaults / Statement Behavior,Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.,,user,bool,override,,,,off,off,,,f
transaction_isolation,read committed,,Client Connection Defaults / Statement Behavior,Sets the current transaction's isolation level.,,user,enum,override,,,"{serializable,""repeatable read"",""read committed"",""read uncommitted""}",read committed,read committed,,,f
transaction_read_only,off,,Client Connection Defaults / Statement Behavior,Sets the current transaction's read-only status.,,user,bool,override,,,,off,off,,,f
transform_null_equals,off,,Version and Platform Compatibility / Other Platforms and Clients,"Treats ""expr=NULL"" as ""expr IS NULL"".","When turned on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct behavior of expr = NULL is to always return null (unknown).",user,bool,default,,,,off,off,,,f
unix_socket_directories,/tmp,,Connections and Authentication / Connection Settings,Sets the directories where Unix-domain sockets will be created.,,postmaster,string,configuration file,,,,/tmp,/tmp,/rdsdbdata/config/postgresql.conf,69,f
unix_socket_group,rdsdb,,Connections and Authentication / Connection Settings,Sets the owning group of the Unix-domain socket.,The owning user of the socket is always the user that starts the server.,postmaster,string,configuration file,,,,"",rdsdb,/rdsdbdata/config/postgresql.conf,70,f
unix_socket_permissions,0700,,Connections and Authentication / Connection Settings,Sets the access permissions of the Unix-domain socket.,Unix-domain sockets use the usual Unix file system permission set. The parameter value is expected to be a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).),postmaster,integer,configuration file,0,511,,511,448,/rdsdbdata/config/postgresql.conf,71,f
update_process_title,on,,Process Title,Updates the process title to show the active SQL command.,Enables updating of the process title every time a new SQL command is received by the server.,superuser,bool,default,,,,on,on,,,f
vacuum_cleanup_index_scale_factor,0.1,,Client Connection Defaults / Statement Behavior,Number of tuple inserts prior to index cleanup as a fraction of reltuples.,,user,real,default,0,1e+10,,0.1,0.1,,,f
vacuum_cost_delay,0,ms,Resource Usage / Cost-Based Vacuum Delay,Vacuum cost delay in milliseconds.,,user,real,default,0,100,,0,0,,,f
vacuum_cost_limit,200,,Resource Usage / Cost-Based Vacuum Delay,Vacuum cost amount available before napping.,,user,integer,default,1,10000,,200,200,,,f
vacuum_cost_page_dirty,20,,Resource Usage / Cost-Based Vacuum Delay,Vacuum cost for a page dirtied by vacuum.,,user,integer,default,0,10000,,20,20,,,f
vacuum_cost_page_hit,1,,Resource Usage / Cost-Based Vacuum Delay,Vacuum cost for a page found in the buffer cache.,,user,integer,default,0,10000,,1,1,,,f
vacuum_cost_page_miss,5,,Resource Usage / Cost-Based Vacuum Delay,Vacuum cost for a page not found in the buffer cache.,,user,integer,configuration file,0,10000,,10,5,/rdsdbdata/config/postgresql.conf,72,f
vacuum_defer_cleanup_age,0,,Replication / Master Server,"Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.",,sighup,integer,default,0,1000000,,0,0,,,f
vacuum_freeze_min_age,50000000,,Client Connection Defaults / Statement Behavior,Minimum age at which VACUUM should freeze a table row.,,user,integer,default,0,1000000000,,50000000,50000000,,,f
vacuum_freeze_table_age,150000000,,Client Connection Defaults / Statement Behavior,Age at which VACUUM should scan whole table to freeze tuples.,,user,integer,default,0,2000000000,,150000000,150000000,,,f
vacuum_multixact_freeze_min_age,5000000,,Client Connection Defaults / Statement Behavior,Minimum age at which VACUUM should freeze a MultiXactId in a table row.,,user,integer,default,0,1000000000,,5000000,5000000,,,f
vacuum_multixact_freeze_table_age,150000000,,Client Connection Defaults / Statement Behavior,Multixact age at which VACUUM should scan whole table to freeze tuples.,,user,integer,default,0,2000000000,,150000000,150000000,,,f
wal_block_size,8192,,Preset Options,Shows the block size in the write ahead log.,,internal,integer,default,8192,8192,,8192,8192,,,f
wal_buffers,7563,8kB,Write-Ahead Log / Settings,Sets the number of disk-page buffers in shared memory for WAL.,,postmaster,integer,override,-1,262143,,-1,7563,,,f
wal_compression,on,,Write-Ahead Log / Settings,Compresses full-page writes written in WAL file.,,superuser,bool,configuration file,,,,off,on,/rdsdbdata/config/postgresql.conf,73,f
wal_consistency_checking,"",,Developer Options,Sets the WAL resource managers for which WAL consistency checks are done.,Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay.,superuser,string,default,,,,"","",,,f
wal_init_zero,on,,Write-Ahead Log / Settings,Writes zeroes to new WAL files before first use.,,superuser,bool,default,,,,on,on,,,f
wal_keep_size,2048,MB,Replication / Sending Servers,Sets the size of WAL files held for standby servers.,,sighup,integer,configuration file,0,2147483647,,0,2048,/rdsdbdata/config/postgresql.conf,74,f
wal_level,replica,,Write-Ahead Log / Settings,Set the level of information written to the WAL.,,postmaster,enum,configuration file,,,"{minimal,replica,logical}",replica,replica,/rdsdbdata/config/postgresql.conf,84,f
wal_log_hints,off,,Write-Ahead Log / Settings,"Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification.",,postmaster,bool,default,,,,off,off,,,f
wal_receiver_create_temp_slot,off,,Replication / Standby Servers,Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.,,sighup,bool,configuration file,,,,off,off,/rdsdbdata/config/postgresql.conf,75,f
wal_receiver_status_interval,10,s,Replication / Standby Servers,Sets the maximum interval between WAL receiver status reports to the sending server.,,sighup,integer,default,0,2147483,,10,10,,,f
wal_receiver_timeout,30000,ms,Replication / Standby Servers,Sets the maximum wait time to receive data from the sending server.,,sighup,integer,configuration file,0,2147483647,,60000,30000,/rdsdbdata/config/postgresql.conf,76,f
wal_recycle,on,,Write-Ahead Log / Settings,Recycles WAL files by renaming them.,,superuser,bool,default,,,,on,on,,,f
wal_retrieve_retry_interval,5000,ms,Replication / Standby Servers,Sets the time to wait before retrying to retrieve WAL after a failed attempt.,,sighup,integer,default,1,2147483647,,5000,5000,,,f
wal_segment_size,67108864,B,Preset Options,Shows the size of write ahead log segments.,,internal,integer,override,1048576,1073741824,,16777216,67108864,,,f
wal_sender_timeout,30000,ms,Replication / Sending Servers,Sets the maximum time to wait for WAL replication.,,user,integer,configuration file,0,2147483647,,60000,30000,/rdsdbdata/config/postgresql.conf,77,f
wal_skip_threshold,2048,kB,Write-Ahead Log / Settings,Size of new file to fsync instead of writing WAL.,,user,integer,default,0,2147483647,,2048,2048,,,f
wal_sync_method,fdatasync,,Write-Ahead Log / Settings,Selects the method used for forcing WAL updates to disk.,,sighup,enum,default,,,"{fsync,fdatasync,open_sync,open_datasync}",fdatasync,fdatasync,,,f
wal_writer_delay,200,ms,Write-Ahead Log / Settings,Time between WAL flushes performed in the WAL writer.,,sighup,integer,default,1,10000,,200,200,,,f
wal_writer_flush_after,128,8kB,Write-Ahead Log / Settings,Amount of WAL written out by WAL writer that triggers a flush.,,sighup,integer,default,0,2147483647,,128,128,,,f
work_mem,4096,kB,Resource Usage / Memory,Sets the maximum memory to be used for query workspaces.,This much memory can be used by each internal sort operation and hash table before switching to temporary disk files.,user,integer,default,64,2147483647,,4096,4096,,,f
xmlbinary,base64,,Client Connection Defaults / Statement Behavior,Sets how binary values are to be encoded in XML.,,user,enum,default,,,"{base64,hex}",base64,base64,,,f
xmloption,content,,Client Connection Defaults / Statement Behavior,Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.,,user,enum,default,,,"{content,document}",content,content,,,f
zero_damaged_pages,off,,Developer Options,Continues processing past damaged page headers.,"Detection of a damaged page header normally causes PostgreSQL to report an error, aborting the current transaction. Setting zero_damaged_pages to true causes the system to instead report a warning, zero out the damaged page, and continue processing. This behavior will destroy data, namely all the rows on the damaged page.",superuser,bool,default,,,,off,off,,,f