107#define PG_KRB_SRVTAB ""
123 "array length mismatch");
131 {
"debug5",
DEBUG5,
false},
132 {
"debug4",
DEBUG4,
false},
133 {
"debug3",
DEBUG3,
false},
134 {
"debug2",
DEBUG2,
false},
135 {
"debug1",
DEBUG1,
false},
138 {
"info",
INFO,
true},
139 {
"notice",
NOTICE,
false},
141 {
"error",
ERROR,
false},
146 {
"debug5",
DEBUG5,
false},
147 {
"debug4",
DEBUG4,
false},
148 {
"debug3",
DEBUG3,
false},
149 {
"debug2",
DEBUG2,
false},
150 {
"debug1",
DEBUG1,
false},
152 {
"info",
INFO,
false},
153 {
"notice",
NOTICE,
false},
155 {
"error",
ERROR,
false},
157 {
"fatal",
FATAL,
false},
158 {
"panic",
PANIC,
false},
171 {
"disabled", -1,
false},
172 {
"debug5",
DEBUG5,
false},
173 {
"debug4",
DEBUG4,
false},
174 {
"debug3",
DEBUG3,
false},
175 {
"debug2",
DEBUG2,
false},
176 {
"debug1",
DEBUG1,
false},
179 {
"info",
INFO,
true},
180 {
"notice",
NOTICE,
false},
182 {
"error",
ERROR,
false},
187 "array length mismatch");
197 "array length mismatch");
208 "array length mismatch");
226 "array length mismatch");
230 {
"local0", LOG_LOCAL0,
false},
231 {
"local1", LOG_LOCAL1,
false},
232 {
"local2", LOG_LOCAL2,
false},
233 {
"local3", LOG_LOCAL3,
false},
234 {
"local4", LOG_LOCAL4,
false},
235 {
"local5", LOG_LOCAL5,
false},
236 {
"local6", LOG_LOCAL6,
false},
237 {
"local7", LOG_LOCAL7,
false},
252 "array length mismatch");
262 "array length mismatch");
271 "array length mismatch");
280 "array length mismatch");
432 "array length mismatch");
501#ifdef DEBUG_NODE_TESTS_ENABLED
502bool Debug_copy_parse_plan_trees;
503bool Debug_write_read_parse_plan_trees;
504bool Debug_raw_expression_coverage_test;
587#define DEFAULT_SYSLOG_FACILITY LOG_LOCAL0
589#define DEFAULT_SYSLOG_FACILITY 0
610#ifdef USE_ASSERT_CHECKING
611#define DEFAULT_ASSERT_ENABLED true
613#define DEFAULT_ASSERT_ENABLED false
647 "array length mismatch");
673 "array length mismatch");
731 "array length mismatch");
748 "array length mismatch");
782 gettext_noop(
"Enables the planner's use of sequential-scan plans."),
792 gettext_noop(
"Enables the planner's use of index-scan plans."),
802 gettext_noop(
"Enables the planner's use of index-only-scan plans."),
812 gettext_noop(
"Enables the planner's use of bitmap-scan plans."),
822 gettext_noop(
"Enables the planner's use of TID scan plans."),
832 gettext_noop(
"Enables the planner's use of explicit sort steps."),
842 gettext_noop(
"Enables the planner's use of incremental sort steps."),
852 gettext_noop(
"Enables the planner's use of hashed aggregation plans."),
862 gettext_noop(
"Enables the planner's use of materialization."),
872 gettext_noop(
"Enables the planner's use of memoization."),
882 gettext_noop(
"Enables the planner's use of nested-loop join plans."),
892 gettext_noop(
"Enables the planner's use of merge join plans."),
902 gettext_noop(
"Enables the planner's use of hash join plans."),
912 gettext_noop(
"Enables the planner's use of gather merge plans."),
932 gettext_noop(
"Enables partitionwise aggregation and grouping."),
942 gettext_noop(
"Enables the planner's use of parallel append plans."),
952 gettext_noop(
"Enables the planner's use of parallel hash plans."),
962 gettext_noop(
"Enables plan-time and execution-time partition pruning."),
963 gettext_noop(
"Allows the query planner and executor to compare partition "
964 "bounds to conditions in the query to determine which "
965 "partitions must be scanned."),
974 gettext_noop(
"Enables the planner's ability to produce plans that "
975 "provide presorted input for ORDER BY / DISTINCT aggregate "
977 gettext_noop(
"Allows the query planner to build plans that provide "
978 "presorted input for aggregate functions with an ORDER BY / "
979 "DISTINCT clause. When disabled, implicit sorts are always "
980 "performed during execution."),
989 gettext_noop(
"Enables the planner's use of async append plans."),
1019 gettext_noop(
"Enables reordering of DISTINCT pathkeys."),
1030 gettext_noop(
"This algorithm attempts to do planning without "
1031 "exhaustive searching."),
1044 gettext_noop(
"Shows whether the current user is a superuser."),
1059 gettext_noop(
"Allows running the ALTER SYSTEM command."),
1060 gettext_noop(
"Can be set to off for environments where global configuration "
1061 "changes should be made using a different method."),
1070 gettext_noop(
"Enables advertising the server via Bonjour."),
1097 gettext_noop(
"Controls whether \"ssl_passphrase_command\" is called during server reload."),
1106 gettext_noop(
"Give priority to server ciphersuite order."),
1115 gettext_noop(
"Forces synchronization of updates to disk."),
1116 gettext_noop(
"The server will use the fsync() system call in several places to make "
1117 "sure that updates are physically written to disk. This ensures "
1118 "that a database cluster will recover to a consistent state after "
1119 "an operating system or hardware crash.")
1127 gettext_noop(
"Continues processing after a checksum failure."),
1128 gettext_noop(
"Detection of a checksum failure normally causes PostgreSQL to "
1129 "report an error, aborting the current transaction. Setting "
1130 "ignore_checksum_failure to true causes the system to ignore the failure "
1131 "(but still report a warning), and continue processing. This "
1132 "behavior could cause crashes or other serious problems. Only "
1133 "has an effect if checksums are enabled."),
1142 gettext_noop(
"Continues processing past damaged page headers."),
1143 gettext_noop(
"Detection of a damaged page header normally causes PostgreSQL to "
1144 "report an error, aborting the current transaction. Setting "
1145 "\"zero_damaged_pages\" to true causes the system to instead report a "
1146 "warning, zero out the damaged page, and continue processing. This "
1147 "behavior will destroy data, namely all the rows on the damaged page."),
1156 gettext_noop(
"Continues recovery after an invalid pages failure."),
1157 gettext_noop(
"Detection of WAL records having references to "
1158 "invalid pages during recovery causes PostgreSQL to "
1159 "raise a PANIC-level error, aborting the recovery. "
1160 "Setting \"ignore_invalid_pages\" to true causes "
1161 "the system to ignore invalid page references "
1162 "in WAL records (but still report a warning), "
1163 "and continue recovery. This behavior may cause "
1164 "crashes, data loss, propagate or hide corruption, "
1165 "or other serious problems. Only has an effect "
1166 "during recovery or in standby mode."),
1175 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint."),
1176 gettext_noop(
"A page write in process during an operating system crash might be "
1177 "only partially written to disk. During recovery, the row changes "
1178 "stored in WAL are not enough to recover. This option writes "
1179 "pages when first modified after a checkpoint to WAL so full recovery "
1189 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification."),
1199 gettext_noop(
"Writes zeroes to new WAL files before first use."),
1228 gettext_noop(
"Logs details of pre-authentication connection handshake."),
1238 gettext_noop(
"Logs end of a session, including duration."),
1256 gettext_noop(
"Shows whether the running server has assertion checks enabled."),
1276 gettext_noop(
"Reinitialize server after backend crash."),
1285 gettext_noop(
"Remove temporary files after backend crash."),
1295 gettext_noop(
"Send SIGABRT not SIGQUIT to child processes after backend crash."),
1305 gettext_noop(
"Send SIGABRT not SIGKILL to stuck child processes."),
1316 gettext_noop(
"Logs the duration of each completed SQL statement."),
1323#ifdef DEBUG_NODE_TESTS_ENABLED
1326 gettext_noop(
"Set this to force all parse and plan trees to be passed through "
1327 "copyObject(), to facilitate catching errors and omissions in "
1332 &Debug_copy_parse_plan_trees,
1334#ifdef COPY_PARSE_PLAN_TREES
1343 gettext_noop(
"Set this to force all parse and plan trees to be passed through "
1344 "outfuncs.c/readfuncs.c, to facilitate catching errors and omissions in "
1349 &Debug_write_read_parse_plan_trees,
1351#ifdef WRITE_READ_PARSE_PLAN_TREES
1360 gettext_noop(
"Set this to force all raw parse trees for DML statements to be scanned "
1361 "by raw_expression_tree_walker(), to facilitate catching errors and "
1362 "omissions in that function."),
1366 &Debug_raw_expression_coverage_test,
1368#ifdef RAW_EXPRESSION_COVERAGE_TEST
1387 gettext_noop(
"Logs each query's rewritten parse tree."),
1414 gettext_noop(
"Writes parser performance statistics to the server log."),
1423 gettext_noop(
"Writes planner performance statistics to the server log."),
1432 gettext_noop(
"Writes executor performance statistics to the server log."),
1441 gettext_noop(
"Writes cumulative performance statistics to the server log."),
1448#ifdef BTREE_BUILD_STATS
1451 gettext_noop(
"Logs system resource usage statistics (memory and CPU) on various B-tree operations."),
1463 gettext_noop(
"Collects information about executing commands."),
1464 gettext_noop(
"Enables the collection of information on the currently "
1465 "executing command of each session, along with "
1466 "the time at which that command began execution.")
1474 gettext_noop(
"Collects statistics on database activity."),
1483 gettext_noop(
"Collects timing statistics for cost-based vacuum delay."),
1492 gettext_noop(
"Collects timing statistics for database I/O activity."),
1501 gettext_noop(
"Collects timing statistics for WAL I/O activity."),
1511 gettext_noop(
"Updates the process title to show the active SQL command."),
1512 gettext_noop(
"Enables updating of the process title every time a new SQL command is received by the server.")
1531 gettext_noop(
"Generates debugging output for LISTEN and NOTIFY."),
1553 gettext_noop(
"Emits information about user lock usage."),
1563 gettext_noop(
"Emits information about lightweight lock usage."),
1573 gettext_noop(
"Dumps information about all current locks when a deadlock timeout occurs."),
1612 gettext_noop(
"Logs the host name in the connection logs."),
1613 gettext_noop(
"By default, connection logs only show the IP address "
1614 "of the connecting host. If you want them to show the host name you "
1615 "can turn this on, but depending on your host name resolution "
1616 "setup it might impose a non-negligible performance penalty.")
1624 gettext_noop(
"Treats \"expr=NULL\" as \"expr IS NULL\"."),
1625 gettext_noop(
"When turned on, expressions of the form expr = NULL "
1626 "(or NULL = expr) are treated as expr IS NULL, that is, they "
1627 "return true if expr evaluates to the null value, and false "
1628 "otherwise. The correct behavior of expr = NULL is to always "
1629 "return null (unknown).")
1637 gettext_noop(
"Sets the default read-only status of new transactions."),
1647 gettext_noop(
"Sets the current transaction's read-only status."),
1657 gettext_noop(
"Sets the default deferrable status of new transactions."),
1666 gettext_noop(
"Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures."),
1677 gettext_noop(
"When enabled, row security will be applied to all users.")
1685 gettext_noop(
"Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE."),
1694 gettext_noop(
"Enables input of NULL elements in arrays."),
1695 gettext_noop(
"When turned on, unquoted NULL in an array input "
1696 "value means a null value; "
1697 "otherwise it is taken literally.")
1711 gettext_noop(
"WITH OIDS is no longer supported; this can only be false."),
1721 gettext_noop(
"Start a subprocess to capture stderr, csvlog and/or jsonlog into log files."),
1730 gettext_noop(
"Truncate existing log files of same name during log rotation."),
1740 gettext_noop(
"Emit information about resource usage in sorting."),
1749#ifdef TRACE_SYNCSCAN
1753 gettext_noop(
"Generate debugging output for synchronized scanning."),
1763#ifdef DEBUG_BOUNDED_SORT
1768 gettext_noop(
"Enables bounded sorting using heap sort."),
1772 &optimize_bounded_sort,
1793 gettext_noop(
"Shows whether datetimes are integer based."),
1804 gettext_noop(
"Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive."),
1814 gettext_noop(
"Sets whether GSSAPI delegation should be accepted from the client."),
1824 gettext_noop(
"Warn about backslash escapes in ordinary string literals."),
1834 gettext_noop(
"Causes '...' strings to treat backslashes literally."),
1845 gettext_noop(
"Enables synchronized sequential scans."),
1855 gettext_noop(
"Sets whether to include or exclude transaction with recovery target."),
1865 gettext_noop(
"Starts the WAL summarizer process to enable incremental backup."),
1875 gettext_noop(
"Allows connections and queries during recovery."),
1885 gettext_noop(
"Allows feedback from a hot standby to the primary that will avoid query conflicts."),
1895 gettext_noop(
"Shows whether hot standby is currently active."),
1906 gettext_noop(
"Allows modifications of the structure of system tables."),
1918 gettext_noop(
"It does not prevent updating the indexes, so it is safe "
1919 "to use. The worst consequence is slowness."),
1929 gettext_noop(
"Allows tablespaces directly inside pg_tblspc, for testing."),
1940 gettext_noop(
"Enables backward compatibility mode for privilege checks on large objects."),
1941 gettext_noop(
"Skips privilege checks when reading or modifying large objects, "
1942 "for compatibility with PostgreSQL releases prior to 9.0.")
1951 gettext_noop(
"When generating SQL fragments, quote all identifiers."),
1961 gettext_noop(
"Shows whether data checksums are turned on for this cluster."),
1972 gettext_noop(
"Add sequence number to syslog messages to avoid duplicate suppression."),
1982 gettext_noop(
"Split messages sent to syslog by lines and to fit into 1024 bytes."),
1992 gettext_noop(
"Controls whether Gather and Gather Merge also run subplans."),
1993 gettext_noop(
"Should gather nodes also run subplans or just gather tuples?"),
2014 gettext_noop(
"Register JIT-compiled functions with debugger."),
2031 gettext_noop(
"Write out LLVM bitcode to facilitate JIT debugging."),
2053 gettext_noop(
"Register JIT-compiled functions with perf profiler."),
2070 gettext_noop(
"Allow JIT compilation of tuple deforming."),
2081 gettext_noop(
"Whether to continue running after a failure to sync data files."),
2090 gettext_noop(
"Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured."),
2100 gettext_noop(
"When enabled, event triggers will fire for all applicable statements."),
2109 gettext_noop(
"Enables a physical standby to synchronize logical failover replication slots from the primary server."),
2118 gettext_noop(
"Enables deprecation warnings for MD5 passwords."),
2127 gettext_noop(
"Allows to merge constants in a list when computing "
2137 gettext_noop(
"Enables vacuum to truncate empty pages at the end of the table."),
2146 {NULL, 0, 0, NULL, NULL}, NULL,
false, NULL, NULL, NULL
2155 gettext_noop(
"Sets the amount of time to wait before forcing a "
2156 "switch to the next WAL file."),
2167 "authentication on connection startup."),
2168 gettext_noop(
"This allows attaching a debugger to the process."),
2172 0, 0, INT_MAX / 1000000,
2178 gettext_noop(
"This applies to table columns that have not had a "
2179 "column-specific target set via ALTER TABLE SET STATISTICS.")
2187 gettext_noop(
"Sets the FROM-list size beyond which subqueries "
2188 "are not collapsed."),
2189 gettext_noop(
"The planner will merge subqueries into upper "
2190 "queries if the resulting FROM list would have no more than "
2191 "this many items."),
2200 gettext_noop(
"Sets the FROM-list size beyond which JOIN "
2201 "constructs are not flattened."),
2203 "constructs into lists of FROM items whenever a "
2204 "list of no more than this many items would result."),
2213 gettext_noop(
"Sets the threshold of FROM items beyond which GEQO is used."),
2223 gettext_noop(
"GEQO: effort is used to set the default for other GEQO parameters."),
2233 gettext_noop(
"GEQO: number of individuals in the population."),
2243 gettext_noop(
"GEQO: number of iterations of the algorithm."),
2255 gettext_noop(
"Sets the time to wait on a lock before checking for deadlock."),
2266 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data."),
2271 30 * 1000, -1, INT_MAX,
2277 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data."),
2282 30 * 1000, -1, INT_MAX,
2288 gettext_noop(
"Sets the minimum delay for applying changes during recovery."),
2299 gettext_noop(
"Sets the maximum interval between WAL receiver status reports to the sending server."),
2304 10, 0, INT_MAX / 1000,
2310 gettext_noop(
"Sets the maximum wait time to receive data from the sending server."),
2315 60 * 1000, 0, INT_MAX,
2321 gettext_noop(
"Sets the maximum number of concurrent connections."),
2332 gettext_noop(
"Sets the number of connection slots reserved for superusers."),
2342 gettext_noop(
"Sets the number of connection slots reserved for roles "
2343 "with privileges of pg_use_reserved_connections."),
2353 gettext_noop(
"Amount of dynamic shared memory reserved at startup."),
2358 0, 0, (int)
Min((
size_t) INT_MAX, SIZE_MAX / (1024 * 1024)),
2368 gettext_noop(
"Sets the number of shared memory buffers used by the server."),
2373 16384, 16, INT_MAX / 2,
2379 gettext_noop(
"Sets the buffer pool size for VACUUM, ANALYZE, and autovacuum."),
2390 gettext_noop(
"Shows the size of the server's main shared memory area (rounded up to the nearest MB)."),
2401 gettext_noop(
"Shows the number of huge pages needed for the main shared memory area."),
2402 gettext_noop(
"-1 means huge pages are not supported."),
2412 gettext_noop(
"Shows the number of semaphores required for the server."),
2423 gettext_noop(
"Sets the size of the dedicated buffer pool used for the commit timestamp cache."),
2424 gettext_noop(
"0 means use a fraction of \"shared_buffers\"."),
2434 gettext_noop(
"Sets the size of the dedicated buffer pool used for the MultiXact member cache."),
2445 gettext_noop(
"Sets the size of the dedicated buffer pool used for the MultiXact offset cache."),
2456 gettext_noop(
"Sets the size of the dedicated buffer pool used for the LISTEN/NOTIFY message cache."),
2467 gettext_noop(
"Sets the size of the dedicated buffer pool used for the serializable transaction cache."),
2478 gettext_noop(
"Sets the size of the dedicated buffer pool used for the subtransaction cache."),
2479 gettext_noop(
"0 means use a fraction of \"shared_buffers\"."),
2489 gettext_noop(
"Sets the size of the dedicated buffer pool used for the transaction status cache."),
2490 gettext_noop(
"0 means use a fraction of \"shared_buffers\"."),
2500 gettext_noop(
"Sets the maximum number of temporary buffers used by each session."),
2505 1024, 100, INT_MAX / 2,
2511 gettext_noop(
"Sets the TCP port the server listens on."),
2515 DEF_PGPORT, 1, 65535,
2521 gettext_noop(
"Sets the access permissions of the Unix-domain socket."),
2522 gettext_noop(
"Unix-domain sockets use the usual Unix file system "
2523 "permission set. The parameter value is expected "
2524 "to be a numeric mode specification in the form "
2525 "accepted by the chmod and umask system calls. "
2526 "(To use the customary octal format the number must "
2527 "start with a 0 (zero).)")
2536 gettext_noop(
"Sets the file permissions for log files."),
2538 "to be a numeric mode specification in the form "
2539 "accepted by the chmod and umask system calls. "
2540 "(To use the customary octal format the number must "
2541 "start with a 0 (zero).)")
2552 gettext_noop(
"The parameter value is a numeric mode specification "
2553 "in the form accepted by the chmod and umask system "
2554 "calls. (To use the customary octal format the number "
2555 "must start with a 0 (zero).)"),
2565 gettext_noop(
"Sets the maximum memory to be used for query workspaces."),
2566 gettext_noop(
"This much memory can be used by each internal "
2567 "sort operation and hash table before switching to "
2568 "temporary disk files."),
2583 gettext_noop(
"Sets the maximum memory to be used for maintenance operations."),
2584 gettext_noop(
"This includes operations such as VACUUM and CREATE INDEX."),
2594 gettext_noop(
"Sets the maximum memory to be used for logical decoding."),
2595 gettext_noop(
"This much memory can be used by each internal "
2596 "reorder buffer before spilling to disk."),
2611 gettext_noop(
"Sets the maximum stack depth, in kilobytes."),
2622 gettext_noop(
"Limits the total size of all temporary files used by each process."),
2633 gettext_noop(
"Vacuum cost for a page found in the buffer cache."),
2643 gettext_noop(
"Vacuum cost for a page not found in the buffer cache."),
2653 gettext_noop(
"Vacuum cost for a page dirtied by vacuum."),
2663 gettext_noop(
"Vacuum cost amount available before napping."),
2673 gettext_noop(
"Vacuum cost amount available before napping, for autovacuum."),
2683 gettext_noop(
"Sets the maximum number of simultaneously open files for each server process."),
2696 gettext_noop(
"Sets the maximum number of simultaneously prepared transactions."),
2707 gettext_noop(
"Sets the minimum OID of tables for tracking locks."),
2708 gettext_noop(
"Is used to avoid output on system tables."),
2717 gettext_noop(
"Sets the OID of the table with unconditionally lock tracing."),
2729 gettext_noop(
"Sets the maximum allowed duration of any statement."),
2740 gettext_noop(
"Sets the maximum allowed duration of any wait for a lock."),
2751 gettext_noop(
"Sets the maximum allowed idle time between queries, when in a transaction."),
2762 gettext_noop(
"Sets the maximum allowed duration of any transaction within a session (not a prepared transaction)."),
2773 gettext_noop(
"Sets the maximum allowed idle time between queries, when not in a transaction."),
2784 gettext_noop(
"Minimum age at which VACUUM should freeze a table row."),
2788 50000000, 0, 1000000000,
2794 gettext_noop(
"Age at which VACUUM should scan whole table to freeze tuples."),
2798 150000000, 0, 2000000000,
2804 gettext_noop(
"Minimum age at which VACUUM should freeze a MultiXactId in a table row."),
2808 5000000, 0, 1000000000,
2814 gettext_noop(
"Multixact age at which VACUUM should scan whole table to freeze tuples."),
2818 150000000, 0, 2000000000,
2824 gettext_noop(
"Age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2828 1600000000, 0, 2100000000,
2833 gettext_noop(
"Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2837 1600000000, 0, 2100000000,
2846 gettext_noop(
"Sets the maximum number of locks per transaction."),
2847 gettext_noop(
"The shared lock table is sized on the assumption that at most "
2848 "\"max_locks_per_transaction\" objects per server process or prepared "
2849 "transaction will need to be locked at any one time.")
2858 gettext_noop(
"Sets the maximum number of predicate locks per transaction."),
2859 gettext_noop(
"The shared predicate lock table is sized on the assumption that "
2860 "at most \"max_pred_locks_per_transaction\" objects per server process "
2861 "or prepared transaction will need to be locked at any one time.")
2870 gettext_noop(
"Sets the maximum number of predicate-locked pages and tuples per relation."),
2871 gettext_noop(
"If more than this total of pages and tuples in the same relation are locked "
2872 "by a connection, those locks are replaced by a relation-level lock.")
2875 -2, INT_MIN, INT_MAX,
2881 gettext_noop(
"Sets the maximum number of predicate-locked tuples per page."),
2882 gettext_noop(
"If more than this number of tuples on the same page are locked "
2883 "by a connection, those locks are replaced by a page-level lock.")
2892 gettext_noop(
"Sets the maximum allowed time to complete client authentication."),
2905 "authentication on connection startup."),
2906 gettext_noop(
"This allows attaching a debugger to the process."),
2916 gettext_noop(
"Sets the maximum number of allocated pages for NOTIFY / LISTEN queue."),
2920 1048576, 64, INT_MAX,
2926 gettext_noop(
"Buffer size for reading ahead in the WAL during recovery."),
2927 gettext_noop(
"Maximum distance to read ahead in the WAL to prefetch referenced data blocks."),
2937 gettext_noop(
"Sets the size of WAL files held for standby servers."),
2948 gettext_noop(
"Sets the minimum size to shrink the WAL to."),
2960 gettext_noop(
"Sets the WAL size that triggers a checkpoint."),
2972 gettext_noop(
"Sets the maximum time between automatic WAL checkpoints."),
2983 gettext_noop(
"Sets the maximum time before warning if checkpoints "
2984 "triggered by WAL volume happen too frequently."),
2985 gettext_noop(
"Write a message to the server log if checkpoints "
2986 "caused by the filling of WAL segment files happen more "
2987 "frequently than this amount of time. "
2988 "0 disables the warning."),
2998 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3009 gettext_noop(
"Sets the number of disk-page buffers in shared memory for WAL."),
3010 gettext_noop(
"-1 means use a fraction of \"shared_buffers\"."),
3014 -1, -1, (INT_MAX / XLOG_BLCKSZ),
3020 gettext_noop(
"Time between WAL flushes performed in the WAL writer."),
3031 gettext_noop(
"Amount of WAL written out by WAL writer that triggers a flush."),
3042 gettext_noop(
"Minimum size of new file to fsync instead of writing WAL."),
3053 gettext_noop(
"Sets the maximum number of simultaneously running WAL sender processes."),
3064 gettext_noop(
"Sets the maximum number of simultaneously defined replication slots."),
3074 gettext_noop(
"Sets the maximum WAL size that can be reserved by replication slots."),
3075 gettext_noop(
"Replication slots will be marked as failed, and segments released "
3076 "for deletion or recycling, if this much space is occupied by WAL on disk. "
3077 "-1 means no maximum."),
3087 gettext_noop(
"Sets the maximum time to wait for WAL replication."),
3092 60 * 1000, 0, INT_MAX,
3098 gettext_noop(
"Sets the duration a replication slot can remain idle before "
3099 "it is invalidated."),
3110 gettext_noop(
"Sets the delay in microseconds between transaction commit and "
3111 "flushing WAL to disk."),
3122 gettext_noop(
"Sets the minimum number of concurrent open transactions "
3123 "required before performing \"commit_delay\"."),
3133 gettext_noop(
"Sets the number of digits displayed for floating-point values."),
3134 gettext_noop(
"This affects real, double precision, and geometric data types. "
3135 "A zero or negative parameter value is added to the standard "
3136 "number of digits (FLT_DIG or DBL_DIG as appropriate). "
3137 "Any value greater than zero selects precise output mode.")
3146 gettext_noop(
"Sets the minimum execution time above which "
3147 "a sample of statements will be logged."
3148 " Sampling is determined by \"log_statement_sample_rate\"."),
3149 gettext_noop(
"-1 disables sampling. 0 means sample all statements."),
3159 gettext_noop(
"Sets the minimum execution time above which "
3160 "all statements will be logged."),
3161 gettext_noop(
"-1 disables logging statement durations. 0 means log all statement durations."),
3171 gettext_noop(
"Sets the minimum execution time above which "
3172 "autovacuum actions will be logged."),
3173 gettext_noop(
"-1 disables logging autovacuum actions. 0 means log all autovacuum actions."),
3177 600000, -1, INT_MAX,
3183 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3184 "parameter values when logging statements."),
3189 -1, -1, INT_MAX / 2,
3195 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3196 "parameter values when logging statements, on error."),
3207 gettext_noop(
"Background writer sleep time between rounds."),
3218 gettext_noop(
"Background writer maximum number of LRU pages to flush per round."),
3222 100, 0, INT_MAX / 2,
3228 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3238 {
"effective_io_concurrency",
3241 gettext_noop(
"Number of simultaneous requests that can be handled efficiently by the disk subsystem."),
3252 {
"maintenance_io_concurrency",
3255 gettext_noop(
"A variant of \"effective_io_concurrency\" that is used for maintenance work."),
3267 {
"io_max_combine_limit",
3270 gettext_noop(
"Server-wide limit that clamps io_combine_limit."),
3281 {
"io_combine_limit",
3284 gettext_noop(
"Limit on the size of data reads and writes."),
3295 {
"io_max_concurrency",
3298 gettext_noop(
"Max number of IOs that one process can execute simultaneously."),
3310 gettext_noop(
"Number of IO worker processes, for io_method=worker."),
3320 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3330 {
"max_worker_processes",
3333 gettext_noop(
"Maximum number of concurrent worker processes."),
3342 {
"max_logical_replication_workers",
3345 gettext_noop(
"Maximum number of logical replication worker processes."),
3354 {
"max_sync_workers_per_subscription",
3357 gettext_noop(
"Maximum number of table synchronization workers per subscription."),
3366 {
"max_parallel_apply_workers_per_subscription",
3369 gettext_noop(
"Maximum number of parallel apply workers per subscription."),
3378 {
"max_active_replication_origins",
3381 gettext_noop(
"Sets the maximum number of active replication origins."),
3391 gettext_noop(
"Sets the amount of time to wait before forcing "
3392 "log file rotation."),
3393 gettext_noop(
"0 disables time-based creation of new log files."),
3403 gettext_noop(
"Sets the maximum size a log file can reach before "
3405 gettext_noop(
"0 disables size-based creation of new log files."),
3409 10 * 1024, 0, INT_MAX,
3415 gettext_noop(
"Shows the maximum number of function arguments."),
3426 gettext_noop(
"Shows the maximum number of index keys."),
3453 BLCKSZ, BLCKSZ, BLCKSZ,
3459 gettext_noop(
"Shows the number of pages per disk file."),
3464 RELSEG_SIZE, RELSEG_SIZE, RELSEG_SIZE,
3470 gettext_noop(
"Shows the block size in the write ahead log."),
3475 XLOG_BLCKSZ, XLOG_BLCKSZ, XLOG_BLCKSZ,
3481 gettext_noop(
"Sets the time to wait before retrying to retrieve WAL "
3482 "after a failed attempt."),
3493 gettext_noop(
"Shows the size of write ahead log segments."),
3506 gettext_noop(
"Time for which WAL summary files should be kept."),
3507 gettext_noop(
"0 disables automatic summary file deletion."),
3519 gettext_noop(
"Time to sleep between autovacuum runs."),
3524 60, 1, INT_MAX / 1000,
3529 gettext_noop(
"Minimum number of tuple updates or deletes prior to vacuum."),
3538 gettext_noop(
"Maximum number of tuple updates or deletes prior to vacuum."),
3542 100000000, -1, INT_MAX,
3547 gettext_noop(
"Minimum number of tuple inserts prior to vacuum."),
3556 gettext_noop(
"Minimum number of tuple inserts, updates, or deletes prior to analyze."),
3566 gettext_noop(
"Age at which to autovacuum a table to prevent transaction ID wraparound."),
3572 200000000, 100000, 2000000000,
3578 gettext_noop(
"Multixact age at which to autovacuum a table to prevent multixact wraparound."),
3582 400000000, 10000, 2000000000,
3588 gettext_noop(
"Sets the number of backend slots to allocate for autovacuum workers."),
3597 gettext_noop(
"Sets the maximum number of simultaneously running autovacuum worker processes."),
3607 gettext_noop(
"Sets the maximum number of parallel processes per maintenance operation."),
3617 gettext_noop(
"Sets the maximum number of parallel processes per executor node."),
3628 gettext_noop(
"Sets the maximum number of parallel workers that can be active at one time."),
3639 gettext_noop(
"Sets the maximum memory to be used by each autovacuum worker process."),
3640 gettext_noop(
"-1 means use \"maintenance_work_mem\"."),
3661 gettext_noop(
"Time between TCP keepalive retransmits."),
3672 gettext_noop(
"SSL renegotiation is no longer supported; this can only be 0."),
3683 gettext_noop(
"Maximum number of TCP keepalive retransmits."),
3684 gettext_noop(
"Number of consecutive keepalive retransmits that can be "
3685 "lost before a connection is considered dead. "
3686 "0 means use the system default."),
3695 gettext_noop(
"Sets the maximum allowed result for exact search by GIN."),
3705 gettext_noop(
"Sets the planner's assumption about the total size of the data caches."),
3706 gettext_noop(
"That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. "
3707 "This is measured in disk pages, which are normally 8 kB each."),
3717 gettext_noop(
"Sets the minimum amount of table data for a parallel scan."),
3718 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."),
3722 (8 * 1024 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3728 gettext_noop(
"Sets the minimum amount of index data for a parallel scan."),
3729 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."),
3733 (512 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3740 gettext_noop(
"Shows the server version as an integer."),
3745 PG_VERSION_NUM, PG_VERSION_NUM, PG_VERSION_NUM,
3751 gettext_noop(
"Log the use of temporary files larger than this number of kilobytes."),
3752 gettext_noop(
"-1 disables logging temporary files. 0 means log all temporary files."),
3762 gettext_noop(
"Sets the size reserved for pg_stat_activity.query, in bytes."),
3773 gettext_noop(
"Sets the maximum size of the pending list for GIN index."),
3795 gettext_noop(
"The size of huge page that should be requested."),
3806 gettext_noop(
"Aggressively flush system caches for debugging purposes."),
3811#ifdef DISCARD_CACHES_ENABLED
3813#if defined(CLOBBER_CACHE_RECURSIVELY)
3815#elif defined(CLOBBER_CACHE_ALWAYS)
3829 gettext_noop(
"Sets the time interval between checks for disconnection while running queries."),
3841 "long-running startup operations."),
3852 gettext_noop(
"Sets the iteration count for SCRAM secret generation."),
3863 {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL, NULL
3872 gettext_noop(
"Sets the planner's estimate of the cost of a "
3873 "sequentially fetched disk page."),
3883 gettext_noop(
"Sets the planner's estimate of the cost of a "
3884 "nonsequentially fetched disk page."),
3894 gettext_noop(
"Sets the planner's estimate of the cost of "
3895 "processing each tuple (row)."),
3905 gettext_noop(
"Sets the planner's estimate of the cost of "
3906 "processing each index entry during an index scan."),
3916 gettext_noop(
"Sets the planner's estimate of the cost of "
3917 "processing each operator or function call."),
3927 gettext_noop(
"Sets the planner's estimate of the cost of "
3928 "passing each tuple (row) from worker to leader backend."),
3938 gettext_noop(
"Sets the planner's estimate of the cost of "
3939 "starting up worker processes for parallel query."),
3950 gettext_noop(
"Perform JIT compilation if query is more expensive."),
3955 100000, -1, DBL_MAX,
3961 gettext_noop(
"Optimize JIT-compiled functions if query is more expensive."),
3966 500000, -1, DBL_MAX,
3972 gettext_noop(
"Perform JIT inlining if query is more expensive."),
3977 500000, -1, DBL_MAX,
3983 gettext_noop(
"Sets the planner's estimate of the fraction of "
3984 "a cursor's rows that will be retrieved."),
3995 gettext_noop(
"Sets the planner's estimate of the average size "
3996 "of a recursive query's working table."),
4007 gettext_noop(
"GEQO: selective pressure within the population."),
4029 gettext_noop(
"Multiple of \"work_mem\" to use for hash tables."),
4040 gettext_noop(
"Multiple of the average buffer usage to free per round."),
4050 gettext_noop(
"Sets the seed for random-number generation."),
4072 gettext_noop(
"Vacuum cost delay in milliseconds, for autovacuum."),
4083 gettext_noop(
"Number of tuple updates or deletes prior to vacuum as a fraction of reltuples."),
4093 gettext_noop(
"Number of tuple inserts prior to vacuum as a fraction of reltuples."),
4103 gettext_noop(
"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."),
4113 gettext_noop(
"Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."),
4123 gettext_noop(
"Fraction of statements exceeding \"log_min_duration_sample\" to be logged."),
4124 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (always log).")
4133 gettext_noop(
"Sets the fraction of transactions from which to log all statements."),
4134 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (log all "
4135 "statements for all transactions).")
4144 gettext_noop(
"Fraction of pages in a relation vacuum can scan and fail to freeze before disabling eager scanning."),
4145 gettext_noop(
"A value of 0.0 disables eager scanning and a value of 1.0 will eagerly scan up to 100 percent of the all-visible pages in the relation. If vacuum successfully freezes these pages, the cap is lower than 100 percent, because the goal is to amortize page freezing across multiple vacuums.")
4154 {NULL, 0, 0, NULL, NULL}, NULL, 0.0, 0.0, 0.0, NULL, NULL, NULL
4163 gettext_noop(
"Sets the shell command that will be called to archive a WAL file."),
4164 gettext_noop(
"An empty string means use \"archive_library\".")
4173 gettext_noop(
"Sets the library that will be called to archive a WAL file."),
4174 gettext_noop(
"An empty string means use \"archive_command\".")
4183 gettext_noop(
"Sets the shell command that will be called to retrieve an archived WAL file."),
4193 gettext_noop(
"Sets the shell command that will be executed at every restart point."),
4203 gettext_noop(
"Sets the shell command that will be executed once at the end of recovery."),
4213 gettext_noop(
"Specifies the timeline to recover into."),
4223 gettext_noop(
"Set to \"immediate\" to end recovery as soon as a consistent state is reached."),
4232 gettext_noop(
"Sets the transaction ID up to which recovery will proceed."),
4241 gettext_noop(
"Sets the time stamp up to which recovery will proceed."),
4250 gettext_noop(
"Sets the named restore point up to which recovery will proceed."),
4259 gettext_noop(
"Sets the LSN of the write-ahead log location up to which recovery will proceed."),
4269 gettext_noop(
"Sets the connection string to be used to connect to the sending server."),
4280 gettext_noop(
"Sets the name of the replication slot to use on the sending server."),
4290 gettext_noop(
"Sets the client's character set encoding."),
4301 gettext_noop(
"Controls information prefixed to each log line."),
4311 gettext_noop(
"Sets the time zone to use in log messages."),
4321 gettext_noop(
"Sets the display format for date and time values."),
4322 gettext_noop(
"Also controls interpretation of ambiguous "
4333 gettext_noop(
"Sets the default table access method for new tables."),
4344 gettext_noop(
"Sets the default tablespace to create tables and indexes in."),
4345 gettext_noop(
"An empty string means use the database's default tablespace."),
4355 gettext_noop(
"Sets the tablespace(s) to use for temporary tables and sort files."),
4356 gettext_noop(
"An empty string means use the database's default tablespace."),
4366 gettext_noop(
"Sets whether a CREATEROLE user automatically grants "
4367 "the role to themselves, and with which options."),
4368 gettext_noop(
"An empty string disables automatic self grants."),
4378 gettext_noop(
"Sets the path for dynamically loadable modules."),
4379 gettext_noop(
"If a dynamically loadable module needs to be opened and "
4380 "the specified name does not have a directory component (i.e., the "
4381 "name does not contain a slash), the system will search this path for "
4382 "the specified file."),
4392 gettext_noop(
"Sets the path for extension control files."),
4393 gettext_noop(
"The remaining extension script and secondary control files are then loaded "
4394 "from the same directory where the primary control file was found."),
4404 gettext_noop(
"Sets the location of the Kerberos server key file."),
4416 gettext_noop(
"An empty string means use the computer name.")
4425 gettext_noop(
"Sets the language in which messages are displayed."),
4426 gettext_noop(
"An empty string means use the operating system setting.")
4435 gettext_noop(
"Sets the locale for formatting monetary amounts."),
4436 gettext_noop(
"An empty string means use the operating system setting.")
4445 gettext_noop(
"Sets the locale for formatting numbers."),
4446 gettext_noop(
"An empty string means use the operating system setting.")
4455 gettext_noop(
"Sets the locale for formatting date and time values."),
4456 gettext_noop(
"An empty string means use the operating system setting.")
4465 gettext_noop(
"Lists shared libraries to preload into each backend."),
4476 gettext_noop(
"Lists shared libraries to preload into server."),
4487 gettext_noop(
"Lists unprivileged shared libraries to preload into each backend."),
4498 gettext_noop(
"Sets the schema search order for names that are not schema-qualified."),
4503 "\"$user\", public",
4510 gettext_noop(
"Shows the server (database) character set encoding."),
4557 gettext_noop(
"Sets the destination for server log output."),
4558 gettext_noop(
"Valid values are combinations of \"stderr\", "
4559 "\"syslog\", \"csvlog\", \"jsonlog\", and \"eventlog\", "
4560 "depending on the platform."),
4569 gettext_noop(
"Sets the destination directory for log files."),
4570 gettext_noop(
"Can be specified as relative to the data directory "
4571 "or as absolute path."),
4580 gettext_noop(
"Sets the file name pattern for log files."),
4585 "postgresql-%Y-%m-%d_%H%M%S.log",
4591 gettext_noop(
"Sets the program name used to identify PostgreSQL "
4592 "messages in syslog."),
4602 gettext_noop(
"Sets the application name used to identify "
4603 "PostgreSQL messages in the event log."),
4613 gettext_noop(
"Sets the time zone for displaying and interpreting time stamps."),
4623 gettext_noop(
"Selects a file of time zone abbreviations."),
4633 gettext_noop(
"Sets the owning group of the Unix-domain socket."),
4634 gettext_noop(
"The owning user of the socket is always the user that starts the server. "
4635 "An empty string means use the user's default group.")
4644 gettext_noop(
"Sets the directories where Unix-domain sockets will be created."),
4655 gettext_noop(
"Sets the host name or IP address(es) to listen to."),
4681 gettext_noop(
"Sets the server's main configuration file."),
4692 gettext_noop(
"Sets the server's \"hba\" configuration file."),
4703 gettext_noop(
"Sets the server's \"ident\" configuration file."),
4714 gettext_noop(
"Writes the postmaster PID to the specified file."),
4740 gettext_noop(
"Location of the SSL server certificate file."),
4750 gettext_noop(
"Location of the SSL server private key file."),
4760 gettext_noop(
"Location of the SSL certificate authority file."),
4770 gettext_noop(
"Location of the SSL certificate revocation list file."),
4780 gettext_noop(
"Location of the SSL certificate revocation list directory."),
4790 gettext_noop(
"Number of synchronous standbys and list of names of potential synchronous ones."),
4801 gettext_noop(
"Sets default text search configuration."),
4805 "pg_catalog.simple",
4811 gettext_noop(
"Sets the list of allowed TLSv1.3 cipher suites."),
4812 gettext_noop(
"An empty string means use the default cipher suites."),
4822 gettext_noop(
"Sets the list of allowed TLSv1.2 (and lower) ciphers."),
4828 "HIGH:MEDIUM:+3DES:!aNULL",
4837 gettext_noop(
"Sets the group(s) to use for Diffie-Hellman key exchange."),
4838 gettext_noop(
"Multiple groups can be specified using colon-separated list."),
4843 "X25519:prime256v1",
4852 gettext_noop(
"Location of the SSL DH parameters file."),
4853 gettext_noop(
"An empty string means use compiled-in default parameters."),
4863 gettext_noop(
"Command to obtain passphrases for SSL."),
4864 gettext_noop(
"An empty string means use the built-in prompting mechanism."),
4874 gettext_noop(
"Sets the application name to be reported in statistics and logs."),
4885 gettext_noop(
"Sets the name of the cluster, which is included in the process title."),
4896 gettext_noop(
"Sets the WAL resource managers for which WAL consistency checks are done."),
4897 gettext_noop(
"Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay."),
4918 gettext_noop(
"Log backtrace for errors in these functions."),
4940 gettext_noop(
"Lists streaming replication standby server replication slot "
4941 "names that logical WAL sender processes will wait for."),
4942 gettext_noop(
"Logical WAL sender processes will send decoded "
4943 "changes to output plugins only after the specified "
4944 "replication slots have confirmed receiving WAL."),
4954 gettext_noop(
"Prohibits access to non-system relations of specified kinds."),
4965 gettext_noop(
"Lists libraries that may be called to validate OAuth v2 bearer tokens."),
4976 gettext_noop(
"Logs specified aspects of connection establishment and setup."),
4988 {NULL, 0, 0, NULL, NULL}, NULL, NULL, NULL, NULL, NULL
4997 gettext_noop(
"Sets whether \"\\'\" is allowed in string literals."),
5017 gettext_noop(
"Sets the message levels that are sent to the client."),
5018 gettext_noop(
"Each level includes all the levels that follow it. The later"
5019 " the level, the fewer messages are sent.")
5028 gettext_noop(
"Enables in-core computation of query identifiers."),
5038 gettext_noop(
"Enables the planner to use constraints to optimize queries."),
5039 gettext_noop(
"Table scans will be skipped if their constraints"
5040 " guarantee that no rows match the query."),
5050 gettext_noop(
"Sets the default compression method for compressible values."),
5061 gettext_noop(
"Sets the transaction isolation level of each new transaction."),
5071 gettext_noop(
"Sets the current transaction's isolation level."),
5082 gettext_noop(
"Sets the display format for interval values."),
5093 gettext_noop(
"Log level for reporting invalid ICU locale strings."),
5103 gettext_noop(
"Sets the verbosity of logged messages."),
5113 gettext_noop(
"Sets the message levels that are logged."),
5114 gettext_noop(
"Each level includes all the levels that follow it. The later"
5115 " the level, the fewer messages are sent.")
5124 gettext_noop(
"Causes all statements generating error at or above this level to be logged."),
5125 gettext_noop(
"Each level includes all the levels that follow it. The later"
5126 " the level, the fewer messages are sent.")
5145 gettext_noop(
"Sets the syslog \"facility\" to be used when syslog enabled."),
5156 gettext_noop(
"Sets the session's behavior for triggers and rewrite rules."),
5166 gettext_noop(
"Sets the current transaction's synchronization level."),
5176 gettext_noop(
"Allows archiving of WAL files using \"archive_command\"."),
5186 gettext_noop(
"Sets the action to perform upon reaching the recovery target."),
5196 gettext_noop(
"Collects function-level statistics on database activity."),
5207 gettext_noop(
"Sets the consistency of accesses to statistics data."),
5217 gettext_noop(
"Compresses full-page writes written in WAL file with specified method."),
5227 gettext_noop(
"Sets the level of information written to the WAL."),
5237 gettext_noop(
"Selects the dynamic shared memory implementation used."),
5247 gettext_noop(
"Selects the shared memory implementation used for the main shared memory region."),
5257 gettext_noop(
"Selects the method used for forcing WAL updates to disk."),
5267 gettext_noop(
"Sets how binary values are to be encoded in XML."),
5277 gettext_noop(
"Sets whether XML data in implicit parsing and serialization "
5278 "operations is to be considered as documents or content fragments."),
5288 gettext_noop(
"Use of huge pages on Linux or Windows."),
5309 gettext_noop(
"Prefetch referenced blocks during recovery."),
5310 gettext_noop(
"Look ahead in the WAL to find references to uncached data.")
5319 gettext_noop(
"Forces the planner's use parallel query nodes."),
5320 gettext_noop(
"This can be useful for testing the parallel query infrastructure "
5321 "by forcing the planner to generate plans that contain nodes "
5322 "that perform tuple communication between workers and the main process."),
5332 gettext_noop(
"Chooses the algorithm for encrypting passwords."),
5342 gettext_noop(
"Controls the planner's selection of custom or generic plan."),
5343 gettext_noop(
"Prepared statements can have custom and generic plans, and the planner "
5344 "will attempt to choose which is better. This can be set to override "
5345 "the default behavior."),
5355 gettext_noop(
"Sets the minimum SSL/TLS protocol version to use."),
5367 gettext_noop(
"Sets the maximum SSL/TLS protocol version to use."),
5379 gettext_noop(
"Sets the method for synchronizing the data directory before crash recovery."),
5388 gettext_noop(
"Forces immediate streaming or serialization of changes in large transactions."),
5389 gettext_noop(
"On the publisher, it allows streaming or serializing each change in logical decoding. "
5390 "On the subscriber, it allows serialization of all changes to files and notifies the "
5391 "parallel apply workers to read and apply them at the end of the transaction."),
5401 gettext_noop(
"Selects the method for executing asynchronous I/O."),
5411 {NULL, 0, 0, NULL, NULL}, NULL, 0, NULL, NULL, NULL, NULL
void assign_io_method(int newval, void *extra)
const struct config_enum_entry io_method_options[]
bool check_io_max_concurrency(int *newval, void **extra, GucSource source)
#define DEFAULT_IO_METHOD
int min_parallel_index_scan_size
int min_parallel_table_scan_size
bool enable_self_join_elimination
int max_notify_queue_pages
bool check_notify_buffers(int *newval, void **extra, GucSource source)
char * oauth_validator_libraries_string
int scram_sha_256_iterations
char * pg_krb_server_keyfile
bool pg_krb_caseins_users
bool pg_gss_accept_delegation
int autovacuum_worker_slots
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
int autovacuum_vac_max_thresh
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)
void assign_io_combine_limit(int newval, void *extra)
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)
void assign_io_max_combine_limit(int newval, void *extra)
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 check_log_connections(char **newval, void **extra, GucSource source)
bool Trace_connection_negotiation
char * log_connections_string
void assign_log_connections(const char *newval, void *extra)
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)
char * Extension_control_path
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
@ RESOURCES_WORKER_PROCESSES
@ 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)
int max_active_replication_origins
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
bool query_id_squash_values
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)
int idle_replication_slot_timeout_mins
bool check_synchronized_standby_slots(char **newval, void **extra, GucSource source)
int max_replication_slots
bool check_idle_replication_slot_timeout(int *newval, void **extra, GucSource source)
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
double vacuum_max_eager_freeze_failure_rate
bool track_cost_delay_timing
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