118 #ifndef PG_KRB_SRVTAB
119 #define PG_KRB_SRVTAB ""
122 #define CONFIG_FILENAME "postgresql.conf"
123 #define HBA_FILENAME "pg_hba.conf"
124 #define IDENT_FILENAME "pg_ident.conf"
127 #define CONFIG_EXEC_PARAMS "global/config_exec_params"
128 #define CONFIG_EXEC_PARAMS_NEW "global/config_exec_params.new"
135 #define REALTYPE_PRECISION 17
147 #ifdef TRACE_SYNCSCAN
148 extern bool trace_syncscan;
150 #ifdef DEBUG_BOUNDED_SORT
151 extern bool optimize_bounded_sort;
248 bool applySettings,
int elevel);
269 "array length mismatch");
277 {
"debug5",
DEBUG5,
false},
278 {
"debug4",
DEBUG4,
false},
279 {
"debug3",
DEBUG3,
false},
280 {
"debug2",
DEBUG2,
false},
281 {
"debug1",
DEBUG1,
false},
284 {
"info",
INFO,
true},
285 {
"notice",
NOTICE,
false},
287 {
"error",
ERROR,
false},
292 {
"debug5",
DEBUG5,
false},
293 {
"debug4",
DEBUG4,
false},
294 {
"debug3",
DEBUG3,
false},
295 {
"debug2",
DEBUG2,
false},
296 {
"debug1",
DEBUG1,
false},
298 {
"info",
INFO,
false},
299 {
"notice",
NOTICE,
false},
301 {
"error",
ERROR,
false},
303 {
"fatal",
FATAL,
false},
304 {
"panic",
PANIC,
false},
317 "array length mismatch");
327 "array length mismatch");
338 "array length mismatch");
356 "array length mismatch");
360 {
"local0", LOG_LOCAL0,
false},
361 {
"local1", LOG_LOCAL1,
false},
362 {
"local2", LOG_LOCAL2,
false},
363 {
"local3", LOG_LOCAL3,
false},
364 {
"local4", LOG_LOCAL4,
false},
365 {
"local5", LOG_LOCAL5,
false},
366 {
"local6", LOG_LOCAL6,
false},
367 {
"local7", LOG_LOCAL7,
false},
382 "array length mismatch");
392 "array length mismatch");
401 "array length mismatch");
410 "array length mismatch");
549 "array length mismatch");
742 "array length mismatch");
753 "environment variable",
754 "configuration file",
768 "array length mismatch");
780 gettext_noop(
"Connections and Authentication / Connection Settings"),
782 gettext_noop(
"Connections and Authentication / Authentication"),
792 gettext_noop(
"Resource Usage / Cost-Based Vacuum Delay"),
818 gettext_noop(
"Query Tuning / Planner Method Configuration"),
836 gettext_noop(
"Statistics / Cumulative Query and Index Statistics"),
840 gettext_noop(
"Client Connection Defaults / Statement Behavior"),
842 gettext_noop(
"Client Connection Defaults / Locale and Formatting"),
844 gettext_noop(
"Client Connection Defaults / Shared Library Preloading"),
846 gettext_noop(
"Client Connection Defaults / Other Defaults"),
850 gettext_noop(
"Version and Platform Compatibility / Previous PostgreSQL Versions"),
852 gettext_noop(
"Version and Platform Compatibility / Other Platforms and Clients"),
866 "array length mismatch");
883 "array length mismatch");
900 #define MAX_UNIT_LEN 3
911 #if BLCKSZ < 1024 || BLCKSZ > (1024*1024)
912 #error BLCKSZ must be between 1KB and 1MB
914 #if XLOG_BLCKSZ < 1024 || XLOG_BLCKSZ > (1024*1024)
915 #error XLOG_BLCKSZ must be between 1KB and 1MB
946 {
"TB",
GUC_UNIT_XBLOCKS, (1024.0 * 1024.0 * 1024.0) / (XLOG_BLCKSZ / 1024)},
1017 gettext_noop(
"Enables the planner's use of sequential-scan plans."),
1027 gettext_noop(
"Enables the planner's use of index-scan plans."),
1037 gettext_noop(
"Enables the planner's use of index-only-scan plans."),
1047 gettext_noop(
"Enables the planner's use of bitmap-scan plans."),
1057 gettext_noop(
"Enables the planner's use of TID scan plans."),
1067 gettext_noop(
"Enables the planner's use of explicit sort steps."),
1077 gettext_noop(
"Enables the planner's use of incremental sort steps."),
1087 gettext_noop(
"Enables the planner's use of hashed aggregation plans."),
1097 gettext_noop(
"Enables the planner's use of materialization."),
1107 gettext_noop(
"Enables the planner's use of memoization."),
1117 gettext_noop(
"Enables the planner's use of nested-loop join plans."),
1127 gettext_noop(
"Enables the planner's use of merge join plans."),
1137 gettext_noop(
"Enables the planner's use of hash join plans."),
1147 gettext_noop(
"Enables the planner's use of gather merge plans."),
1167 gettext_noop(
"Enables partitionwise aggregation and grouping."),
1177 gettext_noop(
"Enables the planner's use of parallel append plans."),
1187 gettext_noop(
"Enables the planner's use of parallel hash plans."),
1197 gettext_noop(
"Enables plan-time and execution-time partition pruning."),
1198 gettext_noop(
"Allows the query planner and executor to compare partition "
1199 "bounds to conditions in the query to determine which "
1200 "partitions must be scanned."),
1209 gettext_noop(
"Enables the planner's use of async append plans."),
1230 gettext_noop(
"This algorithm attempts to do planning without "
1231 "exhaustive searching."),
1241 gettext_noop(
"Shows whether the current user is a superuser."),
1251 gettext_noop(
"Enables advertising the server via Bonjour."),
1278 gettext_noop(
"Controls whether ssl_passphrase_command is called during server reload."),
1287 gettext_noop(
"Give priority to server ciphersuite order."),
1296 gettext_noop(
"Forces synchronization of updates to disk."),
1297 gettext_noop(
"The server will use the fsync() system call in several places to make "
1298 "sure that updates are physically written to disk. This insures "
1299 "that a database cluster will recover to a consistent state after "
1300 "an operating system or hardware crash.")
1308 gettext_noop(
"Continues processing after a checksum failure."),
1309 gettext_noop(
"Detection of a checksum failure normally causes PostgreSQL to "
1310 "report an error, aborting the current transaction. Setting "
1311 "ignore_checksum_failure to true causes the system to ignore the failure "
1312 "(but still report a warning), and continue processing. This "
1313 "behavior could cause crashes or other serious problems. Only "
1314 "has an effect if checksums are enabled."),
1323 gettext_noop(
"Continues processing past damaged page headers."),
1324 gettext_noop(
"Detection of a damaged page header normally causes PostgreSQL to "
1325 "report an error, aborting the current transaction. Setting "
1326 "zero_damaged_pages to true causes the system to instead report a "
1327 "warning, zero out the damaged page, and continue processing. This "
1328 "behavior will destroy data, namely all the rows on the damaged page."),
1337 gettext_noop(
"Continues recovery after an invalid pages failure."),
1338 gettext_noop(
"Detection of WAL records having references to "
1339 "invalid pages during recovery causes PostgreSQL to "
1340 "raise a PANIC-level error, aborting the recovery. "
1341 "Setting ignore_invalid_pages to true causes "
1342 "the system to ignore invalid page references "
1343 "in WAL records (but still report a warning), "
1344 "and continue recovery. This behavior may cause "
1345 "crashes, data loss, propagate or hide corruption, "
1346 "or other serious problems. Only has an effect "
1347 "during recovery or in standby mode."),
1356 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint."),
1357 gettext_noop(
"A page write in process during an operating system crash might be "
1358 "only partially written to disk. During recovery, the row changes "
1359 "stored in WAL are not enough to recover. This option writes "
1360 "pages when first modified after a checkpoint to WAL so full recovery "
1370 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification."),
1380 gettext_noop(
"Writes zeroes to new WAL files before first use."),
1418 gettext_noop(
"Logs end of a session, including duration."),
1436 gettext_noop(
"Shows whether the running server has assertion checks enabled."),
1441 #ifdef USE_ASSERT_CHECKING
1460 gettext_noop(
"Reinitialize server after backend crash."),
1469 gettext_noop(
"Remove temporary files after backend crash."),
1480 gettext_noop(
"Logs the duration of each completed SQL statement."),
1498 gettext_noop(
"Logs each query's rewritten parse tree."),
1525 gettext_noop(
"Writes parser performance statistics to the server log."),
1534 gettext_noop(
"Writes planner performance statistics to the server log."),
1543 gettext_noop(
"Writes executor performance statistics to the server log."),
1552 gettext_noop(
"Writes cumulative performance statistics to the server log."),
1559 #ifdef BTREE_BUILD_STATS
1562 gettext_noop(
"Logs system resource usage statistics (memory and CPU) on various B-tree operations."),
1574 gettext_noop(
"Collects information about executing commands."),
1575 gettext_noop(
"Enables the collection of information on the currently "
1576 "executing command of each session, along with "
1577 "the time at which that command began execution.")
1585 gettext_noop(
"Collects statistics on database activity."),
1594 gettext_noop(
"Collects timing statistics for database I/O activity."),
1603 gettext_noop(
"Collects timing statistics for WAL I/O activity."),
1613 gettext_noop(
"Updates the process title to show the active SQL command."),
1614 gettext_noop(
"Enables updating of the process title every time a new SQL command is received by the server.")
1637 gettext_noop(
"Generates debugging output for LISTEN and NOTIFY."),
1659 gettext_noop(
"Emits information about user lock usage."),
1669 gettext_noop(
"Emits information about lightweight lock usage."),
1679 gettext_noop(
"Dumps information about all current locks when a deadlock timeout occurs."),
1709 gettext_noop(
"Logs the host name in the connection logs."),
1710 gettext_noop(
"By default, connection logs only show the IP address "
1711 "of the connecting host. If you want them to show the host name you "
1712 "can turn this on, but depending on your host name resolution "
1713 "setup it might impose a non-negligible performance penalty.")
1721 gettext_noop(
"Treats \"expr=NULL\" as \"expr IS NULL\"."),
1722 gettext_noop(
"When turned on, expressions of the form expr = NULL "
1723 "(or NULL = expr) are treated as expr IS NULL, that is, they "
1724 "return true if expr evaluates to the null value, and false "
1725 "otherwise. The correct behavior of expr = NULL is to always "
1726 "return null (unknown).")
1743 gettext_noop(
"Sets the default read-only status of new transactions."),
1753 gettext_noop(
"Sets the current transaction's read-only status."),
1763 gettext_noop(
"Sets the default deferrable status of new transactions."),
1772 gettext_noop(
"Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures."),
1783 gettext_noop(
"When enabled, row security will be applied to all users.")
1791 gettext_noop(
"Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE."),
1800 gettext_noop(
"Enable input of NULL elements in arrays."),
1801 gettext_noop(
"When turned on, unquoted NULL in an array input "
1802 "value means a null value; "
1803 "otherwise it is taken literally.")
1817 gettext_noop(
"WITH OIDS is no longer supported; this can only be false."),
1827 gettext_noop(
"Start a subprocess to capture stderr output and/or csvlogs into log files."),
1836 gettext_noop(
"Truncate existing log files of same name during log rotation."),
1847 gettext_noop(
"Emit information about resource usage in sorting."),
1857 #ifdef TRACE_SYNCSCAN
1861 gettext_noop(
"Generate debugging output for synchronized scanning."),
1871 #ifdef DEBUG_BOUNDED_SORT
1876 gettext_noop(
"Enable bounded sorting using heap sort."),
1880 &optimize_bounded_sort,
1901 gettext_noop(
"Shows whether datetimes are integer based."),
1912 gettext_noop(
"Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive."),
1922 gettext_noop(
"Warn about backslash escapes in ordinary string literals."),
1932 gettext_noop(
"Causes '...' strings to treat backslashes literally."),
1953 gettext_noop(
"Sets whether to include or exclude transaction with recovery target."),
1963 gettext_noop(
"Allows connections and queries during recovery."),
1973 gettext_noop(
"Allows feedback from a hot standby to the primary that will avoid query conflicts."),
1983 gettext_noop(
"Shows whether hot standby is currently active."),
1994 gettext_noop(
"Allows modifications of the structure of system tables."),
2006 gettext_noop(
"It does not prevent updating the indexes, so it is safe "
2007 "to use. The worst consequence is slowness."),
2017 gettext_noop(
"Allows tablespaces directly inside pg_tblspc, for testing."),
2028 gettext_noop(
"Enables backward compatibility mode for privilege checks on large objects."),
2029 gettext_noop(
"Skips privilege checks when reading or modifying large objects, "
2030 "for compatibility with PostgreSQL releases prior to 9.0.")
2039 gettext_noop(
"When generating SQL fragments, quote all identifiers."),
2049 gettext_noop(
"Shows whether data checksums are turned on for this cluster."),
2060 gettext_noop(
"Add sequence number to syslog messages to avoid duplicate suppression."),
2070 gettext_noop(
"Split messages sent to syslog by lines and to fit into 1024 bytes."),
2080 gettext_noop(
"Controls whether Gather and Gather Merge also run subplans."),
2081 gettext_noop(
"Should gather nodes also run subplans or just gather tuples?"),
2102 gettext_noop(
"Register JIT-compiled functions with debugger."),
2119 gettext_noop(
"Write out LLVM bitcode to facilitate JIT debugging."),
2141 gettext_noop(
"Register JIT-compiled functions with perf profiler."),
2158 gettext_noop(
"Allow JIT compilation of tuple deforming."),
2169 gettext_noop(
"Whether to continue running after a failure to sync data files."),
2178 gettext_noop(
"Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured."),
2187 {NULL, 0, 0, NULL, NULL}, NULL,
false, NULL, NULL, NULL
2196 gettext_noop(
"Sets the amount of time to wait before forcing a "
2197 "switch to the next WAL file."),
2208 "authentication on connection startup."),
2209 gettext_noop(
"This allows attaching a debugger to the process."),
2213 0, 0, INT_MAX / 1000000,
2219 gettext_noop(
"This applies to table columns that have not had a "
2220 "column-specific target set via ALTER TABLE SET STATISTICS.")
2228 gettext_noop(
"Sets the FROM-list size beyond which subqueries "
2229 "are not collapsed."),
2230 gettext_noop(
"The planner will merge subqueries into upper "
2231 "queries if the resulting FROM list would have no more than "
2232 "this many items."),
2241 gettext_noop(
"Sets the FROM-list size beyond which JOIN "
2242 "constructs are not flattened."),
2244 "constructs into lists of FROM items whenever a "
2245 "list of no more than this many items would result."),
2254 gettext_noop(
"Sets the threshold of FROM items beyond which GEQO is used."),
2264 gettext_noop(
"GEQO: effort is used to set the default for other GEQO parameters."),
2274 gettext_noop(
"GEQO: number of individuals in the population."),
2275 gettext_noop(
"Zero selects a suitable default value."),
2284 gettext_noop(
"GEQO: number of iterations of the algorithm."),
2285 gettext_noop(
"Zero selects a suitable default value."),
2296 gettext_noop(
"Sets the time to wait on a lock before checking for deadlock."),
2307 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data."),
2312 30 * 1000, -1, INT_MAX,
2318 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data."),
2323 30 * 1000, -1, INT_MAX,
2329 gettext_noop(
"Sets the minimum delay for applying changes during recovery."),
2340 gettext_noop(
"Sets the maximum interval between WAL receiver status reports to the sending server."),
2345 10, 0, INT_MAX / 1000,
2351 gettext_noop(
"Sets the maximum wait time to receive data from the sending server."),
2356 60 * 1000, 0, INT_MAX,
2362 gettext_noop(
"Sets the maximum number of concurrent connections."),
2373 gettext_noop(
"Sets the number of connection slots reserved for superusers."),
2383 gettext_noop(
"Amount of dynamic shared memory reserved at startup."),
2388 0, 0, (int)
Min((
size_t) INT_MAX, SIZE_MAX / (1024 * 1024)),
2398 gettext_noop(
"Sets the number of shared memory buffers used by the server."),
2403 16384, 16, INT_MAX / 2,
2409 gettext_noop(
"Shows the size of the server's main shared memory area (rounded up to the nearest MB)."),
2420 gettext_noop(
"Shows the number of huge pages needed for the main shared memory area."),
2421 gettext_noop(
"-1 indicates that the value could not be determined."),
2431 gettext_noop(
"Sets the maximum number of temporary buffers used by each session."),
2436 1024, 100, INT_MAX / 2,
2442 gettext_noop(
"Sets the TCP port the server listens on."),
2446 DEF_PGPORT, 1, 65535,
2452 gettext_noop(
"Sets the access permissions of the Unix-domain socket."),
2453 gettext_noop(
"Unix-domain sockets use the usual Unix file system "
2454 "permission set. The parameter value is expected "
2455 "to be a numeric mode specification in the form "
2456 "accepted by the chmod and umask system calls. "
2457 "(To use the customary octal format the number must "
2458 "start with a 0 (zero).)")
2467 gettext_noop(
"Sets the file permissions for log files."),
2469 "to be a numeric mode specification in the form "
2470 "accepted by the chmod and umask system calls. "
2471 "(To use the customary octal format the number must "
2472 "start with a 0 (zero).)")
2483 gettext_noop(
"The parameter value is a numeric mode specification "
2484 "in the form accepted by the chmod and umask system "
2485 "calls. (To use the customary octal format the number "
2486 "must start with a 0 (zero).)"),
2496 gettext_noop(
"Sets the maximum memory to be used for query workspaces."),
2497 gettext_noop(
"This much memory can be used by each internal "
2498 "sort operation and hash table before switching to "
2499 "temporary disk files."),
2509 gettext_noop(
"Sets the maximum memory to be used for maintenance operations."),
2510 gettext_noop(
"This includes operations such as VACUUM and CREATE INDEX."),
2520 gettext_noop(
"Sets the maximum memory to be used for logical decoding."),
2521 gettext_noop(
"This much memory can be used by each internal "
2522 "reorder buffer before spilling to disk."),
2537 gettext_noop(
"Sets the maximum stack depth, in kilobytes."),
2548 gettext_noop(
"Limits the total size of all temporary files used by each process."),
2559 gettext_noop(
"Vacuum cost for a page found in the buffer cache."),
2569 gettext_noop(
"Vacuum cost for a page not found in the buffer cache."),
2579 gettext_noop(
"Vacuum cost for a page dirtied by vacuum."),
2589 gettext_noop(
"Vacuum cost amount available before napping."),
2599 gettext_noop(
"Vacuum cost amount available before napping, for autovacuum."),
2609 gettext_noop(
"Sets the maximum number of simultaneously open files for each server process."),
2622 gettext_noop(
"Sets the maximum number of simultaneously prepared transactions."),
2633 gettext_noop(
"Sets the minimum OID of tables for tracking locks."),
2634 gettext_noop(
"Is used to avoid output on system tables."),
2643 gettext_noop(
"Sets the OID of the table with unconditionally lock tracing."),
2655 gettext_noop(
"Sets the maximum allowed duration of any statement."),
2666 gettext_noop(
"Sets the maximum allowed duration of any wait for a lock."),
2677 gettext_noop(
"Sets the maximum allowed idle time between queries, when in a transaction."),
2688 gettext_noop(
"Sets the maximum allowed idle time between queries, when not in a transaction."),
2699 gettext_noop(
"Minimum age at which VACUUM should freeze a table row."),
2703 50000000, 0, 1000000000,
2709 gettext_noop(
"Age at which VACUUM should scan whole table to freeze tuples."),
2713 150000000, 0, 2000000000,
2719 gettext_noop(
"Minimum age at which VACUUM should freeze a MultiXactId in a table row."),
2723 5000000, 0, 1000000000,
2729 gettext_noop(
"Multixact age at which VACUUM should scan whole table to freeze tuples."),
2733 150000000, 0, 2000000000,
2739 gettext_noop(
"Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."),
2748 gettext_noop(
"Age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2752 1600000000, 0, 2100000000,
2757 gettext_noop(
"Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage."),
2761 1600000000, 0, 2100000000,
2770 gettext_noop(
"Sets the maximum number of locks per transaction."),
2771 gettext_noop(
"The shared lock table is sized on the assumption that "
2772 "at most max_locks_per_transaction * max_connections distinct "
2773 "objects will need to be locked at any one time.")
2782 gettext_noop(
"Sets the maximum number of predicate locks per transaction."),
2783 gettext_noop(
"The shared predicate lock table is sized on the assumption that "
2784 "at most max_pred_locks_per_transaction * max_connections distinct "
2785 "objects will need to be locked at any one time.")
2794 gettext_noop(
"Sets the maximum number of predicate-locked pages and tuples per relation."),
2795 gettext_noop(
"If more than this total of pages and tuples in the same relation are locked "
2796 "by a connection, those locks are replaced by a relation-level lock.")
2799 -2, INT_MIN, INT_MAX,
2805 gettext_noop(
"Sets the maximum number of predicate-locked tuples per page."),
2806 gettext_noop(
"If more than this number of tuples on the same page are locked "
2807 "by a connection, those locks are replaced by a page-level lock.")
2816 gettext_noop(
"Sets the maximum allowed time to complete client authentication."),
2829 "authentication on connection startup."),
2830 gettext_noop(
"This allows attaching a debugger to the process."),
2840 gettext_noop(
"Maximum buffer size for reading ahead in the WAL during recovery."),
2841 gettext_noop(
"This controls the maximum distance we can read ahead in the WAL to prefetch referenced blocks."),
2851 gettext_noop(
"Sets the size of WAL files held for standby servers."),
2862 gettext_noop(
"Sets the minimum size to shrink the WAL to."),
2874 gettext_noop(
"Sets the WAL size that triggers a checkpoint."),
2886 gettext_noop(
"Sets the maximum time between automatic WAL checkpoints."),
2897 gettext_noop(
"Sets the maximum time before warning if checkpoints "
2898 "triggered by WAL volume happen too frequently."),
2899 gettext_noop(
"Write a message to the server log if checkpoints "
2900 "caused by the filling of WAL segment files happen more "
2901 "frequently than this amount of time. "
2902 "Zero turns off the warning."),
2912 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
2923 gettext_noop(
"Sets the number of disk-page buffers in shared memory for WAL."),
2928 -1, -1, (INT_MAX / XLOG_BLCKSZ),
2934 gettext_noop(
"Time between WAL flushes performed in the WAL writer."),
2945 gettext_noop(
"Amount of WAL written out by WAL writer that triggers a flush."),
2950 (1024 * 1024) / XLOG_BLCKSZ, 0, INT_MAX,
2956 gettext_noop(
"Minimum size of new file to fsync instead of writing WAL."),
2967 gettext_noop(
"Sets the maximum number of simultaneously running WAL sender processes."),
2978 gettext_noop(
"Sets the maximum number of simultaneously defined replication slots."),
2988 gettext_noop(
"Sets the maximum WAL size that can be reserved by replication slots."),
2989 gettext_noop(
"Replication slots will be marked as failed, and segments released "
2990 "for deletion or recycling, if this much space is occupied by WAL "
3001 gettext_noop(
"Sets the maximum time to wait for WAL replication."),
3006 60 * 1000, 0, INT_MAX,
3012 gettext_noop(
"Sets the delay in microseconds between transaction commit and "
3013 "flushing WAL to disk."),
3024 gettext_noop(
"Sets the minimum number of concurrent open transactions "
3025 "required before performing commit_delay."),
3035 gettext_noop(
"Sets the number of digits displayed for floating-point values."),
3036 gettext_noop(
"This affects real, double precision, and geometric data types. "
3037 "A zero or negative parameter value is added to the standard "
3038 "number of digits (FLT_DIG or DBL_DIG as appropriate). "
3039 "Any value greater than zero selects precise output mode.")
3048 gettext_noop(
"Sets the minimum execution time above which "
3049 "a sample of statements will be logged."
3050 " Sampling is determined by log_statement_sample_rate."),
3051 gettext_noop(
"Zero logs a sample of all queries. -1 turns this feature off."),
3061 gettext_noop(
"Sets the minimum execution time above which "
3062 "all statements will be logged."),
3063 gettext_noop(
"Zero prints all queries. -1 turns this feature off."),
3073 gettext_noop(
"Sets the minimum execution time above which "
3074 "autovacuum actions will be logged."),
3075 gettext_noop(
"Zero prints all actions. -1 turns autovacuum logging off."),
3079 600000, -1, INT_MAX,
3085 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3086 "parameter values when logging statements."),
3091 -1, -1, INT_MAX / 2,
3097 gettext_noop(
"Sets the maximum length in bytes of data logged for bind "
3098 "parameter values when logging statements, on error."),
3109 gettext_noop(
"Background writer sleep time between rounds."),
3120 gettext_noop(
"Background writer maximum number of LRU pages to flush per round."),
3124 100, 0, INT_MAX / 2,
3130 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3140 {
"effective_io_concurrency",
3143 gettext_noop(
"Number of simultaneous requests that can be handled efficiently by the disk subsystem."),
3158 {
"maintenance_io_concurrency",
3161 gettext_noop(
"A variant of effective_io_concurrency that is used for maintenance work."),
3178 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
3188 {
"max_worker_processes",
3191 gettext_noop(
"Maximum number of concurrent worker processes."),
3200 {
"max_logical_replication_workers",
3203 gettext_noop(
"Maximum number of logical replication worker processes."),
3212 {
"max_sync_workers_per_subscription",
3215 gettext_noop(
"Maximum number of table synchronization workers per subscription."),
3225 gettext_noop(
"Sets the amount of time to wait before forcing "
3226 "log file rotation."),
3237 gettext_noop(
"Sets the maximum size a log file can reach before "
3243 10 * 1024, 0, INT_MAX / 1024,
3249 gettext_noop(
"Shows the maximum number of function arguments."),
3260 gettext_noop(
"Shows the maximum number of index keys."),
3287 BLCKSZ, BLCKSZ, BLCKSZ,
3293 gettext_noop(
"Shows the number of pages per disk file."),
3298 RELSEG_SIZE, RELSEG_SIZE, RELSEG_SIZE,
3304 gettext_noop(
"Shows the block size in the write ahead log."),
3309 XLOG_BLCKSZ, XLOG_BLCKSZ, XLOG_BLCKSZ,
3315 gettext_noop(
"Sets the time to wait before retrying to retrieve WAL "
3316 "after a failed attempt."),
3327 gettext_noop(
"Shows the size of write ahead log segments."),
3340 gettext_noop(
"Time to sleep between autovacuum runs."),
3345 60, 1, INT_MAX / 1000,
3350 gettext_noop(
"Minimum number of tuple updates or deletes prior to vacuum."),
3359 gettext_noop(
"Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums."),
3368 gettext_noop(
"Minimum number of tuple inserts, updates, or deletes prior to analyze."),
3378 gettext_noop(
"Age at which to autovacuum a table to prevent transaction ID wraparound."),
3384 200000000, 100000, 2000000000,
3390 gettext_noop(
"Multixact age at which to autovacuum a table to prevent multixact wraparound."),
3394 400000000, 10000, 2000000000,
3400 gettext_noop(
"Sets the maximum number of simultaneously running autovacuum worker processes."),
3410 gettext_noop(
"Sets the maximum number of parallel processes per maintenance operation."),
3420 gettext_noop(
"Sets the maximum number of parallel processes per executor node."),
3431 gettext_noop(
"Sets the maximum number of parallel workers that can be active at one time."),
3442 gettext_noop(
"Sets the maximum memory to be used by each autovacuum worker process."),
3453 gettext_noop(
"Time before a snapshot is too old to read pages changed after the snapshot was taken."),
3475 gettext_noop(
"Time between TCP keepalive retransmits."),
3486 gettext_noop(
"SSL renegotiation is no longer supported; this can only be 0."),
3497 gettext_noop(
"Maximum number of TCP keepalive retransmits."),
3498 gettext_noop(
"This controls the number of consecutive keepalive retransmits that can be "
3499 "lost before a connection is considered dead. A value of 0 uses the "
3509 gettext_noop(
"Sets the maximum allowed result for exact search by GIN."),
3520 gettext_noop(
"Sets the planner's assumption about the total size of the data caches."),
3521 gettext_noop(
"That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. "
3522 "This is measured in disk pages, which are normally 8 kB each."),
3532 gettext_noop(
"Sets the minimum amount of table data for a parallel scan."),
3533 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."),
3537 (8 * 1024 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3543 gettext_noop(
"Sets the minimum amount of index data for a parallel scan."),
3544 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."),
3548 (512 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3555 gettext_noop(
"Shows the server version as an integer."),
3560 PG_VERSION_NUM, PG_VERSION_NUM, PG_VERSION_NUM,
3566 gettext_noop(
"Log the use of temporary files larger than this number of kilobytes."),
3567 gettext_noop(
"Zero logs all files. The default is -1 (turning this feature off)."),
3577 gettext_noop(
"Sets the size reserved for pg_stat_activity.query, in bytes."),
3588 gettext_noop(
"Sets the maximum size of the pending list for GIN index."),
3610 gettext_noop(
"The size of huge page that should be requested."),
3621 gettext_noop(
"Aggressively flush system caches for debugging purposes."),
3626 #ifdef DISCARD_CACHES_ENABLED
3628 #if defined(CLOBBER_CACHE_RECURSIVELY)
3630 #elif defined(CLOBBER_CACHE_ALWAYS)
3644 gettext_noop(
"Sets the time interval between checks for disconnection while running queries."),
3656 "long-running startup operations."),
3667 {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL, NULL
3676 gettext_noop(
"Sets the planner's estimate of the cost of a "
3677 "sequentially fetched disk page."),
3687 gettext_noop(
"Sets the planner's estimate of the cost of a "
3688 "nonsequentially fetched disk page."),
3698 gettext_noop(
"Sets the planner's estimate of the cost of "
3699 "processing each tuple (row)."),
3709 gettext_noop(
"Sets the planner's estimate of the cost of "
3710 "processing each index entry during an index scan."),
3720 gettext_noop(
"Sets the planner's estimate of the cost of "
3721 "processing each operator or function call."),
3731 gettext_noop(
"Sets the planner's estimate of the cost of "
3732 "passing each tuple (row) from worker to leader backend."),
3742 gettext_noop(
"Sets the planner's estimate of the cost of "
3743 "starting up worker processes for parallel query."),
3754 gettext_noop(
"Perform JIT compilation if query is more expensive."),
3759 100000, -1, DBL_MAX,
3765 gettext_noop(
"Optimize JIT-compiled functions if query is more expensive."),
3770 500000, -1, DBL_MAX,
3776 gettext_noop(
"Perform JIT inlining if query is more expensive."),
3781 500000, -1, DBL_MAX,
3787 gettext_noop(
"Sets the planner's estimate of the fraction of "
3788 "a cursor's rows that will be retrieved."),
3799 gettext_noop(
"Sets the planner's estimate of the average size "
3800 "of a recursive query's working table."),
3811 gettext_noop(
"GEQO: selective pressure within the population."),
3833 gettext_noop(
"Multiple of work_mem to use for hash tables."),
3844 gettext_noop(
"Multiple of the average buffer usage to free per round."),
3854 gettext_noop(
"Sets the seed for random-number generation."),
3876 gettext_noop(
"Vacuum cost delay in milliseconds, for autovacuum."),
3887 gettext_noop(
"Number of tuple updates or deletes prior to vacuum as a fraction of reltuples."),
3897 gettext_noop(
"Number of tuple inserts prior to vacuum as a fraction of reltuples."),
3907 gettext_noop(
"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."),
3917 gettext_noop(
"Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."),
3927 gettext_noop(
"Fraction of statements exceeding log_min_duration_sample to be logged."),
3928 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (always log).")
3937 gettext_noop(
"Sets the fraction of transactions from which to log all statements."),
3938 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (log all "
3939 "statements for all transactions).")
3948 {NULL, 0, 0, NULL, NULL}, NULL, 0.0, 0.0, 0.0, NULL, NULL, NULL
3957 gettext_noop(
"Sets the shell command that will be called to archive a WAL file."),
3958 gettext_noop(
"This is used only if \"archive_library\" is not set.")
3967 gettext_noop(
"Sets the library that will be called to archive a WAL file."),
3968 gettext_noop(
"An empty string indicates that \"archive_command\" should be used.")
3977 gettext_noop(
"Sets the shell command that will be called to retrieve an archived WAL file."),
3987 gettext_noop(
"Sets the shell command that will be executed at every restart point."),
3997 gettext_noop(
"Sets the shell command that will be executed once at the end of recovery."),
4007 gettext_noop(
"Specifies the timeline to recover into."),
4017 gettext_noop(
"Set to \"immediate\" to end recovery as soon as a consistent state is reached."),
4026 gettext_noop(
"Sets the transaction ID up to which recovery will proceed."),
4035 gettext_noop(
"Sets the time stamp up to which recovery will proceed."),
4044 gettext_noop(
"Sets the named restore point up to which recovery will proceed."),
4053 gettext_noop(
"Sets the LSN of the write-ahead log location up to which recovery will proceed."),
4063 gettext_noop(
"Specifies a file name whose presence ends recovery in the standby."),
4073 gettext_noop(
"Sets the connection string to be used to connect to the sending server."),
4084 gettext_noop(
"Sets the name of the replication slot to use on the sending server."),
4094 gettext_noop(
"Sets the client's character set encoding."),
4105 gettext_noop(
"Controls information prefixed to each log line."),
4115 gettext_noop(
"Sets the time zone to use in log messages."),
4125 gettext_noop(
"Sets the display format for date and time values."),
4126 gettext_noop(
"Also controls interpretation of ambiguous "
4137 gettext_noop(
"Sets the default table access method for new tables."),
4148 gettext_noop(
"Sets the default tablespace to create tables and indexes in."),
4149 gettext_noop(
"An empty string selects the database's default tablespace."),
4159 gettext_noop(
"Sets the tablespace(s) to use for temporary tables and sort files."),
4170 gettext_noop(
"Sets the path for dynamically loadable modules."),
4171 gettext_noop(
"If a dynamically loadable module needs to be opened and "
4172 "the specified name does not have a directory component (i.e., the "
4173 "name does not contain a slash), the system will search this path for "
4174 "the specified file."),
4184 gettext_noop(
"Sets the location of the Kerberos server key file."),
4218 gettext_noop(
"Shows the character classification and case conversion locale."),
4229 gettext_noop(
"Sets the language in which messages are displayed."),
4239 gettext_noop(
"Sets the locale for formatting monetary amounts."),
4249 gettext_noop(
"Sets the locale for formatting numbers."),
4259 gettext_noop(
"Sets the locale for formatting date and time values."),
4269 gettext_noop(
"Lists shared libraries to preload into each backend."),
4280 gettext_noop(
"Lists shared libraries to preload into server."),
4291 gettext_noop(
"Lists unprivileged shared libraries to preload into each backend."),
4302 gettext_noop(
"Sets the schema search order for names that are not schema-qualified."),
4307 "\"$user\", public",
4314 gettext_noop(
"Shows the server (database) character set encoding."),
4361 gettext_noop(
"Sets the destination for server log output."),
4362 gettext_noop(
"Valid values are combinations of \"stderr\", "
4363 "\"syslog\", \"csvlog\", \"jsonlog\", and \"eventlog\", "
4364 "depending on the platform."),
4373 gettext_noop(
"Sets the destination directory for log files."),
4374 gettext_noop(
"Can be specified as relative to the data directory "
4375 "or as absolute path."),
4384 gettext_noop(
"Sets the file name pattern for log files."),
4389 "postgresql-%Y-%m-%d_%H%M%S.log",
4395 gettext_noop(
"Sets the program name used to identify PostgreSQL "
4396 "messages in syslog."),
4406 gettext_noop(
"Sets the application name used to identify "
4407 "PostgreSQL messages in the event log."),
4417 gettext_noop(
"Sets the time zone for displaying and interpreting time stamps."),
4427 gettext_noop(
"Selects a file of time zone abbreviations."),
4437 gettext_noop(
"Sets the owning group of the Unix-domain socket."),
4438 gettext_noop(
"The owning user of the socket is always the user "
4439 "that starts the server.")
4448 gettext_noop(
"Sets the directories where Unix-domain sockets will be created."),
4453 #ifdef HAVE_UNIX_SOCKETS
4463 gettext_noop(
"Sets the host name or IP address(es) to listen to."),
4489 gettext_noop(
"Sets the server's main configuration file."),
4500 gettext_noop(
"Sets the server's \"hba\" configuration file."),
4511 gettext_noop(
"Sets the server's \"ident\" configuration file."),
4522 gettext_noop(
"Writes the postmaster PID to the specified file."),
4548 gettext_noop(
"Location of the SSL server certificate file."),
4558 gettext_noop(
"Location of the SSL server private key file."),
4568 gettext_noop(
"Location of the SSL certificate authority file."),
4578 gettext_noop(
"Location of the SSL certificate revocation list file."),
4588 gettext_noop(
"Location of the SSL certificate revocation list directory."),
4598 gettext_noop(
"Number of synchronous standbys and list of names of potential synchronous ones."),
4609 gettext_noop(
"Sets default text search configuration."),
4613 "pg_catalog.simple",
4625 "HIGH:MEDIUM:+3DES:!aNULL",
4649 gettext_noop(
"Location of the SSL DH parameters file."),
4660 gettext_noop(
"Command to obtain passphrases for SSL."),
4671 gettext_noop(
"Sets the application name to be reported in statistics and logs."),
4682 gettext_noop(
"Sets the name of the cluster, which is included in the process title."),
4693 gettext_noop(
"Sets the WAL resource managers for which WAL consistency checks are done."),
4694 gettext_noop(
"Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay."),
4715 gettext_noop(
"Log backtrace for errors in these functions."),
4726 {NULL, 0, 0, NULL, NULL}, NULL, NULL, NULL, NULL, NULL
4735 gettext_noop(
"Sets whether \"\\'\" is allowed in string literals."),
4755 gettext_noop(
"Sets the message levels that are sent to the client."),
4756 gettext_noop(
"Each level includes all the levels that follow it. The later"
4757 " the level, the fewer messages are sent.")
4766 gettext_noop(
"Enables in-core computation of query identifiers."),
4776 gettext_noop(
"Enables the planner to use constraints to optimize queries."),
4777 gettext_noop(
"Table scans will be skipped if their constraints"
4778 " guarantee that no rows match the query."),
4788 gettext_noop(
"Sets the default compression method for compressible values."),
4799 gettext_noop(
"Sets the transaction isolation level of each new transaction."),
4809 gettext_noop(
"Sets the current transaction's isolation level."),
4820 gettext_noop(
"Sets the display format for interval values."),
4831 gettext_noop(
"Sets the verbosity of logged messages."),
4841 gettext_noop(
"Sets the message levels that are logged."),
4842 gettext_noop(
"Each level includes all the levels that follow it. The later"
4843 " the level, the fewer messages are sent.")
4852 gettext_noop(
"Causes all statements generating error at or above this level to be logged."),
4853 gettext_noop(
"Each level includes all the levels that follow it. The later"
4854 " the level, the fewer messages are sent.")
4873 gettext_noop(
"Sets the syslog \"facility\" to be used when syslog enabled."),
4888 gettext_noop(
"Sets the session's behavior for triggers and rewrite rules."),
4898 gettext_noop(
"Sets the current transaction's synchronization level."),
4908 gettext_noop(
"Allows archiving of WAL files using archive_command."),
4918 gettext_noop(
"Sets the action to perform upon reaching the recovery target."),
4928 gettext_noop(
"Enables logging of recovery-related debugging information."),
4929 gettext_noop(
"Each level includes all the levels that follow it. The later"
4930 " the level, the fewer messages are sent."),
4945 gettext_noop(
"Collects function-level statistics on database activity."),
4956 gettext_noop(
"Sets the consistency of accesses to statistics data"),
4966 gettext_noop(
"Compresses full-page writes written in WAL file with specified method."),
4976 gettext_noop(
"Sets the level of information written to the WAL."),
4986 gettext_noop(
"Selects the dynamic shared memory implementation used."),
4996 gettext_noop(
"Selects the shared memory implementation used for the main shared memory region."),
5006 gettext_noop(
"Selects the method used for forcing WAL updates to disk."),
5016 gettext_noop(
"Sets how binary values are to be encoded in XML."),
5026 gettext_noop(
"Sets whether XML data in implicit parsing and serialization "
5027 "operations is to be considered as documents or content fragments."),
5037 gettext_noop(
"Use of huge pages on Linux or Windows."),
5047 gettext_noop(
"Prefetch referenced blocks during recovery"),
5048 gettext_noop(
"Look ahead in the WAL to find references to uncached data.")
5057 gettext_noop(
"Forces use of parallel query facilities."),
5058 gettext_noop(
"If possible, run query using a parallel worker and with parallel restrictions."),
5068 gettext_noop(
"Chooses the algorithm for encrypting passwords."),
5078 gettext_noop(
"Controls the planner's selection of custom or generic plan."),
5079 gettext_noop(
"Prepared statements can have custom and generic plans, and the planner "
5080 "will attempt to choose which is better. This can be set to override "
5081 "the default behavior."),
5091 gettext_noop(
"Sets the minimum SSL/TLS protocol version to use."),
5103 gettext_noop(
"Sets the maximum SSL/TLS protocol version to use."),
5115 gettext_noop(
"Sets the method for synchronizing the data directory before crash recovery."),
5124 {NULL, 0, 0, NULL, NULL}, NULL, 0, NULL, NULL, NULL, NULL
5138 "sort_mem",
"work_mem",
5139 "vacuum_mem",
"maintenance_work_mem",
5174 const char *curvalue,
5180 bool skipIfNoPermissions);
5200 (
errcode(ERRCODE_OUT_OF_MEMORY),
5201 errmsg(
"out of memory")));
5211 if (old == NULL && size == 0)
5216 (
errcode(ERRCODE_OUT_OF_MEMORY),
5217 errmsg(
"out of memory")));
5229 (
errcode(ERRCODE_OUT_OF_MEMORY),
5230 errmsg(
"out of memory")));
5264 char *oldval = *field;
5325 void *oldval = *field;
5361 &(
val->val.stringval),
5389 &(
val->val.stringval),
5464 size_vars = num_vars + num_vars / 4;
5522 if (guc_vars == NULL)
5544 bool saw_sep =
false;
5545 bool name_start =
true;
5547 for (
const char *p =
name; *p; p++)
5556 else if (strchr(
"ABCDEFGHIJKLMNOPQRSTUVWXYZ"
5557 "abcdefghijklmnopqrstuvwxyz_", *p) != NULL ||
5563 else if (!name_start && strchr(
"0123456789$", *p) != NULL)
5608 var->
variable = (
char **) (var + 1);