106 #ifndef PG_KRB_SRVTAB 107 #define PG_KRB_SRVTAB "" 110 #define CONFIG_FILENAME "postgresql.conf" 111 #define HBA_FILENAME "pg_hba.conf" 112 #define IDENT_FILENAME "pg_ident.conf" 115 #define CONFIG_EXEC_PARAMS "global/config_exec_params" 116 #define CONFIG_EXEC_PARAMS_NEW "global/config_exec_params.new" 123 #define REALTYPE_PRECISION 17 135 #ifdef TRACE_SYNCSCAN 136 extern bool trace_syncscan;
138 #ifdef DEBUG_BOUNDED_SORT 139 extern bool optimize_bounded_sort;
156 void **extra,
GucSource source,
int elevel);
158 void **extra,
GucSource source,
int elevel);
160 void **extra,
GucSource source,
int elevel);
162 void **extra,
GucSource source,
int elevel);
174 static int syslog_facility = 0;
233 bool applySettings,
int elevel);
249 "array length mismatch");
257 {
"debug5",
DEBUG5,
false},
258 {
"debug4",
DEBUG4,
false},
259 {
"debug3",
DEBUG3,
false},
260 {
"debug2",
DEBUG2,
false},
261 {
"debug1",
DEBUG1,
false},
264 {
"info",
INFO,
true},
265 {
"notice",
NOTICE,
false},
267 {
"error",
ERROR,
false},
272 {
"debug5",
DEBUG5,
false},
273 {
"debug4",
DEBUG4,
false},
274 {
"debug3",
DEBUG3,
false},
275 {
"debug2",
DEBUG2,
false},
276 {
"debug1",
DEBUG1,
false},
278 {
"info",
INFO,
false},
279 {
"notice",
NOTICE,
false},
281 {
"error",
ERROR,
false},
283 {
"fatal",
FATAL,
false},
284 {
"panic",
PANIC,
false},
297 "array length mismatch");
307 "array length mismatch");
318 "array length mismatch");
336 "array length mismatch");
340 {
"local0", LOG_LOCAL0,
false},
341 {
"local1", LOG_LOCAL1,
false},
342 {
"local2", LOG_LOCAL2,
false},
343 {
"local3", LOG_LOCAL3,
false},
344 {
"local4", LOG_LOCAL4,
false},
345 {
"local5", LOG_LOCAL5,
false},
346 {
"local6", LOG_LOCAL6,
false},
347 {
"local7", LOG_LOCAL7,
false},
362 "array length mismatch");
371 "array length mismatch");
380 "array length mismatch");
488 "array length mismatch");
644 "array length mismatch");
655 "environment variable",
656 "configuration file",
670 "array length mismatch");
684 gettext_noop(
"Connections and Authentication / Connection Settings"),
686 gettext_noop(
"Connections and Authentication / Authentication"),
698 gettext_noop(
"Resource Usage / Cost-Based Vacuum Delay"),
728 gettext_noop(
"Query Tuning / Planner Method Configuration"),
750 gettext_noop(
"Statistics / Query and Index Statistics Collector"),
756 gettext_noop(
"Client Connection Defaults / Statement Behavior"),
758 gettext_noop(
"Client Connection Defaults / Locale and Formatting"),
760 gettext_noop(
"Client Connection Defaults / Shared Library Preloading"),
762 gettext_noop(
"Client Connection Defaults / Other Defaults"),
768 gettext_noop(
"Version and Platform Compatibility / Previous PostgreSQL Versions"),
770 gettext_noop(
"Version and Platform Compatibility / Other Platforms and Clients"),
784 "array length mismatch");
801 "array length mismatch");
818 #define MAX_UNIT_LEN 3 829 #if BLCKSZ < 1024 || BLCKSZ > (1024*1024) 830 #error BLCKSZ must be between 1KB and 1MB 832 #if XLOG_BLCKSZ < 1024 || XLOG_BLCKSZ > (1024*1024) 833 #error XLOG_BLCKSZ must be between 1KB and 1MB 864 {
"TB",
GUC_UNIT_XBLOCKS, (1024.0 * 1024.0 * 1024.0) / (XLOG_BLCKSZ / 1024)},
935 gettext_noop(
"Enables the planner's use of sequential-scan plans."),
945 gettext_noop(
"Enables the planner's use of index-scan plans."),
955 gettext_noop(
"Enables the planner's use of index-only-scan plans."),
965 gettext_noop(
"Enables the planner's use of bitmap-scan plans."),
975 gettext_noop(
"Enables the planner's use of TID scan plans."),
985 gettext_noop(
"Enables the planner's use of explicit sort steps."),
995 gettext_noop(
"Enables the planner's use of incremental sort steps."),
1004 gettext_noop(
"Enables the planner's use of hashed aggregation plans."),
1014 gettext_noop(
"Enables the planner's use of materialization."),
1024 gettext_noop(
"Enables the planner's use of nested-loop join plans."),
1034 gettext_noop(
"Enables the planner's use of merge join plans."),
1044 gettext_noop(
"Enables the planner's use of hash join plans."),
1054 gettext_noop(
"Enables the planner's use of gather merge plans."),
1074 gettext_noop(
"Enables partitionwise aggregation and grouping."),
1084 gettext_noop(
"Enables the planner's use of parallel append plans."),
1094 gettext_noop(
"Enables the planner's use of parallel hash plans."),
1104 gettext_noop(
"Enables plan-time and run-time partition pruning."),
1105 gettext_noop(
"Allows the query planner and executor to compare partition " 1106 "bounds to conditions in the query to determine which " 1107 "partitions must be scanned."),
1117 gettext_noop(
"This algorithm attempts to do planning without " 1118 "exhaustive searching."),
1128 gettext_noop(
"Shows whether the current user is a superuser."),
1138 gettext_noop(
"Enables advertising the server via Bonjour."),
1165 gettext_noop(
"Also use ssl_passphrase_command during server reload."),
1174 gettext_noop(
"Give priority to server ciphersuite order."),
1183 gettext_noop(
"Forces synchronization of updates to disk."),
1184 gettext_noop(
"The server will use the fsync() system call in several places to make " 1185 "sure that updates are physically written to disk. This insures " 1186 "that a database cluster will recover to a consistent state after " 1187 "an operating system or hardware crash.")
1195 gettext_noop(
"Continues processing after a checksum failure."),
1196 gettext_noop(
"Detection of a checksum failure normally causes PostgreSQL to " 1197 "report an error, aborting the current transaction. Setting " 1198 "ignore_checksum_failure to true causes the system to ignore the failure " 1199 "(but still report a warning), and continue processing. This " 1200 "behavior could cause crashes or other serious problems. Only " 1201 "has an effect if checksums are enabled."),
1210 gettext_noop(
"Continues processing past damaged page headers."),
1211 gettext_noop(
"Detection of a damaged page header normally causes PostgreSQL to " 1212 "report an error, aborting the current transaction. Setting " 1213 "zero_damaged_pages to true causes the system to instead report a " 1214 "warning, zero out the damaged page, and continue processing. This " 1215 "behavior will destroy data, namely all the rows on the damaged page."),
1224 gettext_noop(
"Continues recovery after an invalid pages failure."),
1225 gettext_noop(
"Detection of WAL records having references to " 1226 "invalid pages during recovery causes PostgreSQL to " 1227 "raise a PANIC-level error, aborting the recovery. " 1228 "Setting ignore_invalid_pages to true causes " 1229 "the system to ignore invalid page references " 1230 "in WAL records (but still report a warning), " 1231 "and continue recovery. This behavior may cause " 1232 "crashes, data loss, propagate or hide corruption, " 1233 "or other serious problems. Only has an effect " 1234 "during recovery or in standby mode."),
1243 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint."),
1244 gettext_noop(
"A page write in process during an operating system crash might be " 1245 "only partially written to disk. During recovery, the row changes " 1246 "stored in WAL are not enough to recover. This option writes " 1247 "pages when first modified after a checkpoint to WAL so full recovery " 1257 gettext_noop(
"Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modifications."),
1267 gettext_noop(
"Compresses full-page writes written in WAL file."),
1277 gettext_noop(
"Writes zeroes to new WAL files before first use."),
1315 gettext_noop(
"Logs end of a session, including duration."),
1333 gettext_noop(
"Shows whether the running server has assertion checks enabled."),
1338 #ifdef USE_ASSERT_CHECKING 1357 gettext_noop(
"Reinitialize server after backend crash."),
1367 gettext_noop(
"Logs the duration of each completed SQL statement."),
1385 gettext_noop(
"Logs each query's rewritten parse tree."),
1412 gettext_noop(
"Writes parser performance statistics to the server log."),
1421 gettext_noop(
"Writes planner performance statistics to the server log."),
1430 gettext_noop(
"Writes executor performance statistics to the server log."),
1439 gettext_noop(
"Writes cumulative performance statistics to the server log."),
1446 #ifdef BTREE_BUILD_STATS 1449 gettext_noop(
"Logs system resource usage statistics (memory and CPU) on various B-tree operations."),
1461 gettext_noop(
"Collects information about executing commands."),
1462 gettext_noop(
"Enables the collection of information on the currently " 1463 "executing command of each session, along with " 1464 "the time at which that command began execution.")
1472 gettext_noop(
"Collects statistics on database activity."),
1481 gettext_noop(
"Collects timing statistics for database I/O activity."),
1491 gettext_noop(
"Updates the process title to show the active SQL command."),
1492 gettext_noop(
"Enables updating of the process title every time a new SQL command is received by the server.")
1515 gettext_noop(
"Generates debugging output for LISTEN and NOTIFY."),
1537 gettext_noop(
"Emits information about user lock usage."),
1547 gettext_noop(
"Emits information about lightweight lock usage."),
1557 gettext_noop(
"Dumps information about all current locks when a deadlock timeout occurs."),
1587 gettext_noop(
"Logs the host name in the connection logs."),
1588 gettext_noop(
"By default, connection logs only show the IP address " 1589 "of the connecting host. If you want them to show the host name you " 1590 "can turn this on, but depending on your host name resolution " 1591 "setup it might impose a non-negligible performance penalty.")
1599 gettext_noop(
"Treats \"expr=NULL\" as \"expr IS NULL\"."),
1600 gettext_noop(
"When turned on, expressions of the form expr = NULL " 1601 "(or NULL = expr) are treated as expr IS NULL, that is, they " 1602 "return true if expr evaluates to the null value, and false " 1603 "otherwise. The correct behavior of expr = NULL is to always " 1604 "return null (unknown).")
1621 gettext_noop(
"Sets the default read-only status of new transactions."),
1630 gettext_noop(
"Sets the current transaction's read-only status."),
1640 gettext_noop(
"Sets the default deferrable status of new transactions."),
1649 gettext_noop(
"Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures."),
1660 gettext_noop(
"When enabled, row security will be applied to all users.")
1668 gettext_noop(
"Check function bodies during CREATE FUNCTION."),
1677 gettext_noop(
"Enable input of NULL elements in arrays."),
1678 gettext_noop(
"When turned on, unquoted NULL in an array input " 1679 "value means a null value; " 1680 "otherwise it is taken literally.")
1694 gettext_noop(
"WITH OIDS is no longer supported; this can only be false."),
1704 gettext_noop(
"Start a subprocess to capture stderr output and/or csvlogs into log files."),
1713 gettext_noop(
"Truncate existing log files of same name during log rotation."),
1724 gettext_noop(
"Emit information about resource usage in sorting."),
1734 #ifdef TRACE_SYNCSCAN 1738 gettext_noop(
"Generate debugging output for synchronized scanning."),
1748 #ifdef DEBUG_BOUNDED_SORT 1753 gettext_noop(
"Enable bounded sorting using heap sort."),
1757 &optimize_bounded_sort,
1789 gettext_noop(
"Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive."),
1799 gettext_noop(
"Warn about backslash escapes in ordinary string literals."),
1809 gettext_noop(
"Causes '...' strings to treat backslashes literally."),
1830 gettext_noop(
"Sets whether to include or exclude transaction with recovery target."),
1840 gettext_noop(
"Allows connections and queries during recovery."),
1850 gettext_noop(
"Allows feedback from a hot standby to the primary that will avoid query conflicts."),
1860 gettext_noop(
"Shows whether hot standby is currently active."),
1871 gettext_noop(
"Allows modifications of the structure of system tables."),
1883 gettext_noop(
"It does not prevent updating the indexes, so it is safe " 1884 "to use. The worst consequence is slowness."),
1894 gettext_noop(
"Enables backward compatibility mode for privilege checks on large objects."),
1895 gettext_noop(
"Skips privilege checks when reading or modifying large objects, " 1896 "for compatibility with PostgreSQL releases prior to 9.0.")
1905 gettext_noop(
"When generating SQL fragments, quote all identifiers."),
1915 gettext_noop(
"Shows whether data checksums are turned on for this cluster."),
1926 gettext_noop(
"Add sequence number to syslog messages to avoid duplicate suppression."),
1936 gettext_noop(
"Split messages sent to syslog by lines and to fit into 1024 bytes."),
1946 gettext_noop(
"Controls whether Gather and Gather Merge also run subplans."),
1947 gettext_noop(
"Should gather nodes also run subplans, or just gather tuples?"),
1968 gettext_noop(
"Register JIT compiled function with debugger."),
1985 gettext_noop(
"Write out LLVM bitcode to facilitate JIT debugging."),
2007 gettext_noop(
"Register JIT compiled function with perf profiler."),
2024 gettext_noop(
"Allow JIT compilation of tuple deforming."),
2035 gettext_noop(
"Whether to continue running after a failure to sync data files."),
2044 gettext_noop(
"Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured."),
2053 {NULL, 0, 0, NULL, NULL}, NULL,
false, NULL, NULL, NULL
2062 gettext_noop(
"Forces a switch to the next WAL file if a " 2063 "new file has not been started within N seconds."),
2073 gettext_noop(
"Waits N seconds on connection startup after authentication."),
2074 gettext_noop(
"This allows attaching a debugger to the process."),
2078 0, 0, INT_MAX / 1000000,
2084 gettext_noop(
"This applies to table columns that have not had a " 2085 "column-specific target set via ALTER TABLE SET STATISTICS.")
2093 gettext_noop(
"Sets the FROM-list size beyond which subqueries " 2094 "are not collapsed."),
2095 gettext_noop(
"The planner will merge subqueries into upper " 2096 "queries if the resulting FROM list would have no more than " 2097 "this many items."),
2106 gettext_noop(
"Sets the FROM-list size beyond which JOIN " 2107 "constructs are not flattened."),
2109 "constructs into lists of FROM items whenever a " 2110 "list of no more than this many items would result."),
2119 gettext_noop(
"Sets the threshold of FROM items beyond which GEQO is used."),
2129 gettext_noop(
"GEQO: effort is used to set the default for other GEQO parameters."),
2139 gettext_noop(
"GEQO: number of individuals in the population."),
2140 gettext_noop(
"Zero selects a suitable default value."),
2149 gettext_noop(
"GEQO: number of iterations of the algorithm."),
2150 gettext_noop(
"Zero selects a suitable default value."),
2161 gettext_noop(
"Sets the time to wait on a lock before checking for deadlock."),
2172 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data."),
2177 30 * 1000, -1, INT_MAX,
2183 gettext_noop(
"Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data."),
2188 30 * 1000, -1, INT_MAX,
2194 gettext_noop(
"Sets the minimum delay for applying changes during recovery."),
2205 gettext_noop(
"Sets the maximum interval between WAL receiver status reports to the sending server."),
2210 10, 0, INT_MAX / 1000,
2216 gettext_noop(
"Sets the maximum wait time to receive data from the sending server."),
2221 60 * 1000, 0, INT_MAX,
2227 gettext_noop(
"Sets the maximum number of concurrent connections."),
2238 gettext_noop(
"Sets the number of connection slots reserved for superusers."),
2248 gettext_noop(
"Amount of dynamic shared memory reserved at startup."),
2253 0, 0, (int)
Min((
size_t) INT_MAX, SIZE_MAX / (1024 * 1024)),
2263 gettext_noop(
"Sets the number of shared memory buffers used by the server."),
2268 1024, 16, INT_MAX / 2,
2274 gettext_noop(
"Sets the maximum number of temporary buffers used by each session."),
2279 1024, 100, INT_MAX / 2,
2285 gettext_noop(
"Sets the TCP port the server listens on."),
2289 DEF_PGPORT, 1, 65535,
2295 gettext_noop(
"Sets the access permissions of the Unix-domain socket."),
2296 gettext_noop(
"Unix-domain sockets use the usual Unix file system " 2297 "permission set. The parameter value is expected " 2298 "to be a numeric mode specification in the form " 2299 "accepted by the chmod and umask system calls. " 2300 "(To use the customary octal format the number must " 2301 "start with a 0 (zero).)")
2310 gettext_noop(
"Sets the file permissions for log files."),
2312 "to be a numeric mode specification in the form " 2313 "accepted by the chmod and umask system calls. " 2314 "(To use the customary octal format the number must " 2315 "start with a 0 (zero).)")
2326 gettext_noop(
"The parameter value is a numeric mode specification " 2327 "in the form accepted by the chmod and umask system " 2328 "calls. (To use the customary octal format the number " 2329 "must start with a 0 (zero).)"),
2339 gettext_noop(
"Sets the maximum memory to be used for query workspaces."),
2340 gettext_noop(
"This much memory can be used by each internal " 2341 "sort operation and hash table before switching to " 2342 "temporary disk files."),
2352 gettext_noop(
"Sets the maximum memory to be used for maintenance operations."),
2353 gettext_noop(
"This includes operations such as VACUUM and CREATE INDEX."),
2363 gettext_noop(
"Sets the maximum memory to be used for logical decoding."),
2364 gettext_noop(
"This much memory can be used by each internal " 2365 "reorder buffer before spilling to disk."),
2380 gettext_noop(
"Sets the maximum stack depth, in kilobytes."),
2391 gettext_noop(
"Limits the total size of all temporary files used by each process."),
2402 gettext_noop(
"Vacuum cost for a page found in the buffer cache."),
2412 gettext_noop(
"Vacuum cost for a page not found in the buffer cache."),
2422 gettext_noop(
"Vacuum cost for a page dirtied by vacuum."),
2432 gettext_noop(
"Vacuum cost amount available before napping."),
2442 gettext_noop(
"Vacuum cost amount available before napping, for autovacuum."),
2452 gettext_noop(
"Sets the maximum number of simultaneously open files for each server process."),
2465 gettext_noop(
"Sets the maximum number of simultaneously prepared transactions."),
2476 gettext_noop(
"Sets the minimum OID of tables for tracking locks."),
2477 gettext_noop(
"Is used to avoid output on system tables."),
2486 gettext_noop(
"Sets the OID of the table with unconditionally lock tracing."),
2498 gettext_noop(
"Sets the maximum allowed duration of any statement."),
2509 gettext_noop(
"Sets the maximum allowed duration of any wait for a lock."),
2520 gettext_noop(
"Sets the maximum allowed idle time between queries, when in a transaction."),
2531 gettext_noop(
"Sets the maximum allowed idle time between queries, when not in a transaction."),
2542 gettext_noop(
"Minimum age at which VACUUM should freeze a table row."),
2546 50000000, 0, 1000000000,
2552 gettext_noop(
"Age at which VACUUM should scan whole table to freeze tuples."),
2556 150000000, 0, 2000000000,
2562 gettext_noop(
"Minimum age at which VACUUM should freeze a MultiXactId in a table row."),
2566 5000000, 0, 1000000000,
2572 gettext_noop(
"Multixact age at which VACUUM should scan whole table to freeze tuples."),
2576 150000000, 0, 2000000000,
2582 gettext_noop(
"Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."),
2595 gettext_noop(
"Sets the maximum number of locks per transaction."),
2596 gettext_noop(
"The shared lock table is sized on the assumption that " 2597 "at most max_locks_per_transaction * max_connections distinct " 2598 "objects will need to be locked at any one time.")
2607 gettext_noop(
"Sets the maximum number of predicate locks per transaction."),
2608 gettext_noop(
"The shared predicate lock table is sized on the assumption that " 2609 "at most max_pred_locks_per_transaction * max_connections distinct " 2610 "objects will need to be locked at any one time.")
2619 gettext_noop(
"Sets the maximum number of predicate-locked pages and tuples per relation."),
2620 gettext_noop(
"If more than this total of pages and tuples in the same relation are locked " 2621 "by a connection, those locks are replaced by a relation-level lock.")
2624 -2, INT_MIN, INT_MAX,
2630 gettext_noop(
"Sets the maximum number of predicate-locked tuples per page."),
2631 gettext_noop(
"If more than this number of tuples on the same page are locked " 2632 "by a connection, those locks are replaced by a page-level lock.")
2641 gettext_noop(
"Sets the maximum allowed time to complete client authentication."),
2653 gettext_noop(
"Waits N seconds on connection startup before authentication."),
2654 gettext_noop(
"This allows attaching a debugger to the process."),
2664 gettext_noop(
"Sets the size of WAL files held for standby servers."),
2675 gettext_noop(
"Sets the minimum size to shrink the WAL to."),
2687 gettext_noop(
"Sets the WAL size that triggers a checkpoint."),
2699 gettext_noop(
"Sets the maximum time between automatic WAL checkpoints."),
2710 gettext_noop(
"Enables warnings if checkpoint segments are filled more " 2711 "frequently than this."),
2712 gettext_noop(
"Write a message to the server log if checkpoints " 2713 "caused by the filling of checkpoint segment files happens more " 2714 "frequently than this number of seconds. Zero turns off the warning."),
2724 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
2735 gettext_noop(
"Sets the number of disk-page buffers in shared memory for WAL."),
2740 -1, -1, (INT_MAX / XLOG_BLCKSZ),
2746 gettext_noop(
"Time between WAL flushes performed in the WAL writer."),
2757 gettext_noop(
"Amount of WAL written out by WAL writer that triggers a flush."),
2762 (1024 * 1024) / XLOG_BLCKSZ, 0, INT_MAX,
2768 gettext_noop(
"Size of new file to fsync instead of writing WAL."),
2779 gettext_noop(
"Sets the maximum number of simultaneously running WAL sender processes."),
2790 gettext_noop(
"Sets the maximum number of simultaneously defined replication slots."),
2800 gettext_noop(
"Sets the maximum WAL size that can be reserved by replication slots."),
2801 gettext_noop(
"Replication slots will be marked as failed, and segments released " 2802 "for deletion or recycling, if this much space is occupied by WAL " 2813 gettext_noop(
"Sets the maximum time to wait for WAL replication."),
2818 60 * 1000, 0, INT_MAX,
2824 gettext_noop(
"Sets the delay in microseconds between transaction commit and " 2825 "flushing WAL to disk."),
2836 gettext_noop(
"Sets the minimum concurrent open transactions before performing " 2847 gettext_noop(
"Sets the number of digits displayed for floating-point values."),
2848 gettext_noop(
"This affects real, double precision, and geometric data types. " 2849 "A zero or negative parameter value is added to the standard " 2850 "number of digits (FLT_DIG or DBL_DIG as appropriate). " 2851 "Any value greater than zero selects precise output mode.")
2860 gettext_noop(
"Sets the minimum execution time above which " 2861 "a sample of statements will be logged." 2862 " Sampling is determined by log_statement_sample_rate."),
2863 gettext_noop(
"Zero logs a sample of all queries. -1 turns this feature off."),
2873 gettext_noop(
"Sets the minimum execution time above which " 2874 "all statements will be logged."),
2875 gettext_noop(
"Zero prints all queries. -1 turns this feature off."),
2885 gettext_noop(
"Sets the minimum execution time above which " 2886 "autovacuum actions will be logged."),
2887 gettext_noop(
"Zero prints all actions. -1 turns autovacuum logging off."),
2897 gettext_noop(
"When logging statements, limit logged parameter values to first N bytes."),
2902 -1, -1, INT_MAX / 2,
2908 gettext_noop(
"When reporting an error, limit logged parameter values to first N bytes."),
2919 gettext_noop(
"Background writer sleep time between rounds."),
2930 gettext_noop(
"Background writer maximum number of LRU pages to flush per round."),
2934 100, 0, INT_MAX / 2,
2940 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
2950 {
"effective_io_concurrency",
2953 gettext_noop(
"Number of simultaneous requests that can be handled efficiently by the disk subsystem."),
2954 gettext_noop(
"For RAID arrays, this should be approximately the number of drive spindles in the array."),
2968 {
"maintenance_io_concurrency",
2971 gettext_noop(
"A variant of effective_io_concurrency that is used for maintenance work."),
2987 gettext_noop(
"Number of pages after which previously performed writes are flushed to disk."),
2997 {
"max_worker_processes",
3000 gettext_noop(
"Maximum number of concurrent worker processes."),
3009 {
"max_logical_replication_workers",
3012 gettext_noop(
"Maximum number of logical replication worker processes."),
3021 {
"max_sync_workers_per_subscription",
3024 gettext_noop(
"Maximum number of table synchronization workers per subscription."),
3034 gettext_noop(
"Automatic log file rotation will occur after N minutes."),
3045 gettext_noop(
"Automatic log file rotation will occur after N kilobytes."),
3050 10 * 1024, 0, INT_MAX / 1024,
3056 gettext_noop(
"Shows the maximum number of function arguments."),
3067 gettext_noop(
"Shows the maximum number of index keys."),
3083 NAMEDATALEN - 1, NAMEDATALEN - 1, NAMEDATALEN - 1,
3094 BLCKSZ, BLCKSZ, BLCKSZ,
3100 gettext_noop(
"Shows the number of pages per disk file."),
3105 RELSEG_SIZE, RELSEG_SIZE, RELSEG_SIZE,
3111 gettext_noop(
"Shows the block size in the write ahead log."),
3116 XLOG_BLCKSZ, XLOG_BLCKSZ, XLOG_BLCKSZ,
3122 gettext_noop(
"Sets the time to wait before retrying to retrieve WAL " 3123 "after a failed attempt."),
3134 gettext_noop(
"Shows the size of write ahead log segments."),
3147 gettext_noop(
"Time to sleep between autovacuum runs."),
3152 60, 1, INT_MAX / 1000,
3157 gettext_noop(
"Minimum number of tuple updates or deletes prior to vacuum."),
3166 gettext_noop(
"Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums."),
3175 gettext_noop(
"Minimum number of tuple inserts, updates, or deletes prior to analyze."),
3185 gettext_noop(
"Age at which to autovacuum a table to prevent transaction ID wraparound."),
3190 200000000, 100000, 2000000000,
3196 gettext_noop(
"Multixact age at which to autovacuum a table to prevent multixact wraparound."),
3200 400000000, 10000, 2000000000,
3206 gettext_noop(
"Sets the maximum number of simultaneously running autovacuum worker processes."),
3216 gettext_noop(
"Sets the maximum number of parallel processes per maintenance operation."),
3226 gettext_noop(
"Sets the maximum number of parallel processes per executor node."),
3237 gettext_noop(
"Sets the maximum number of parallel workers that can be active at one time."),
3248 gettext_noop(
"Sets the maximum memory to be used by each autovacuum worker process."),
3259 gettext_noop(
"Time before a snapshot is too old to read pages changed after the snapshot was taken."),
3281 gettext_noop(
"Time between TCP keepalive retransmits."),
3292 gettext_noop(
"SSL renegotiation is no longer supported; this can only be 0."),
3303 gettext_noop(
"Maximum number of TCP keepalive retransmits."),
3304 gettext_noop(
"This controls the number of consecutive keepalive retransmits that can be " 3305 "lost before a connection is considered dead. A value of 0 uses the " 3315 gettext_noop(
"Sets the maximum allowed result for exact search by GIN."),
3326 gettext_noop(
"Sets the planner's assumption about the total size of the data caches."),
3327 gettext_noop(
"That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. " 3328 "This is measured in disk pages, which are normally 8 kB each."),
3338 gettext_noop(
"Sets the minimum amount of table data for a parallel scan."),
3339 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."),
3343 (8 * 1024 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3349 gettext_noop(
"Sets the minimum amount of index data for a parallel scan."),
3350 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."),
3354 (512 * 1024) / BLCKSZ, 0, INT_MAX / 3,
3361 gettext_noop(
"Shows the server version as an integer."),
3366 PG_VERSION_NUM, PG_VERSION_NUM, PG_VERSION_NUM,
3372 gettext_noop(
"Log the use of temporary files larger than this number of kilobytes."),
3373 gettext_noop(
"Zero logs all files. The default is -1 (turning this feature off)."),
3383 gettext_noop(
"Sets the size reserved for pg_stat_activity.query, in bytes."),
3394 gettext_noop(
"Sets the maximum size of the pending list for GIN index."),
3416 gettext_noop(
"The size of huge page that should be requested."),
3427 gettext_noop(
"Aggressively invalidate system caches for debugging purposes."),
3432 #ifdef CLOBBER_CACHE_ENABLED 3434 #if defined(CLOBBER_CACHE_RECURSIVELY) 3436 #elif defined(CLOBBER_CACHE_ALWAYS) 3450 {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL, NULL
3459 gettext_noop(
"Sets the planner's estimate of the cost of a " 3460 "sequentially fetched disk page."),
3470 gettext_noop(
"Sets the planner's estimate of the cost of a " 3471 "nonsequentially fetched disk page."),
3481 gettext_noop(
"Sets the planner's estimate of the cost of " 3482 "processing each tuple (row)."),
3492 gettext_noop(
"Sets the planner's estimate of the cost of " 3493 "processing each index entry during an index scan."),
3503 gettext_noop(
"Sets the planner's estimate of the cost of " 3504 "processing each operator or function call."),
3514 gettext_noop(
"Sets the planner's estimate of the cost of " 3515 "passing each tuple (row) from worker to leader backend."),
3525 gettext_noop(
"Sets the planner's estimate of the cost of " 3526 "starting up worker processes for parallel query."),
3537 gettext_noop(
"Perform JIT compilation if query is more expensive."),
3542 100000, -1, DBL_MAX,
3548 gettext_noop(
"Optimize JITed functions if query is more expensive."),
3553 500000, -1, DBL_MAX,
3559 gettext_noop(
"Perform JIT inlining if query is more expensive."),
3564 500000, -1, DBL_MAX,
3570 gettext_noop(
"Sets the planner's estimate of the fraction of " 3571 "a cursor's rows that will be retrieved."),
3582 gettext_noop(
"GEQO: selective pressure within the population."),
3604 gettext_noop(
"Multiple of work_mem to use for hash tables."),
3615 gettext_noop(
"Multiple of the average buffer usage to free per round."),
3625 gettext_noop(
"Sets the seed for random-number generation."),
3647 gettext_noop(
"Vacuum cost delay in milliseconds, for autovacuum."),
3658 gettext_noop(
"Number of tuple updates or deletes prior to vacuum as a fraction of reltuples."),
3668 gettext_noop(
"Number of tuple inserts prior to vacuum as a fraction of reltuples."),
3678 gettext_noop(
"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."),
3688 gettext_noop(
"Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."),
3698 gettext_noop(
"Number of tuple inserts prior to index cleanup as a fraction of reltuples."),
3708 gettext_noop(
"Fraction of statements exceeding log_min_duration_sample to be logged."),
3709 gettext_noop(
"Use a value between 0.0 (never log) and 1.0 (always log).")
3718 gettext_noop(
"Set the fraction of transactions to log for new transactions."),
3719 gettext_noop(
"Logs all statements from a fraction of transactions. " 3720 "Use a value between 0.0 (never log) and 1.0 (log all " 3721 "statements for all transactions).")
3730 {NULL, 0, 0, NULL, NULL}, NULL, 0.0, 0.0, 0.0, NULL, NULL, NULL
3739 gettext_noop(
"Sets the shell command that will be called to archive a WAL file."),
3749 gettext_noop(
"Sets the shell command that will be called to retrieve an archived WAL file."),
3759 gettext_noop(
"Sets the shell command that will be executed at every restart point."),
3769 gettext_noop(
"Sets the shell command that will be executed once at the end of recovery."),
3779 gettext_noop(
"Specifies the timeline to recover into."),
3789 gettext_noop(
"Set to \"immediate\" to end recovery as soon as a consistent state is reached."),
3798 gettext_noop(
"Sets the transaction ID up to which recovery will proceed."),
3807 gettext_noop(
"Sets the time stamp up to which recovery will proceed."),
3816 gettext_noop(
"Sets the named restore point up to which recovery will proceed."),
3825 gettext_noop(
"Sets the LSN of the write-ahead log location up to which recovery will proceed."),
3835 gettext_noop(
"Specifies a file name whose presence ends recovery in the standby."),
3845 gettext_noop(
"Sets the connection string to be used to connect to the sending server."),
3856 gettext_noop(
"Sets the name of the replication slot to use on the sending server."),
3866 gettext_noop(
"Sets the client's character set encoding."),
3877 gettext_noop(
"Controls information prefixed to each log line."),
3887 gettext_noop(
"Sets the time zone to use in log messages."),
3897 gettext_noop(
"Sets the display format for date and time values."),
3898 gettext_noop(
"Also controls interpretation of ambiguous " 3909 gettext_noop(
"Sets the default table access method for new tables."),
3920 gettext_noop(
"Sets the default tablespace to create tables and indexes in."),
3921 gettext_noop(
"An empty string selects the database's default tablespace."),
3931 gettext_noop(
"Sets the tablespace(s) to use for temporary tables and sort files."),
3942 gettext_noop(
"Sets the path for dynamically loadable modules."),
3943 gettext_noop(
"If a dynamically loadable module needs to be opened and " 3944 "the specified name does not have a directory component (i.e., the " 3945 "name does not contain a slash), the system will search this path for " 3946 "the specified file."),
3956 gettext_noop(
"Sets the location of the Kerberos server key file."),
3990 gettext_noop(
"Shows the character classification and case conversion locale."),
4001 gettext_noop(
"Sets the language in which messages are displayed."),
4011 gettext_noop(
"Sets the locale for formatting monetary amounts."),
4021 gettext_noop(
"Sets the locale for formatting numbers."),
4031 gettext_noop(
"Sets the locale for formatting date and time values."),
4041 gettext_noop(
"Lists shared libraries to preload into each backend."),
4052 gettext_noop(
"Lists shared libraries to preload into server."),
4063 gettext_noop(
"Lists unprivileged shared libraries to preload into each backend."),
4074 gettext_noop(
"Sets the schema search order for names that are not schema-qualified."),
4079 "\"$user\", public",
4086 gettext_noop(
"Sets the server (database) character set encoding."),
4133 gettext_noop(
"Sets the destination for server log output."),
4134 gettext_noop(
"Valid values are combinations of \"stderr\", " 4135 "\"syslog\", \"csvlog\", and \"eventlog\", " 4136 "depending on the platform."),
4145 gettext_noop(
"Sets the destination directory for log files."),
4146 gettext_noop(
"Can be specified as relative to the data directory " 4147 "or as absolute path."),
4156 gettext_noop(
"Sets the file name pattern for log files."),
4161 "postgresql-%Y-%m-%d_%H%M%S.log",
4167 gettext_noop(
"Sets the program name used to identify PostgreSQL " 4168 "messages in syslog."),
4178 gettext_noop(
"Sets the application name used to identify " 4179 "PostgreSQL messages in the event log."),
4189 gettext_noop(
"Sets the time zone for displaying and interpreting time stamps."),
4199 gettext_noop(
"Selects a file of time zone abbreviations."),
4209 gettext_noop(
"Sets the owning group of the Unix-domain socket."),
4210 gettext_noop(
"The owning user of the socket is always the user " 4211 "that starts the server.")
4220 gettext_noop(
"Sets the directories where Unix-domain sockets will be created."),
4225 #ifdef HAVE_UNIX_SOCKETS 4235 gettext_noop(
"Sets the host name or IP address(es) to listen to."),
4261 gettext_noop(
"Sets the server's main configuration file."),
4272 gettext_noop(
"Sets the server's \"hba\" configuration file."),
4283 gettext_noop(
"Sets the server's \"ident\" configuration file."),
4294 gettext_noop(
"Writes the postmaster PID to the specified file."),
4320 gettext_noop(
"Location of the SSL server certificate file."),
4330 gettext_noop(
"Location of the SSL server private key file."),
4340 gettext_noop(
"Location of the SSL certificate authority file."),
4350 gettext_noop(
"Location of the SSL certificate revocation list file."),
4360 gettext_noop(
"Writes temporary statistics files to the specified directory."),
4371 gettext_noop(
"Number of synchronous standbys and list of names of potential synchronous ones."),
4382 gettext_noop(
"Sets default text search configuration."),
4386 "pg_catalog.simple",
4398 "HIGH:MEDIUM:+3DES:!aNULL",
4422 gettext_noop(
"Location of the SSL DH parameters file."),
4433 gettext_noop(
"Command to obtain passphrases for SSL."),
4444 gettext_noop(
"Sets the application name to be reported in statistics and logs."),
4455 gettext_noop(
"Sets the name of the cluster, which is included in the process title."),
4466 gettext_noop(
"Sets the WAL resource managers for which WAL consistency checks are done."),
4467 gettext_noop(
"Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay."),
4488 gettext_noop(
"Log backtrace for errors in these functions."),
4499 {NULL, 0, 0, NULL, NULL}, NULL, NULL, NULL, NULL, NULL
4508 gettext_noop(
"Sets whether \"\\'\" is allowed in string literals."),
4528 gettext_noop(
"Sets the message levels that are sent to the client."),
4529 gettext_noop(
"Each level includes all the levels that follow it. The later" 4530 " the level, the fewer messages are sent.")
4539 gettext_noop(
"Enables the planner to use constraints to optimize queries."),
4540 gettext_noop(
"Table scans will be skipped if their constraints" 4541 " guarantee that no rows match the query."),
4551 gettext_noop(
"Sets the transaction isolation level of each new transaction."),
4561 gettext_noop(
"Sets the current transaction's isolation level."),
4572 gettext_noop(
"Sets the display format for interval values."),
4583 gettext_noop(
"Sets the verbosity of logged messages."),
4593 gettext_noop(
"Sets the message levels that are logged."),
4594 gettext_noop(
"Each level includes all the levels that follow it. The later" 4595 " the level, the fewer messages are sent.")
4604 gettext_noop(
"Causes all statements generating error at or above this level to be logged."),
4605 gettext_noop(
"Each level includes all the levels that follow it. The later" 4606 " the level, the fewer messages are sent.")
4625 gettext_noop(
"Sets the syslog \"facility\" to be used when syslog enabled."),
4640 gettext_noop(
"Sets the session's behavior for triggers and rewrite rules."),
4650 gettext_noop(
"Sets the current transaction's synchronization level."),
4660 gettext_noop(
"Allows archiving of WAL files using archive_command."),
4670 gettext_noop(
"Sets the action to perform upon reaching the recovery target."),
4680 gettext_noop(
"Enables logging of recovery-related debugging information."),
4681 gettext_noop(
"Each level includes all the levels that follow it. The later" 4682 " the level, the fewer messages are sent.")
4696 gettext_noop(
"Collects function-level statistics on database activity."),
4706 gettext_noop(
"Set the level of information written to the WAL."),
4716 gettext_noop(
"Selects the dynamic shared memory implementation used."),
4726 gettext_noop(
"Selects the shared memory implementation used for the main shared memory region."),
4736 gettext_noop(
"Selects the method used for forcing WAL updates to disk."),
4746 gettext_noop(
"Sets how binary values are to be encoded in XML."),
4756 gettext_noop(
"Sets whether XML data in implicit parsing and serialization " 4757 "operations is to be considered as documents or content fragments."),
4767 gettext_noop(
"Use of huge pages on Linux or Windows."),
4777 gettext_noop(
"Forces use of parallel query facilities."),
4778 gettext_noop(
"If possible, run query using a parallel worker and with parallel restrictions."),
4788 gettext_noop(
"Chooses the algorithm for encrypting passwords."),
4798 gettext_noop(
"Controls the planner's selection of custom or generic plan."),
4799 gettext_noop(
"Prepared statements can have custom and generic plans, and the planner " 4800 "will attempt to choose which is better. This can be set to override " 4801 "the default behavior."),
4811 gettext_noop(
"Sets the minimum SSL/TLS protocol version to use."),
4817 ssl_protocol_versions_info + 1,
4823 gettext_noop(
"Sets the maximum SSL/TLS protocol version to use."),
4835 {NULL, 0, 0, NULL, NULL}, NULL, 0, NULL, NULL, NULL, NULL
4849 "sort_mem",
"work_mem",
4850 "vacuum_mem",
"maintenance_work_mem",
4885 const char *curvalue,
4891 bool skipIfNoPermissions);
4894 const char *name,
const char *
value);
4911 (
errcode(ERRCODE_OUT_OF_MEMORY),
4912 errmsg(
"out of memory")));
4922 if (old == NULL && size == 0)
4927 (
errcode(ERRCODE_OUT_OF_MEMORY),
4928 errmsg(
"out of memory")));
4940 (
errcode(ERRCODE_OUT_OF_MEMORY),
4941 errmsg(
"out of memory")));
4958 for (stack = conf->
gen.
stack; stack; stack = stack->
prev)
4975 char *oldval = *field;
4993 if (extra == gconf->
extra)
4998 if (extra == ((
struct config_bool *) gconf)->reset_extra)
5002 if (extra == ((
struct config_int *) gconf)->reset_extra)
5006 if (extra == ((
struct config_real *) gconf)->reset_extra)
5014 if (extra == ((
struct config_enum *) gconf)->reset_extra)
5018 for (stack = gconf->
stack; stack; stack = stack->
prev)
5036 void *oldval = *field;
5131 for (i = 0; ConfigureNamesBool[
i].
gen.
name; i++)
5140 for (i = 0; ConfigureNamesInt[
i].
gen.
name; i++)
5148 for (i = 0; ConfigureNamesReal[
i].
gen.
name; i++)
5156 for (i = 0; ConfigureNamesString[
i].
gen.
name; i++)
5164 for (i = 0; ConfigureNamesEnum[
i].
gen.
name; i++)
5175 size_vars = num_vars + num_vars / 4;
5182 for (i = 0; ConfigureNamesBool[
i].
gen.
name; i++)
5183 guc_vars[num_vars++] = &ConfigureNamesBool[i].gen;
5185 for (i = 0; ConfigureNamesInt[
i].
gen.
name; i++)
5186 guc_vars[num_vars++] = &ConfigureNamesInt[i].gen;
5188 for (i = 0; ConfigureNamesReal[
i].
gen.
name; i++)
5189 guc_vars[num_vars++] = &ConfigureNamesReal[i].gen;
5191 for (i = 0; ConfigureNamesString[
i].
gen.
name; i++)
5192 guc_vars[num_vars++] = &ConfigureNamesString[i].gen;
5194 for (i = 0; ConfigureNamesEnum[
i].
gen.
name; i++)
5195 guc_vars[num_vars++] = &ConfigureNamesEnum[i].gen;
5198 free(guc_variables);
5199 guc_variables = guc_vars;
5200 num_guc_variables = num_vars;
5201 size_guc_variables = size_vars;
5202 qsort((
void *) guc_variables, num_guc_variables,
5213 if (num_guc_variables + 1 >= size_guc_variables)
5218 int size_vars = size_guc_variables + size_guc_variables / 4;
5233 if (guc_vars == NULL)
5236 guc_variables = guc_vars;
5237 size_guc_variables = size_vars;
5239 guc_variables[num_guc_variables++] = var;
5240 qsort((
void *) guc_variables, num_guc_variables,
5262 if (gen->
name == NULL)
5270 gen->
short_desc =
"GUC placeholder variable";
5279 var->
variable = (
char **) (var + 1);
5310 (
void *) guc_variables,
5322 for (i = 0; map_old_guc_names[
i] != NULL; i += 2)
5325 return find_option(map_old_guc_names[i + 1],
false, elevel);
5328 if (create_placeholders)
5365 while (*namea && *nameb)
5367 char cha = *namea++;
5368 char chb = *nameb++;
5370 if (cha >=
'A' && cha <=
'Z')
5372 if (chb >=
'A' && chb <=
'Z')
5418 reporting_enabled =
false;
5453 env = getenv(
"PGPORT");
5457 env = getenv(
"PGDATESTYLE");
5461 env = getenv(
"PGCLIENTENCODING");
5471 if (stack_rlimit > 0)
5475 if (new_limit > 100)
5479 new_limit =
Min(new_limit, 2048);
5480 sprintf(limbuf,
"%ld", new_limit);
5501 gconf->
stack = NULL;
5502 gconf->
extra = NULL;
5517 elog(
FATAL,
"failed to initialize %s to %d",
5535 elog(
FATAL,
"failed to initialize %s to %d",
5553 elog(
FATAL,
"failed to initialize %s to %g",
5575 elog(
FATAL,
"failed to initialize %s to \"%s\"",
5576 conf->
gen.
name, newval ? newval :
"");
5591 elog(
FATAL,
"failed to initialize %s to %d",
5619 struct stat stat_buf;
5627 if (configdir &&
stat(configdir, &stat_buf) != 0)
5629 write_stderr(
"%s: could not access directory \"%s\": %s\n",
5633 if (errno == ENOENT)
5634 write_stderr(
"Run initdb or pg_basebackup to initialize a PostgreSQL data directory.\n");
5654 write_stderr(
"%s does not know where to find the server configuration file.\n" 5655 "You must specify the --config-file or -D invocation " 5656 "option or set the PGDATA environment variable.\n",
5671 if (
stat(ConfigFileName, &stat_buf) != 0)
5673 write_stderr(
"%s: could not access the server configuration file \"%s\": %s\n",
5674 progname, ConfigFileName,
strerror(errno));
5699 write_stderr(
"%s does not know where to find the database system data.\n" 5700 "This can be specified as \"data_directory\" in \"%s\", " 5701 "or by the -D invocation option, or by the " 5702 "PGDATA environment variable.\n",
5703 progname, ConfigFileName);
5747 write_stderr(
"%s does not know where to find the \"hba\" configuration file.\n" 5748 "This can be specified as \"hba_file\" in \"%s\", " 5749 "or by the -D invocation option, or by the " 5750 "PGDATA environment variable.\n",
5751 progname, ConfigFileName);