102#define PG_KRB_SRVTAB ""
118 "array length mismatch");
126 {
"debug5",
DEBUG5,
false},
127 {
"debug4",
DEBUG4,
false},
128 {
"debug3",
DEBUG3,
false},
129 {
"debug2",
DEBUG2,
false},
130 {
"debug1",
DEBUG1,
false},
133 {
"info",
INFO,
true},
134 {
"notice",
NOTICE,
false},
136 {
"error",
ERROR,
false},
141 {
"debug5",
DEBUG5,
false},
142 {
"debug4",
DEBUG4,
false},
143 {
"debug3",
DEBUG3,
false},
144 {
"debug2",
DEBUG2,
false},
145 {
"debug1",
DEBUG1,
false},
147 {
"info",
INFO,
false},
148 {
"notice",
NOTICE,
false},
150 {
"error",
ERROR,
false},
152 {
"fatal",
FATAL,
false},
153 {
"panic",
PANIC,
false},
166 {
"disabled", -1,
false},
167 {
"debug5",
DEBUG5,
false},
168 {
"debug4",
DEBUG4,
false},
169 {
"debug3",
DEBUG3,
false},
170 {
"debug2",
DEBUG2,
false},
171 {
"debug1",
DEBUG1,
false},
174 {
"info",
INFO,
true},
175 {
"notice",
NOTICE,
false},
177 {
"error",
ERROR,
false},
182 "array length mismatch");
192 "array length mismatch");
203 "array length mismatch");
221 "array length mismatch");
225 {
"local0", LOG_LOCAL0,
false},
226 {
"local1", LOG_LOCAL1,
false},
227 {
"local2", LOG_LOCAL2,
false},
228 {
"local3", LOG_LOCAL3,
false},
229 {
"local4", LOG_LOCAL4,
false},
230 {
"local5", LOG_LOCAL5,
false},
231 {
"local6", LOG_LOCAL6,
false},
232 {
"local7", LOG_LOCAL7,
false},
247 "array length mismatch");
257 "array length mismatch");
266 "array length mismatch");
275 "array length mismatch");
427 "array length mismatch");
496#ifdef DEBUG_NODE_TESTS_ENABLED
497bool Debug_copy_parse_plan_trees;
498bool Debug_write_read_parse_plan_trees;
499bool Debug_raw_expression_coverage_test;
582#define DEFAULT_SYSLOG_FACILITY LOG_LOCAL0
584#define DEFAULT_SYSLOG_FACILITY 0
605#ifdef USE_ASSERT_CHECKING
606#define DEFAULT_ASSERT_ENABLED true
608#define DEFAULT_ASSERT_ENABLED false
642 "array length mismatch");
668 "array length mismatch");
723 "array length mismatch");
740 "array length mismatch");
774 gettext_noop(
"Enables the planner's use of sequential-scan plans."),
784 gettext_noop(
"Enables the planner's use of index-scan plans."),
794 gettext_noop(
"Enables the planner's use of index-only-scan plans."),
804 gettext_noop(
"Enables the planner's use of bitmap-scan plans."),
814 gettext_noop(
"Enables the planner's use of TID scan plans."),
824 gettext_noop(
"Enables the planner's use of explicit sort steps."),
834 gettext_noop(
"Enables the planner's use of incremental sort steps."),
844 gettext_noop(
"Enables the planner's use of hashed aggregation plans."),
854 gettext_noop(
"Enables the planner's use of materialization."),
864 gettext_noop(
"Enables the planner's use of memoization."),
874 gettext_noop(
"Enables the planner's use of nested-loop join plans."),
884 gettext_noop(
"Enables the planner's use of merge join plans."),
894 gettext_noop(
"Enables the planner's use of hash join plans."),
904 gettext_noop(
"Enables the planner's use of gather merge plans."),
924 gettext_noop(
"Enables partitionwise aggregation and grouping."),
934 gettext_noop(
"Enables the planner's use of parallel append plans."),
944 gettext_noop(
"Enables the planner's use of parallel hash plans."),
954 gettext_noop(
"Enables plan-time and execution-time partition pruning."),
955 gettext_noop(
"Allows the query planner and executor to compare partition "
956 "bounds to conditions in the query to determine which "
957 "partitions must be scanned."),
966 gettext_noop(
"Enables the planner's ability to produce plans that "
967 "provide presorted input for ORDER BY / DISTINCT aggregate "
969 gettext_noop(
"Allows the query planner to build plans that provide "
970 "presorted input for aggregate functions with an ORDER BY / "
971 "DISTINCT clause. When disabled, implicit sorts are always "
972 "performed during execution."),
981 gettext_noop(
"Enables the planner's use of async append plans."),
1001 gettext_noop(
"Enables reordering of DISTINCT pathkeys."),
1012 gettext_noop(
"This algorithm attempts to do planning without "
1013 "exhaustive searching."),
1026 gettext_noop(
"Shows whether the current user is a superuser."),
1041 gettext_noop(
"Allows running the ALTER SYSTEM command."),
1042 gettext_noop(
"Can be set to off for environments where global configuration "
1043 "changes should be made using a different method."),
1052 gettext_noop(
"Enables advertising the server via Bonjour."),
1079 gettext_noop(
"Controls whether \"ssl_passphrase_command\" is called during server reload."),
1088 gettext_noop(
"Give priority to server ciphersuite order."),
1097 gettext_noop(
"Forces synchronization of updates to disk."),
1098 gettext_noop(
"The server will use the fsync() system call in several places to make "
1099 "sure that updates are physically written to disk. This ensures "
1100 "that a database cluster will recover to a consistent state after "
1101 "an operating system or hardware crash.")
1109 gettext_noop(
"Continues processing after a checksum failure."),
1110 gettext_noop(
"Detection of a checksum failure normally causes PostgreSQL to "
1111 "report an error, aborting the current transaction. Setting "
1112 "ignore_checksum_failure to true causes the system to ignore the failure "
1113 "(but still report a warning), and continue processing. This "
1114 "behavior could cause crashes or other serious problems. Only "
1115 "has an effect if checksums are enabled."),
1124 gettext_noop(
"Continues processing past damaged page headers."),
1125 gettext_noop(
"Detection of a damaged page header normally causes PostgreSQL to "
1126 "report an error, aborting the current transaction. Setting "
1127 "\"zero_damaged_pages\" to true causes the system to instead report a "
1128 "warning, zero out the damaged page, and continue processing. This "
1129 "behavior will destroy data, namely all the rows on the damaged page."),
1138 gettext_noop(
"Continues recovery after an invalid pages failure."),
1139 gettext_noop(
"Detection of WAL records having references to "
1140 "invalid pages during recovery causes PostgreSQL to "
1141 "raise a PANIC-level error, aborting the recovery. "
1142 "Setting \"ignore_invalid_pages\" to true causes "
1143 "the system to ignore invalid page references "
1144 "in WAL records (but still report a warning), "
1145 "and continue recovery. This behavior may cause "
1146 "crashes, data loss, propagate or hide corruption, "
1147 "or other serious problems. Only has an effect "
1148 "during recovery or in standby mode."),
1157 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint."),
1158 gettext_noop(
"A page write in process during an operating system crash might be "
1159 "only partially written to disk. During recovery, the row changes "
1160 "stored in WAL are not enough to recover. This option writes "
1161 "pages when first modified after a checkpoint to WAL so full recovery "
1171 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification."),
1181 gettext_noop(
"Writes zeroes to new WAL files before first use."),
1219 gettext_noop(
"Logs details of pre-authentication connection handshake."),
1229 gettext_noop(
"Logs end of a session, including duration."),
1247 gettext_noop(
"Shows whether the running server has assertion checks enabled."),
1267 gettext_noop(
"Reinitialize server after backend crash."),
1276 gettext_noop(
"Remove temporary files after backend crash."),
1286 gettext_noop(
"Send SIGABRT not SIGQUIT to child processes after backend crash."),
1296 gettext_noop(
"Send SIGABRT not SIGKILL to stuck child processes."),
1307 gettext_noop(
"Logs the duration of each completed SQL statement."),
1314#ifdef DEBUG_NODE_TESTS_ENABLED
1317 gettext_noop(
"Set this to force all parse and plan trees to be passed through "
1318 "copyObject(), to facilitate catching errors and omissions in "
1323 &Debug_copy_parse_plan_trees,
1325#ifdef COPY_PARSE_PLAN_TREES
1334 gettext_noop(
"Set this to force all parse and plan trees to be passed through "
1335 "outfuncs.c/readfuncs.c, to facilitate catching errors and omissions in "
1340 &Debug_write_read_parse_plan_trees,
1342#ifdef WRITE_READ_PARSE_PLAN_TREES
1351 gettext_noop(
"Set this to force all raw parse trees for DML statements to be scanned "
1352 "by raw_expression_tree_walker(), to facilitate catching errors and "
1353 "omissions in that function."),
1357 &Debug_raw_expression_coverage_test,
1359#ifdef RAW_EXPRESSION_COVERAGE_TEST
1378 gettext_noop(
"Logs each query's rewritten parse tree."),
1405 gettext_noop(
"Writes parser performance statistics to the server log."),
1414 gettext_noop(
"Writes planner performance statistics to the server log."),
1423 gettext_noop(
"Writes executor performance statistics to the server log."),
1432 gettext_noop(
"Writes cumulative performance statistics to the server log."),
1439#ifdef BTREE_BUILD_STATS
1442 gettext_noop(
"Logs system resource usage statistics (memory and CPU) on various B-tree operations."),
1454 gettext_noop(
"Collects information about executing commands."),
1455 gettext_noop(
"Enables the collection of information on the currently "
1456 "executing command of each session, along with "
1457 "the time at which that command began execution.")
1465 gettext_noop(
"Collects statistics on database activity."),
1474 gettext_noop(
"Collects timing statistics for database I/O activity."),
1483 gettext_noop(
"Collects timing statistics for WAL I/O activity."),
1493 gettext_noop(
"Updates the process title to show the active SQL command."),
1494 gettext_noop(
"Enables updating of the process title every time a new SQL command is received by the server.")
1513 gettext_noop(
"Generates debugging output for LISTEN and NOTIFY."),
1535 gettext_noop(
"Emits information about user lock usage."),
1545 gettext_noop(
"Emits information about lightweight lock usage."),
1555 gettext_noop(
"Dumps information about all current locks when a deadlock timeout occurs."),
1585 gettext_noop(
"Logs the host name in the connection logs."),
1586 gettext_noop(
"By default, connection logs only show the IP address "
1587 "of the connecting host. If you want them to show the host name you "
1588 "can turn this on, but depending on your host name resolution "
1589 "setup it might impose a non-negligible performance penalty.")
1597 gettext_noop(
"Treats \"expr=NULL\" as \"expr IS NULL\"."),
1598 gettext_noop(
"When turned on, expressions of the form expr = NULL "
1599 "(or NULL = expr) are treated as expr IS NULL, that is, they "
1600 "return true if expr evaluates to the null value, and false "
1601 "otherwise. The correct behavior of expr = NULL is to always "
1602 "return null (unknown).")
1610 gettext_noop(
"Sets the default read-only status of new transactions."),
1620 gettext_noop(
"Sets the current transaction's read-only status."),
1630 gettext_noop(
"Sets the default deferrable status of new transactions."),
1639 gettext_noop(
"Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures."),
1650 gettext_noop(
"When enabled, row security will be applied to all users.")
1658 gettext_noop(
"Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE."),
1667 gettext_noop(
"Enable input of NULL elements in arrays."),
1668 gettext_noop(
"When turned on, unquoted NULL in an array input "
1669 "value means a null value; "
1670 "otherwise it is taken literally.")
1684 gettext_noop(
"WITH OIDS is no longer supported; this can only be false."),
1694 gettext_noop(
"Start a subprocess to capture stderr output and/or csvlogs into log files."),
1703 gettext_noop(
"Truncate existing log files of same name during log rotation."),
1713 gettext_noop(
"Emit information about resource usage in sorting."),
1722#ifdef TRACE_SYNCSCAN
1726 gettext_noop(
"Generate debugging output for synchronized scanning."),
1736#ifdef DEBUG_BOUNDED_SORT
1741 gettext_noop(
"Enable bounded sorting using heap sort."),
1745 &optimize_bounded_sort,
1766 gettext_noop(
"Shows whether datetimes are integer based."),
1777 gettext_noop(
"Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive."),
1787 gettext_noop(
"Sets whether GSSAPI delegation should be accepted from the client."),
1797 gettext_noop(
"Warn about backslash escapes in ordinary string literals."),
1807 gettext_noop(
"Causes '...' strings to treat backslashes literally."),
1828 gettext_noop(
"Sets whether to include or exclude transaction with recovery target."),
1838 gettext_noop(
"Starts the WAL summarizer process to enable incremental backup."),
1848 gettext_noop(
"Allows connections and queries during recovery."),
1858 gettext_noop(
"Allows feedback from a hot standby to the primary that will avoid query conflicts."),
1868 gettext_noop(
"Shows whether hot standby is currently active."),
1879 gettext_noop(
"Allows modifications of the structure of system tables."),
1891 gettext_noop(
"It does not prevent updating the indexes, so it is safe "
1892 "to use. The worst consequence is slowness."),
1902 gettext_noop(
"Allows tablespaces directly inside pg_tblspc, for testing."),
1913 gettext_noop(
"Enables backward compatibility mode for privilege checks on large objects."),
1914 gettext_noop(
"Skips privilege checks when reading or modifying large objects, "
1915 "for compatibility with PostgreSQL releases prior to 9.0.")
1924 gettext_noop(
"When generating SQL fragments, quote all identifiers."),
1934 gettext_noop(
"Shows whether data checksums are turned on for this cluster."),
1945 gettext_noop(
"Add sequence number to syslog messages to avoid duplicate suppression."),
1955 gettext_noop(
"Split messages sent to syslog by lines and to fit into 1024 bytes."),
1965 gettext_noop(
"Controls whether Gather and Gather Merge also run subplans."),
1966 gettext_noop(
"Should gather nodes also run subplans or just gather tuples?"),
1987 gettext_noop(
"Register JIT-compiled functions with debugger."),
2004 gettext_noop(
"Write out LLVM bitcode to facilitate JIT debugging."),
2026 gettext_noop(
"Register JIT-compiled functions with perf profiler."),
2043 gettext_noop(
"Allow JIT compilation of tuple deforming."),
2054 gettext_noop(
"Whether to continue running after a failure to sync data files."),
2063 gettext_noop(
"Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured."),
2073 gettext_noop(
"When enabled, event triggers will fire for all applicable statements."),
2082 gettext_noop(
"Enables a physical standby to synchronize logical failover replication slots from the primary server."),
2091 gettext_noop(
"Enables deprecation warnings for MD5 passwords."),
2100 {NULL, 0, 0, NULL, NULL}, NULL,
false, NULL, NULL, NULL
2109 gettext_noop(
"Sets the amount of time to wait before forcing a "
2110 "switch to the next WAL file."),
2121 "authentication on connection startup."),
2122 gettext_noop(
"This allows attaching a debugger to the process."),
2126 0, 0, INT_MAX / 1000000,
2132 gettext_noop(
"This applies to table columns that have not had a "
2133 "column-specific target set via ALTER TABLE SET STATISTICS.")
2141 gettext_noop(
"Sets the FROM-list size beyond which subqueries "
2142 "are not collapsed."),
2143 gettext_noop(
"The planner will merge subqueries into upper "
2144 "queries if the resulting FROM list would have no more than "
2145 "this many items."),
2154 gettext_noop(
"Sets the FROM-list size beyond which JOIN "
2155 "constructs are not flattened."),
2157 "constructs into lists of FROM items whenever a "
2158 "list of no more than this many items would result."),
2167 gettext_noop(
"Sets the threshold of FROM items beyond which GEQO is used."),
2177 gettext_noop(
"GEQO: effort is used to set the default for other GEQO parameters."),
2187 gettext_noop(
"GEQO: number of individuals in the population."),
2188 gettext_noop(
"Zero selects a suitable default value."),
2197 gettext_noop(
"GEQO: number of iterations of the algorithm."),
2198 gettext_noop(
"Zero selects a suitable default value."),
2209 gettext_noop(
"Sets the time to wait on a lock before checking for deadlock."),
2220 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data."),
2225 30 * 1000, -1, INT_MAX,
2231 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data."),
2236 30 * 1000, -1, INT_MAX,
2242 gettext_noop(
"Sets the minimum delay for applying changes during recovery."),
2253 gettext_noop(
"Sets the maximum interval between WAL receiver status reports to the sending server."),
2258 10, 0, INT_MAX / 1000,
2264 gettext_noop(
"Sets the maximum wait time to receive data from the sending server."),
2269 60 * 1000, 0, INT_MAX,
2275 gettext_noop(
"Sets the maximum number of concurrent connections."),
2286 gettext_noop(
"Sets the number of connection slots reserved for superusers."),
2296 gettext_noop(
"Sets the number of connection slots reserved for roles "
2297 "with privileges of pg_use_reserved_connections."),
2307 gettext_noop(
"Amount of dynamic shared memory reserved at startup."),
2312 0, 0, (int)
Min((
size_t) INT_MAX, SIZE_MAX / (1024 * 1024)),
2322 gettext_noop(
"Sets the number of shared memory buffers used by the server."),
2327 16384, 16, INT_MAX / 2,
2333 gettext_noop(
"Sets the buffer pool size for VACUUM, ANALYZE, and autovacuum."),
2344 gettext_noop(
"Shows the size of the server's main shared memory area (rounded up to the nearest MB)."),
2355 gettext_noop(
"Shows the number of huge pages needed for the main shared memory area."),
2356 gettext_noop(
"-1 indicates that the value could not be determined."),
2366 gettext_noop(
"Shows the number of semaphores required for the server."),
2377 gettext_noop(
"Sets the size of the dedicated buffer pool used for the commit timestamp cache."),
2378 gettext_noop(
"Specify 0 to have this value determined as a fraction of \"shared_buffers\"."),
2388 gettext_noop(
"Sets the size of the dedicated buffer pool used for the MultiXact member cache."),
2399 gettext_noop(
"Sets the size of the dedicated buffer pool used for the MultiXact offset cache."),
2410 gettext_noop(
"Sets the size of the dedicated buffer pool used for the LISTEN/NOTIFY message cache."),
2421 gettext_noop(
"Sets the size of the dedicated buffer pool used for the serializable transaction cache."),
2432 gettext_noop(
"Sets the size of the dedicated buffer pool used for the subtransaction cache."),
2433 gettext_noop(
"Specify 0 to have this value determined as a fraction of \"shared_buffers\"."),
2443 gettext_noop(
"Sets the size of the dedicated buffer pool used for the transaction status cache."),
2444 gettext_noop(
"Specify 0 to have this value determined as a fraction of \"shared_buffers\"."),
2454 gettext_noop(
"Sets the maximum number of temporary buffers used by each session."),
2459 1024, 100, INT_MAX / 2,
2465 gettext_noop(
"Sets the TCP port the server listens on."),
2469 DEF_PGPORT, 1, 65535,
2475 gettext_noop(
"Sets the access permissions of the Unix-domain socket."),
2476 gettext_noop(
"Unix-domain sockets use the usual Unix file system "
2477 "permission set. The parameter value is expected "
2478 "to be a numeric mode specification in the form "
2479 "accepted by the chmod and umask system calls. "
2480 "(To use the customary octal format the number must "
2481 "start with a 0 (zero).)")
2490 gettext_noop(
"Sets the file permissions for log files."),
2492 "to be a numeric mode specification in the form "
2493 "accepted by the chmod and umask system calls. "
2494 "(To use the customary octal format the number must "
2495 "start with a 0 (zero).)")
2506 gettext_noop(
"The parameter value is a numeric mode specification "
2507 "in the form accepted by the chmod and umask system "
2508 "calls. (To use the customary octal format the number "
2509 "must start with a 0 (zero).)"),
2519 gettext_noop(
"Sets the maximum memory to be used for query workspaces."),
2520 gettext_noop(
"This much memory can be used by each internal "
2521 "sort operation and hash table before switching to "
2522 "temporary disk files."),
2537 gettext_noop(
"Sets the maximum memory to be used for maintenance operations."),
2538 gettext_noop(
"This includes operations such as VACUUM and CREATE INDEX."),
2548 gettext_noop(
"Sets the maximum memory to be used for logical decoding."),
2549 gettext_noop(
"This much memory can be used by each internal "
2550 "reorder buffer before spilling to disk."),
2565 gettext_noop(
"Sets the maximum stack depth, in kilobytes."),
2576 gettext_noop(
"Limits the total size of all temporary files used by each process."),
2587 gettext_noop(
"Vacuum cost for a page found in the buffer cache."),
2597 gettext_noop(
"Vacuum cost for a page not found in the buffer cache."),
2607 gettext_noop(
"Vacuum cost for a page dirtied by vacuum."),
2617 gettext_noop(
"Vacuum cost amount available before napping."),
2627 gettext_noop(
"Vacuum cost amount available before napping, for autovacuum."),
2637 gettext_noop(
"Sets the maximum number of simultaneously open files for each server process."),
2650 gettext_noop(
"Sets the maximum number of simultaneously prepared transactions."),
2661 gettext_noop(
"Sets the minimum OID of tables for tracking locks."),
2662 gettext_noop(
"Is used to avoid output on system tables."),
2671 gettext_noop(
"Sets the OID of the table with unconditionally lock tracing."),
2683 gettext_noop(
"Sets the maximum allowed duration of any statement."),
2694 gettext_noop(
"Sets the maximum allowed duration of any wait for a lock."),
2705 gettext_noop(
"Sets the maximum allowed idle time between queries, when in a transaction."),
2716 gettext_noop(
"Sets the maximum allowed duration of any transaction within a session (not a prepared transaction)."),
2727 gettext_noop(
"Sets the maximum allowed idle time between queries, when not in a transaction."),
2738 gettext_noop(
"Minimum age at which VACUUM should freeze a table row."),
2742 50000000, 0, 1000000000,
2748 gettext_noop(
"Age at which VACUUM should scan whole table to freeze tuples."),
2752 150000000, 0, 2000000000,
2758 gettext_noop(
"Minimum age at which VACUUM should freeze a MultiXactId in a table row."),
2762 5000000, 0, 1000000000,
2768 gettext_noop(
"Multixact age at which VACUUM should scan whole table to freeze tuples."),
2772 150000000, 0, 2000000000,
2778 gettext_noop(
"Age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2782 1600000000, 0, 2100000000,
2787 gettext_noop(
"Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2791 1600000000, 0, 2100000000,
2800 gettext_noop(
"Sets the maximum number of locks per transaction."),
2801 gettext_noop(
"The shared lock table is sized on the assumption that at most "
2802 "\"max_locks_per_transaction\" objects per server process or prepared "
2803 "transaction will need to be locked at any one time.")
2812 gettext_noop(
"Sets the maximum number of predicate locks per transaction."),
2813 gettext_noop(
"The shared predicate lock table is sized on the assumption that "
2814 "at most \"max_pred_locks_per_transaction\" objects per server process "
2815 "or prepared transaction will need to be locked at any one time.")
2824 gettext_noop(
"Sets the maximum number of predicate-locked pages and tuples per relation."),
2825 gettext_noop(
"If more than this total of pages and tuples in the same relation are locked "
2826 "by a connection, those locks are replaced by a relation-level lock.")
2829 -2, INT_MIN, INT_MAX,
2835 gettext_noop(
"Sets the maximum number of predicate-locked tuples per page."),
2836 gettext_noop(
"If more than this number of tuples on the same page are locked "
2837 "by a connection, those locks are replaced by a page-level lock.")
2846 gettext_noop(
"Sets the maximum allowed time to complete client authentication."),
2859 "authentication on connection startup."),
2860 gettext_noop(
"This allows attaching a debugger to the process."),
2870 gettext_noop(
"Sets the maximum number of allocated pages for NOTIFY / LISTEN queue."),
2874 1048576, 64, INT_MAX,
2880 gettext_noop(
"Buffer size for reading ahead in the WAL during recovery."),
2881 gettext_noop(
"Maximum distance to read ahead in the WAL to prefetch referenced data blocks."),
2891 gettext_noop(
"Sets the size of WAL files held for standby servers."),
2902 gettext_noop(
"Sets the minimum size to shrink the WAL to."),
2914 gettext_noop(
"Sets the WAL size that triggers a checkpoint."),
2926 gettext_noop(
"Sets the maximum time between automatic WAL checkpoints."),
2937 gettext_noop(
"Sets the maximum time before warning if checkpoints "
2938 "triggered by WAL volume happen too frequently."),
2939 gettext_noop(
"Write a message to the server log if checkpoints "
2940 "caused by the filling of WAL segment files happen more "
2941 "frequently than this amount of time. "
2942 "Zero turns off the warning."),
2952 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
2963 gettext_noop(
"Sets the number of disk-page buffers in shared memory for WAL."),
2964 gettext_noop(
"Specify -1 to have this value determined as a fraction of \"shared_buffers\"."),
2968 -1, -1, (INT_MAX / XLOG_BLCKSZ),
2974 gettext_noop(
"Time between WAL flushes performed in the WAL writer."),
2985 gettext_noop(
"Amount of WAL written out by WAL writer that triggers a flush."),
2996 gettext_noop(
"Minimum size of new file to fsync instead of writing WAL."),
3007 gettext_noop(
"Sets the maximum number of simultaneously running WAL sender processes."),
3018 gettext_noop(
"Sets the maximum number of simultaneously defined replication slots."),
3028 gettext_noop(
"Sets the maximum WAL size that can be reserved by replication slots."),
3029 gettext_noop(
"Replication slots will be marked as failed, and segments released "
3030 "for deletion or recycling, if this much space is occupied by WAL "
3041 gettext_noop(
"Sets the maximum time to wait for WAL replication."),
3046 60 * 1000, 0, INT_MAX,
3052 gettext_noop(
"Sets the delay in microseconds between transaction commit and "
3053 "flushing WAL to disk."),
3064 gettext_noop(
"Sets the minimum number of concurrent open transactions "
3065 "required before performing \"commit_delay\"."),
3075 gettext_noop(
"Sets the number of digits displayed for floating-point values."),
3076 gettext_noop(
"This affects real, double precision, and geometric data types. "
3077 "A zero or negative parameter value is added to the standard "
3078 "number of digits (FLT_DIG or DBL_DIG as appropriate). "
3079 "Any value greater than zero selects precise output mode.")
3088 gettext_noop(
"Sets the minimum execution time above which "
3089 "a sample of statements will be logged."
3090 " Sampling is determined by \"log_statement_sample_rate\"."),
3091 gettext_noop(
"Zero logs a sample of all queries. -1 turns this feature off."),
3101 gettext_noop(
"Sets the minimum execution time above which "
3102 "all statements will be logged."),
3103 gettext_noop(
"Zero prints all queries. -1 turns this feature off."),
3113 gettext_noop(
"Sets the minimum execution time above which "
3114 "autovacuum actions will be logged."),
3115 gettext_noop(
"Zero prints all actions. -1 turns autovacuum logging off."),
3119 600000, -1, INT_MAX,
3125 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3126 "parameter values when logging statements."),
3131 -1, -1, INT_MAX / 2,
3137 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3138 "parameter values when logging statements, on error."),
3149 gettext_noop(
"Background writer sleep time between rounds."),
3160 gettext_noop(
"Background writer maximum number of LRU pages to flush per round."),
3164 100, 0, INT_MAX / 2,
3170 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3180 {
"effective_io_concurrency",
3183 gettext_noop(
"Number of simultaneous requests that can be handled efficiently by the disk subsystem."),
3194 {
"maintenance_io_concurrency",
3197 gettext_noop(
"A variant of \"effective_io_concurrency\" that is used for maintenance work."),
3209 {
"io_combine_limit",
3212 gettext_noop(
"Limit on the size of data reads and writes."),
3224 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3234 {
"max_worker_processes",
3237 gettext_noop(
"Maximum number of concurrent worker processes."),
3246 {
"max_logical_replication_workers",
3249 gettext_noop(
"Maximum number of logical replication worker processes."),
3258 {
"max_sync_workers_per_subscription",
3261 gettext_noop(
"Maximum number of table synchronization workers per subscription."),
3270 {
"max_parallel_apply_workers_per_subscription",
3273 gettext_noop(
"Maximum number of parallel apply workers per subscription."),
3283 gettext_noop(
"Sets the amount of time to wait before forcing "
3284 "log file rotation."),
3295 gettext_noop(
"Sets the maximum size a log file can reach before "
3301 10 * 1024, 0, INT_MAX / 1024,
3307 gettext_noop(
"Shows the maximum number of function arguments."),
3318 gettext_noop(
"Shows the maximum number of index keys."),
3345 BLCKSZ, BLCKSZ, BLCKSZ,
3351 gettext_noop(
"Shows the number of pages per disk file."),
3356 RELSEG_SIZE, RELSEG_SIZE, RELSEG_SIZE,
3362 gettext_noop(
"Shows the block size in the write ahead log."),
3367 XLOG_BLCKSZ, XLOG_BLCKSZ, XLOG_BLCKSZ,
3373 gettext_noop(
"Sets the time to wait before retrying to retrieve WAL "
3374 "after a failed attempt."),
3385 gettext_noop(
"Shows the size of write ahead log segments."),
3398 gettext_noop(
"Time for which WAL summary files should be kept."),
3411 gettext_noop(
"Time to sleep between autovacuum runs."),
3416 60, 1, INT_MAX / 1000,
3421 gettext_noop(
"Minimum number of tuple updates or deletes prior to vacuum."),
3430 gettext_noop(
"Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums."),
3439 gettext_noop(
"Minimum number of tuple inserts, updates, or deletes prior to analyze."),
3449 gettext_noop(
"Age at which to autovacuum a table to prevent transaction ID wraparound."),
3455 200000000, 100000, 2000000000,
3461 gettext_noop(
"Multixact age at which to autovacuum a table to prevent multixact wraparound."),
3465 400000000, 10000, 2000000000,
3471 gettext_noop(
"Sets the maximum number of simultaneously running autovacuum worker processes."),
3481 gettext_noop(
"Sets the maximum number of parallel processes per maintenance operation."),
3491 gettext_noop(
"Sets the maximum number of parallel processes per executor node."),
3502 gettext_noop(
"Sets the maximum number of parallel workers that can be active at one time."),
3513 gettext_noop(
"Sets the maximum memory to be used by each autovacuum worker process."),
3535 gettext_noop(
"Time between TCP keepalive retransmits."),
3546 gettext_noop(
"SSL renegotiation is no longer supported; this can only be 0."),
3557 gettext_noop(
"Maximum number of TCP keepalive retransmits."),
3558 gettext_noop(
"Number of consecutive keepalive retransmits that can be "
3559 "lost before a connection is considered dead. A value of 0 uses the "
3569 gettext_noop(
"Sets the maximum allowed result for exact search by GIN."),
3580 gettext_noop(
"Sets the planner's assumption about the total size of the data caches."),
3581 gettext_noop(
"That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. "
3582 "This is measured in disk pages, which are normally 8 kB each."),
3592 gettext_noop(
"Sets the minimum amount of table data for a parallel scan."),
3593 gettext_noop(
"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."),
3597 (8 * 1024 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3603 gettext_noop(
"Sets the minimum amount of index data for a parallel scan."),
3604 gettext_noop(
"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."),
3608 (512 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3615 gettext_noop(
"Shows the server version as an integer."),
3620 PG_VERSION_NUM, PG_VERSION_NUM, PG_VERSION_NUM,
3626 gettext_noop(
"Log the use of temporary files larger than this number of kilobytes."),
3627 gettext_noop(
"Zero logs all files. The default is -1 (turning this feature off)."),
3637 gettext_noop(
"Sets the size reserved for pg_stat_activity.query, in bytes."),
3648 gettext_noop(
"Sets the maximum size of the pending list for GIN index."),
3670 gettext_noop(
"The size of huge page that should be requested."),
3681 gettext_noop(
"Aggressively flush system caches for debugging purposes."),
3686#ifdef DISCARD_CACHES_ENABLED
3688#if defined(CLOBBER_CACHE_RECURSIVELY)
3690#elif defined(CLOBBER_CACHE_ALWAYS)
3704 gettext_noop(
"Sets the time interval between checks for disconnection while running queries."),
3716 "long-running startup operations."),
3727 gettext_noop(
"Sets the iteration count for SCRAM secret generation."),
3738 {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL, NULL
3747 gettext_noop(
"Sets the planner's estimate of the cost of a "
3748 "sequentially fetched disk page."),
3758 gettext_noop(
"Sets the planner's estimate of the cost of a "
3759 "nonsequentially fetched disk page."),
3769 gettext_noop(
"Sets the planner's estimate of the cost of "
3770 "processing each tuple (row)."),
3780 gettext_noop(
"Sets the planner's estimate of the cost of "
3781 "processing each index entry during an index scan."),
3791 gettext_noop(
"Sets the planner's estimate of the cost of "
3792 "processing each operator or function call."),
3802 gettext_noop(
"Sets the planner's estimate of the cost of "
3803 "passing each tuple (row) from worker to leader backend."),
3813 gettext_noop(
"Sets the planner's estimate of the cost of "
3814 "starting up worker processes for parallel query."),
3825 gettext_noop(
"Perform JIT compilation if query is more expensive."),
3830 100000, -1, DBL_MAX,
3836 gettext_noop(
"Optimize JIT-compiled functions if query is more expensive."),
3841 500000, -1, DBL_MAX,
3847 gettext_noop(
"Perform JIT inlining if query is more expensive."),
3852 500000, -1, DBL_MAX,
3858 gettext_noop(
"Sets the planner's estimate of the fraction of "
3859 "a cursor's rows that will be retrieved."),
3870 gettext_noop(
"Sets the planner's estimate of the average size "
3871 "of a recursive query's working table."),
3882 gettext_noop(
"GEQO: selective pressure within the population."),
3904 gettext_noop(
"Multiple of \"work_mem\" to use for hash tables."),
3915 gettext_noop(
"Multiple of the average buffer usage to free per round."),
3925 gettext_noop(
"Sets the seed for random-number generation."),
3947 gettext_noop(
"Vacuum cost delay in milliseconds, for autovacuum."),
3958 gettext_noop(
"Number of tuple updates or deletes prior to vacuum as a fraction of reltuples."),
3968 gettext_noop(
"Number of tuple inserts prior to vacuum as a fraction of reltuples."),
3978 gettext_noop(
"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."),
3988 gettext_noop(
"Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."),
3998 gettext_noop(
"Fraction of statements exceeding \"log_min_duration_sample\" to be logged."),
3999 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (always log).")
4008 gettext_noop(
"Sets the fraction of transactions from which to log all statements."),
4009 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (log all "
4010 "statements for all transactions).")
4019 {NULL, 0, 0, NULL, NULL}, NULL, 0.0, 0.0, 0.0, NULL, NULL, NULL
4028 gettext_noop(
"Sets the shell command that will be called to archive a WAL file."),
4029 gettext_noop(
"This is used only if \"archive_library\" is not set.")
4038 gettext_noop(
"Sets the library that will be called to archive a WAL file."),
4039 gettext_noop(
"An empty string indicates that \"archive_command\" should be used.")
4048 gettext_noop(
"Sets the shell command that will be called to retrieve an archived WAL file."),
4058 gettext_noop(
"Sets the shell command that will be executed at every restart point."),
4068 gettext_noop(
"Sets the shell command that will be executed once at the end of recovery."),
4078 gettext_noop(
"Specifies the timeline to recover into."),
4088 gettext_noop(
"Set to \"immediate\" to end recovery as soon as a consistent state is reached."),
4097 gettext_noop(
"Sets the transaction ID up to which recovery will proceed."),
4106 gettext_noop(
"Sets the time stamp up to which recovery will proceed."),
4115 gettext_noop(
"Sets the named restore point up to which recovery will proceed."),
4124 gettext_noop(
"Sets the LSN of the write-ahead log location up to which recovery will proceed."),
4134 gettext_noop(
"Sets the connection string to be used to connect to the sending server."),
4145 gettext_noop(
"Sets the name of the replication slot to use on the sending server."),
4155 gettext_noop(
"Sets the client's character set encoding."),
4166 gettext_noop(
"Controls information prefixed to each log line."),
4176 gettext_noop(
"Sets the time zone to use in log messages."),
4186 gettext_noop(
"Sets the display format for date and time values."),
4187 gettext_noop(
"Also controls interpretation of ambiguous "
4198 gettext_noop(
"Sets the default table access method for new tables."),
4209 gettext_noop(
"Sets the default tablespace to create tables and indexes in."),
4210 gettext_noop(
"An empty string selects the database's default tablespace."),
4220 gettext_noop(
"Sets the tablespace(s) to use for temporary tables and sort files."),
4231 gettext_noop(
"Sets whether a CREATEROLE user automatically grants "
4232 "the role to themselves, and with which options."),
4243 gettext_noop(
"Sets the path for dynamically loadable modules."),
4244 gettext_noop(
"If a dynamically loadable module needs to be opened and "
4245 "the specified name does not have a directory component (i.e., the "
4246 "name does not contain a slash), the system will search this path for "
4247 "the specified file."),
4257 gettext_noop(
"Sets the location of the Kerberos server key file."),
4278 gettext_noop(
"Sets the language in which messages are displayed."),
4288 gettext_noop(
"Sets the locale for formatting monetary amounts."),
4298 gettext_noop(
"Sets the locale for formatting numbers."),
4308 gettext_noop(
"Sets the locale for formatting date and time values."),
4318 gettext_noop(
"Lists shared libraries to preload into each backend."),
4329 gettext_noop(
"Lists shared libraries to preload into server."),
4340 gettext_noop(
"Lists unprivileged shared libraries to preload into each backend."),
4351 gettext_noop(
"Sets the schema search order for names that are not schema-qualified."),
4356 "\"$user\", public",
4363 gettext_noop(
"Shows the server (database) character set encoding."),
4410 gettext_noop(
"Sets the destination for server log output."),
4411 gettext_noop(
"Valid values are combinations of \"stderr\", "
4412 "\"syslog\", \"csvlog\", \"jsonlog\", and \"eventlog\", "
4413 "depending on the platform."),
4422 gettext_noop(
"Sets the destination directory for log files."),
4423 gettext_noop(
"Can be specified as relative to the data directory "
4424 "or as absolute path."),
4433 gettext_noop(
"Sets the file name pattern for log files."),
4438 "postgresql-%Y-%m-%d_%H%M%S.log",
4444 gettext_noop(
"Sets the program name used to identify PostgreSQL "
4445 "messages in syslog."),
4455 gettext_noop(
"Sets the application name used to identify "
4456 "PostgreSQL messages in the event log."),
4466 gettext_noop(
"Sets the time zone for displaying and interpreting time stamps."),
4476 gettext_noop(
"Selects a file of time zone abbreviations."),
4486 gettext_noop(
"Sets the owning group of the Unix-domain socket."),
4487 gettext_noop(
"The owning user of the socket is always the user "
4488 "that starts the server.")
4497 gettext_noop(
"Sets the directories where Unix-domain sockets will be created."),
4508 gettext_noop(
"Sets the host name or IP address(es) to listen to."),
4534 gettext_noop(
"Sets the server's main configuration file."),
4545 gettext_noop(
"Sets the server's \"hba\" configuration file."),
4556 gettext_noop(
"Sets the server's \"ident\" configuration file."),
4567 gettext_noop(
"Writes the postmaster PID to the specified file."),
4593 gettext_noop(
"Location of the SSL server certificate file."),
4603 gettext_noop(
"Location of the SSL server private key file."),
4613 gettext_noop(
"Location of the SSL certificate authority file."),
4623 gettext_noop(
"Location of the SSL certificate revocation list file."),
4633 gettext_noop(
"Location of the SSL certificate revocation list directory."),
4643 gettext_noop(
"Number of synchronous standbys and list of names of potential synchronous ones."),
4654 gettext_noop(
"Sets default text search configuration."),
4658 "pg_catalog.simple",
4664 gettext_noop(
"Sets the list of allowed TLSv1.3 cipher suites (leave blank for default)."),
4675 gettext_noop(
"Sets the list of allowed TLSv1.2 (and lower) ciphers."),
4681 "HIGH:MEDIUM:+3DES:!aNULL",
4690 gettext_noop(
"Sets the group(s) to use for Diffie-Hellman key exchange."),
4691 gettext_noop(
"Multiple groups can be specified using colon-separated list."),
4705 gettext_noop(
"Location of the SSL DH parameters file."),
4716 gettext_noop(
"Command to obtain passphrases for SSL."),
4727 gettext_noop(
"Sets the application name to be reported in statistics and logs."),
4738 gettext_noop(
"Sets the name of the cluster, which is included in the process title."),
4749 gettext_noop(
"Sets the WAL resource managers for which WAL consistency checks are done."),
4750 gettext_noop(
"Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay."),
4771 gettext_noop(
"Log backtrace for errors in these functions."),
4793 gettext_noop(
"Lists streaming replication standby server replication slot "
4794 "names that logical WAL sender processes will wait for."),
4795 gettext_noop(
"Logical WAL sender processes will send decoded "
4796 "changes to output plugins only after the specified "
4797 "replication slots have confirmed receiving WAL."),
4807 gettext_noop(
"Prohibits access to non-system relations of specified kinds."),
4818 {NULL, 0, 0, NULL, NULL}, NULL, NULL, NULL, NULL, NULL
4827 gettext_noop(
"Sets whether \"\\'\" is allowed in string literals."),
4847 gettext_noop(
"Sets the message levels that are sent to the client."),
4848 gettext_noop(
"Each level includes all the levels that follow it. The later"
4849 " the level, the fewer messages are sent.")
4858 gettext_noop(
"Enables in-core computation of query identifiers."),
4868 gettext_noop(
"Enables the planner to use constraints to optimize queries."),
4869 gettext_noop(
"Table scans will be skipped if their constraints"
4870 " guarantee that no rows match the query."),
4880 gettext_noop(
"Sets the default compression method for compressible values."),
4891 gettext_noop(
"Sets the transaction isolation level of each new transaction."),
4901 gettext_noop(
"Sets the current transaction's isolation level."),
4912 gettext_noop(
"Sets the display format for interval values."),
4923 gettext_noop(
"Log level for reporting invalid ICU locale strings."),
4933 gettext_noop(
"Sets the verbosity of logged messages."),
4943 gettext_noop(
"Sets the message levels that are logged."),
4944 gettext_noop(
"Each level includes all the levels that follow it. The later"
4945 " the level, the fewer messages are sent.")
4954 gettext_noop(
"Causes all statements generating error at or above this level to be logged."),
4955 gettext_noop(
"Each level includes all the levels that follow it. The later"
4956 " the level, the fewer messages are sent.")
4975 gettext_noop(
"Sets the syslog \"facility\" to be used when syslog enabled."),
4986 gettext_noop(
"Sets the session's behavior for triggers and rewrite rules."),
4996 gettext_noop(
"Sets the current transaction's synchronization level."),
5006 gettext_noop(
"Allows archiving of WAL files using \"archive_command\"."),
5016 gettext_noop(
"Sets the action to perform upon reaching the recovery target."),
5026 gettext_noop(
"Collects function-level statistics on database activity."),
5037 gettext_noop(
"Sets the consistency of accesses to statistics data."),
5047 gettext_noop(
"Compresses full-page writes written in WAL file with specified method."),
5057 gettext_noop(
"Sets the level of information written to the WAL."),
5067 gettext_noop(
"Selects the dynamic shared memory implementation used."),
5077 gettext_noop(
"Selects the shared memory implementation used for the main shared memory region."),
5087 gettext_noop(
"Selects the method used for forcing WAL updates to disk."),
5097 gettext_noop(
"Sets how binary values are to be encoded in XML."),
5107 gettext_noop(
"Sets whether XML data in implicit parsing and serialization "
5108 "operations is to be considered as documents or content fragments."),
5118 gettext_noop(
"Use of huge pages on Linux or Windows."),
5139 gettext_noop(
"Prefetch referenced blocks during recovery."),
5140 gettext_noop(
"Look ahead in the WAL to find references to uncached data.")
5149 gettext_noop(
"Forces the planner's use parallel query nodes."),
5150 gettext_noop(
"This can be useful for testing the parallel query infrastructure "
5151 "by forcing the planner to generate plans that contain nodes "
5152 "that perform tuple communication between workers and the main process."),
5162 gettext_noop(
"Chooses the algorithm for encrypting passwords."),
5172 gettext_noop(
"Controls the planner's selection of custom or generic plan."),
5173 gettext_noop(
"Prepared statements can have custom and generic plans, and the planner "
5174 "will attempt to choose which is better. This can be set to override "
5175 "the default behavior."),
5185 gettext_noop(
"Sets the minimum SSL/TLS protocol version to use."),
5197 gettext_noop(
"Sets the maximum SSL/TLS protocol version to use."),
5209 gettext_noop(
"Sets the method for synchronizing the data directory before crash recovery."),
5218 gettext_noop(
"Forces immediate streaming or serialization of changes in large transactions."),
5219 gettext_noop(
"On the publisher, it allows streaming or serializing each change in logical decoding. "
5220 "On the subscriber, it allows serialization of all changes to files and notifies the "
5221 "parallel apply workers to read and apply them at the end of the transaction."),
5231 {NULL, 0, 0, NULL, NULL}, NULL, 0, NULL, NULL, NULL, NULL
int min_parallel_index_scan_size
int min_parallel_table_scan_size
int max_notify_queue_pages
bool check_notify_buffers(int *newval, void **extra, GucSource source)
int scram_sha_256_iterations
char * pg_krb_server_keyfile
bool pg_krb_caseins_users
bool pg_gss_accept_delegation
int autovacuum_multixact_freeze_max_age
double autovacuum_vac_scale
int Log_autovacuum_min_duration
int autovacuum_anl_thresh
bool check_autovacuum_work_mem(int *newval, void **extra, GucSource source)
int autovacuum_vac_cost_limit
int autovacuum_max_workers
int autovacuum_freeze_max_age
double autovacuum_vac_cost_delay
int autovacuum_vac_thresh
double autovacuum_anl_scale
int autovacuum_vac_ins_thresh
bool autovacuum_start_daemon
double autovacuum_vac_ins_scale
bool check_default_tablespace(char **newval, void **extra, GucSource source)
void assign_temp_tablespaces(const char *newval, void *extra)
bool check_temp_tablespaces(char **newval, void **extra, GucSource source)
char * default_tablespace
bool allow_in_place_tablespaces
void assign_application_name(const char *newval, void *extra)
bool check_bonjour(bool *newval, void **extra, GucSource source)
bool check_maintenance_io_concurrency(int *newval, void **extra, GucSource source)
void assign_session_authorization(const char *newval, void *extra)
bool check_transaction_deferrable(bool *newval, void **extra, GucSource source)
bool check_canonical_path(char **newval, void **extra, GucSource source)
bool check_transaction_isolation(int *newval, void **extra, GucSource source)
bool check_default_with_oids(bool *newval, void **extra, GucSource source)
void assign_timezone_abbreviations(const char *newval, void *extra)
bool check_effective_io_concurrency(int *newval, void **extra, GucSource source)
bool check_application_name(char **newval, void **extra, GucSource source)
void assign_timezone(const char *newval, void *extra)
bool check_role(char **newval, void **extra, GucSource source)
bool check_cluster_name(char **newval, void **extra, GucSource source)
const char * show_random_seed(void)
bool check_session_authorization(char **newval, void **extra, GucSource source)
const char * show_log_file_mode(void)
bool check_transaction_read_only(bool *newval, void **extra, GucSource source)
void assign_maintenance_io_concurrency(int newval, void *extra)
bool check_timezone_abbreviations(char **newval, void **extra, GucSource source)
const char * show_log_timezone(void)
void assign_client_encoding(const char *newval, void *extra)
void assign_role(const char *newval, void *extra)
bool check_timezone(char **newval, void **extra, GucSource source)
bool check_ssl(bool *newval, void **extra, GucSource source)
void assign_datestyle(const char *newval, void *extra)
void assign_random_seed(double newval, void *extra)
const char * show_role(void)
bool check_log_timezone(char **newval, void **extra, GucSource source)
bool check_random_seed(double *newval, void **extra, GucSource source)
const char * show_unix_socket_permissions(void)
const char * show_timezone(void)
bool check_datestyle(char **newval, void **extra, GucSource source)
bool check_client_encoding(char **newval, void **extra, GucSource source)
const char * show_data_directory_mode(void)
void assign_log_timezone(const char *newval, void *extra)
int log_startup_progress_interval
bool Trace_connection_negotiation
bool pgstat_track_activities
int pgstat_track_activity_query_size
char * ssl_dh_params_file
int ssl_min_protocol_version
bool SSLPreferServerCiphers
int ssl_max_protocol_version
char * ssl_passphrase_command
bool ssl_passphrase_command_supports_reload
#define MAX_PARALLEL_WORKER_LIMIT
int checkpoint_flush_after
double bgwriter_lru_multiplier
int maintenance_io_concurrency
int effective_io_concurrency
int bgwriter_lru_maxpages
#define DEFAULT_IO_COMBINE_LIMIT
#define MAX_IO_COMBINE_LIMIT
#define MAX_IO_CONCURRENCY
#define DEFAULT_EFFECTIVE_IO_CONCURRENCY
#define DEFAULT_MAINTENANCE_IO_CONCURRENCY
bool ignore_checksum_failure
double CheckPointCompletionTarget
bool check_transaction_buffers(int *newval, void **extra, GucSource source)
int default_statistics_target
bool track_commit_timestamp
bool check_commit_ts_buffers(int *newval, void **extra, GucSource source)
#define DEFAULT_PARALLEL_TUPLE_COST
#define DEFAULT_PARALLEL_SETUP_COST
@ CONSTRAINT_EXCLUSION_OFF
@ CONSTRAINT_EXCLUSION_PARTITION
@ CONSTRAINT_EXCLUSION_ON
#define DEFAULT_CPU_INDEX_TUPLE_COST
#define DEFAULT_CPU_TUPLE_COST
#define DEFAULT_RANDOM_PAGE_COST
#define DEFAULT_RECURSIVE_WORKTABLE_FACTOR
#define DEFAULT_EFFECTIVE_CACHE_SIZE
#define DEFAULT_SEQ_PAGE_COST
#define DEFAULT_CPU_OPERATOR_COST
bool enable_partitionwise_aggregate
int max_parallel_workers_per_gather
double parallel_setup_cost
double recursive_worktable_factor
double parallel_tuple_cost
bool enable_indexonlyscan
bool enable_presorted_aggregate
bool enable_parallel_hash
bool enable_partitionwise_join
bool enable_parallel_append
bool enable_partition_pruning
double cpu_index_tuple_cost
bool enable_incremental_sort
bool md5_password_warnings
@ PASSWORD_TYPE_SCRAM_SHA_256
char * Dynamic_library_path
int min_dynamic_shared_memory
int dynamic_shared_memory_type
#define DEFAULT_DYNAMIC_SHARED_MEMORY_TYPE
void assign_syslog_facility(int newval, void *extra)
void assign_syslog_ident(const char *newval, void *extra)
bool syslog_split_messages
void assign_backtrace_functions(const char *newval, void *extra)
bool check_backtrace_functions(char **newval, void **extra, GucSource source)
bool check_log_destination(char **newval, void **extra, GucSource source)
bool syslog_sequence_numbers
char * Log_destination_string
void assign_log_destination(const char *newval, void *extra)
int max_files_per_process
int recovery_init_sync_method
void assign_debug_io_direct(const char *newval, void *extra)
bool check_debug_io_direct(char **newval, void **extra, GucSource source)
@ DATA_DIR_SYNC_METHOD_SYNCFS
@ DATA_DIR_SYNC_METHOD_FSYNC
#define DEFAULT_GEQO_EFFORT
#define MAX_GEQO_SELECTION_BIAS
#define DEFAULT_GEQO_SELECTION_BIAS
#define MIN_GEQO_SELECTION_BIAS
double Geqo_selection_bias
int gin_pending_list_limit
int multixact_offset_buffers
double hash_mem_multiplier
int max_parallel_maintenance_workers
int multixact_member_buffers
bool allowSystemTableMods
int VacuumBufferUsageLimit
int commit_timestamp_buffers
int subtransaction_buffers
#define GUC_SUPERUSER_ONLY
#define GUC_NOT_WHILE_SEC_REST
#define GUC_DISALLOW_IN_FILE
#define GUC_RUNTIME_COMPUTED
#define GUC_DISALLOW_IN_AUTO_FILE
#define GUC_ALLOW_IN_PARALLEL
#define GUC_NOT_IN_SAMPLE
static char * recovery_target_lsn_string
static char * client_encoding_string
static char * timezone_abbreviations_string
static const struct config_enum_entry stats_fetch_consistency[]
bool check_function_bodies
static int max_identifier_length
static const struct config_enum_entry password_encryption_options[]
static const struct config_enum_entry ssl_protocol_versions_info[]
const struct config_enum_entry recovery_target_action_options[]
static bool default_with_oids
struct config_string ConfigureNamesString[]
static char * timezone_string
static const struct config_enum_entry debug_parallel_query_options[]
static char * server_version_string
int log_min_error_statement
static bool data_checksums
static const struct config_enum_entry syslog_facility_options[]
static const struct config_enum_entry icu_validation_level_options[]
static const struct config_enum_entry recovery_prefetch_options[]
static const struct config_enum_entry recovery_init_sync_method_options[]
const char *const GucContext_Names[]
static int ssl_renegotiation_limit
static int syslog_facility
static int max_function_args
int tcp_keepalives_interval
static int max_index_keys
static const struct config_enum_entry backslash_quote_options[]
static char * syslog_ident_str
#define DEFAULT_SYSLOG_FACILITY
const char *const GucSource_Names[]
double log_xact_sample_rate
#define DEFAULT_ASSERT_ENABLED
static const struct config_enum_entry shared_memory_options[]
struct config_int ConfigureNamesInt[]
static const struct config_enum_entry huge_pages_status_options[]
const char *const config_type_names[]
static char * server_encoding_string
static int wal_block_size
static const struct config_enum_entry log_statement_options[]
static const struct config_enum_entry plan_cache_mode_options[]
static const struct config_enum_entry wal_compression_options[]
static const struct config_enum_entry debug_logical_replication_streaming_options[]
static char * datestyle_string
static char * recovery_target_timeline_string
static char * restrict_nonsystem_relation_kind_string
int log_parameter_max_length_on_error
const struct config_enum_entry dynamic_shared_memory_options[]
static const struct config_enum_entry xmlbinary_options[]
int log_min_duration_statement
static char * recovery_target_xid_string
int log_min_duration_sample
bool log_btree_build_stats
struct config_bool ConfigureNamesBool[]
static const struct config_enum_entry bytea_output_options[]
const struct config_enum_entry archive_mode_options[]
static const struct config_enum_entry huge_pages_options[]
static const struct config_enum_entry synchronous_commit_options[]
static char * recovery_target_string
static bool assert_enabled
static const struct config_enum_entry default_toast_compression_options[]
static char * log_timezone_string
static char * session_authorization_string
bool Debug_print_rewritten
static int shared_memory_size_in_huge_pages
static const struct config_enum_entry isolation_level_options[]
static const struct config_enum_entry log_error_verbosity_options[]
const struct config_enum_entry wal_sync_method_options[]
static int server_version_num
static const struct config_enum_entry intervalstyle_options[]
int log_parameter_max_length
struct config_real ConfigureNamesReal[]
const struct config_enum_entry wal_level_options[]
struct config_enum ConfigureNamesEnum[]
static const struct config_enum_entry client_message_level_options[]
bool current_role_is_superuser
static const struct config_enum_entry constraint_exclusion_options[]
static const struct config_enum_entry server_message_level_options[]
static const struct config_enum_entry compute_query_id_options[]
static char * recovery_target_name_string
static char * data_directory
StaticAssertDecl(lengthof(bytea_output_options)==(BYTEA_OUTPUT_HEX+2), "array length mismatch")
double log_statement_sample_rate
const char *const config_group_names[]
static bool integer_datetimes
static double phony_random_seed
static int num_os_semaphores
char * backtrace_functions
static int shared_memory_size_mb
static const struct config_enum_entry session_replication_role_options[]
static const struct config_enum_entry track_function_options[]
static const struct config_enum_entry xmloption_options[]
static int huge_pages_status
static char * debug_io_direct_string
@ COMPAT_OPTIONS_PREVIOUS
@ REPLICATION_SUBSCRIBERS
bool lo_compat_privileges
double jit_optimize_above_cost
double jit_inline_above_cost
bool jit_profiling_support
bool jit_debugging_support
int max_logical_replication_workers
int max_sync_workers_per_subscription
int max_parallel_apply_workers_per_subscription
bool check_temp_buffers(int *newval, void **extra, GucSource source)
#define INTSTYLE_SQL_STANDARD
#define INTSTYLE_POSTGRES_VERBOSE
#define MAX_BAS_VAC_RING_SIZE_KB
#define INTSTYLE_ISO_8601
#define INTSTYLE_POSTGRES
char * shared_preload_libraries_string
char * session_preload_libraries_string
char * local_preload_libraries_string
bool check_multixact_offset_buffers(int *newval, void **extra, GucSource source)
bool check_multixact_member_buffers(int *newval, void **extra, GucSource source)
void assign_search_path(const char *newval, void *extra)
char * namespace_search_path
bool check_search_path(char **newval, void **extra, GucSource source)
bool Transform_null_equals
@ BACKSLASH_QUOTE_SAFE_ENCODING
bool enable_group_by_reordering
#define WRITEBACK_MAX_PENDING_FLUSHES
#define DEFAULT_PGSOCKET_DIR
#define DEFAULT_XLOG_SEG_SIZE
#define DEFAULT_EVENT_SOURCE
#define DEFAULT_BACKEND_FLUSH_AFTER
#define DEFAULT_CHECKPOINT_FLUSH_AFTER
#define DEFAULT_BGWRITER_FLUSH_AFTER
void assign_locale_time(const char *newval, void *extra)
bool check_locale_time(char **newval, void **extra, GucSource source)
bool check_locale_numeric(char **newval, void **extra, GucSource source)
void assign_locale_numeric(const char *newval, void *extra)
bool check_locale_messages(char **newval, void **extra, GucSource source)
void assign_locale_messages(const char *newval, void *extra)
void assign_locale_monetary(const char *newval, void *extra)
bool check_locale_monetary(char **newval, void **extra, GucSource source)
#define DEFAULT_SHARED_MEMORY_TYPE
char * XLogArchiveLibrary
int pgstat_fetch_consistency
void assign_stats_fetch_consistency(int newval, void *extra)
@ PGSTAT_FETCH_CONSISTENCY_NONE
@ PGSTAT_FETCH_CONSISTENCY_CACHE
@ PGSTAT_FETCH_CONSISTENCY_SNAPSHOT
int pgstat_track_functions
@ PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN
@ PLAN_CACHE_MODE_FORCE_GENERIC_PLAN
#define DEFAULT_CURSOR_TUPLE_FRACTION
double cursor_tuple_fraction
bool parallel_leader_participation
bool enable_distinct_reordering
void assign_transaction_timeout(int newval, void *extra)
void assign_restrict_nonsystem_relation_kind(const char *newval, void *extra)
int client_connection_check_interval
bool check_log_stats(bool *newval, void **extra, GucSource source)
bool check_client_connection_check_interval(int *newval, void **extra, GucSource source)
bool check_restrict_nonsystem_relation_kind(char **newval, void **extra, GucSource source)
bool check_stage_log_stats(bool *newval, void **extra, GucSource source)
bool remove_temp_files_after_crash
char * Unix_socket_directories
bool send_abort_for_crash
int AuthenticationTimeout
int SuperuserReservedConnections
void assign_tcp_keepalives_count(int newval, void *extra)
const char * show_tcp_keepalives_interval(void)
int Unix_socket_permissions
const char * show_tcp_keepalives_count(void)
const char * show_tcp_keepalives_idle(void)
void assign_tcp_keepalives_idle(int newval, void *extra)
const char * show_tcp_user_timeout(void)
void assign_tcp_user_timeout(int newval, void *extra)
void assign_tcp_keepalives_interval(int newval, void *extra)
int max_predicate_locks_per_page
int max_predicate_locks_per_relation
bool check_serial_buffers(int *newval, void **extra, GucSource source)
int max_predicate_locks_per_xact
bool update_process_title
#define DEFAULT_UPDATE_PROCESS_TITLE
@ COMPUTE_QUERY_ID_REGRESS
int logical_decoding_work_mem
int debug_logical_replication_streaming
@ DEBUG_LOGICAL_REP_STREAMING_IMMEDIATE
@ DEBUG_LOGICAL_REP_STREAMING_BUFFERED
bool quote_all_identifiers
bool escape_string_warning
bool standard_conforming_strings
#define SCRAM_SHA_256_DEFAULT_ITERATIONS
char * synchronized_standby_slots
void assign_synchronized_standby_slots(const char *newval, void *extra)
bool check_synchronized_standby_slots(char **newval, void **extra, GucSource source)
int max_replication_slots
bool sync_replication_slots
#define SLRU_MAX_ALLOWED_BUFFERS
int IdleInTransactionSessionTimeout
bool check_max_stack_depth(int *newval, void **extra, GucSource source)
void assign_max_stack_depth(int newval, void *extra)
bool log_recovery_conflict_waits
int max_standby_archive_delay
int max_standby_streaming_delay
bool check_subtrans_buffers(int *newval, void **extra, GucSource source)
void assign_synchronous_commit(int newval, void *extra)
void assign_synchronous_standby_names(const char *newval, void *extra)
char * SyncRepStandbyNames
bool check_synchronous_standby_names(char **newval, void **extra, GucSource source)
bool Log_truncate_on_rotation
bool check_huge_page_size(int *newval, void **extra, GucSource source)
char * default_table_access_method
bool synchronize_seqscans
#define DEFAULT_TABLE_ACCESS_METHOD
bool check_default_table_access_method(char **newval, void **extra, GucSource source)
int default_toast_compression
#define TOAST_PGLZ_COMPRESSION
#define TOAST_LZ4_COMPRESSION
#define FirstNormalObjectId
int SessionReplicationRole
void assign_session_replication_role(int newval, void *extra)
#define SESSION_REPLICATION_ROLE_REPLICA
#define SESSION_REPLICATION_ROLE_LOCAL
#define SESSION_REPLICATION_ROLE_ORIGIN
bool check_default_text_search_config(char **newval, void **extra, GucSource source)
void assign_default_text_search_config(const char *newval, void *extra)
bool check_createrole_self_grant(char **newval, void **extra, GucSource source)
void assign_createrole_self_grant(const char *newval, void *extra)
char * createrole_self_grant
int vacuum_freeze_min_age
bool check_vacuum_buffer_usage_limit(int *newval, void **extra, GucSource source)
int vacuum_multixact_freeze_table_age
int vacuum_freeze_table_age
int vacuum_multixact_failsafe_age
int vacuum_multixact_freeze_min_age
#define MAX_STATISTICS_TARGET
bool hot_standby_feedback
int wal_receiver_status_interval
bool log_replication_commands
int wal_summary_keep_time
#define DEFAULT_WAL_WRITER_FLUSH_AFTER
bool DefaultXactDeferrable
#define XACT_SERIALIZABLE
@ SYNCHRONOUS_COMMIT_LOCAL_FLUSH
@ SYNCHRONOUS_COMMIT_REMOTE_WRITE
@ SYNCHRONOUS_COMMIT_REMOTE_APPLY
#define SYNCHRONOUS_COMMIT_ON
#define XACT_READ_UNCOMMITTED
#define XACT_REPEATABLE_READ
#define XACT_READ_COMMITTED
void assign_wal_sync_method(int new_wal_sync_method, void *extra)
int wal_decode_buffer_size
bool check_max_slot_wal_keep_size(int *newval, void **extra, GucSource source)
char * XLogArchiveCommand
void assign_wal_consistency_checking(const char *newval, void *extra)
void assign_checkpoint_completion_target(double newval, void *extra)
const char * show_archive_command(void)
char * wal_consistency_checking_string
const char * show_in_hot_standby(void)
int max_slot_wal_keep_size_mb
void assign_max_wal_size(int newval, void *extra)
int wal_retrieve_retry_interval
bool check_wal_segment_size(int *newval, void **extra, GucSource source)
bool check_wal_consistency_checking(char **newval, void **extra, GucSource source)
bool check_wal_buffers(int *newval, void **extra, GucSource source)
@ RECOVERY_TARGET_ACTION_PAUSE
#define DEFAULT_MAX_WAL_SEGS
#define DEFAULT_MIN_WAL_SEGS
#define DEFAULT_WAL_SYNC_METHOD
void assign_recovery_prefetch(int new_value, void *extra)
bool check_recovery_prefetch(int *new_value, void **extra, GucSource source)
bool check_primary_slot_name(char **newval, void **extra, GucSource source)
void assign_recovery_target_xid(const char *newval, void *extra)
int recovery_min_apply_delay
bool check_recovery_target(char **newval, void **extra, GucSource source)
bool check_recovery_target_timeline(char **newval, void **extra, GucSource source)
char * recoveryRestoreCommand
void assign_recovery_target(const char *newval, void *extra)
char * archiveCleanupCommand
char * recovery_target_time_string
void assign_recovery_target_name(const char *newval, void *extra)
void assign_recovery_target_time(const char *newval, void *extra)
bool check_recovery_target_xid(char **newval, void **extra, GucSource source)
bool check_recovery_target_time(char **newval, void **extra, GucSource source)
bool wal_receiver_create_temp_slot
char * recoveryEndCommand
void assign_recovery_target_lsn(const char *newval, void *extra)
bool check_recovery_target_lsn(char **newval, void **extra, GucSource source)
bool check_recovery_target_name(char **newval, void **extra, GucSource source)
bool recoveryTargetInclusive
void assign_recovery_target_timeline(const char *newval, void *extra)
bool ignore_invalid_pages