Search PostgreSQL documentation

recovery_target_actionConfigurationReferencerecovery_target_action Write-Ahead Log 12 Specifies what action the server should take once the recovery target is reached. The default is pause, which means recovery will be paused. promote…Configuration · Write-Ahead Log recovery_target_inclusiveConfigurationReferencerecovery_target_inclusive Write-Ahead Log 12 Specifies whether to stop just after the specified recovery target (on), or just before the recovery target (off). Applies when recovery_target_l…Configuration · Write-Ahead Log recovery_target_lsnConfigurationReferencerecovery_target_lsn Write-Ahead Log 12 This parameter specifies the LSN of the write-ahead log location up to which recovery will proceed. The precise stopping point is also influenced by re…Configuration · Write-Ahead Log recovery_target_nameConfigurationReferencerecovery_target_name Write-Ahead Log 12 This parameter specifies the named restore point (created with pg_create_restore_point()) to which recovery will proceed. 13 14 15 16 17 18 19 20 Sets…Configuration · Write-Ahead Log recovery_target_timeConfigurationReferencerecovery_target_time Write-Ahead Log 12 This parameter specifies the time stamp up to which recovery will proceed. The precise stopping point is also influenced by recovery_target_inclusive.…Configuration · Write-Ahead Log recovery_target_timelineConfigurationReferencerecovery_target_timeline Write-Ahead Log 12 Specifies recovering into a particular timeline. The value can be a numeric timeline ID or a special value. The value current recovers along the s…Configuration · Write-Ahead Log recovery_target_xidConfigurationReferencerecovery_target_xid Write-Ahead Log 12 This parameter specifies the transaction ID up to which recovery will proceed. Keep in mind that while transaction IDs are assigned sequentially at tra…Configuration · Write-Ahead Log recursive_worktable_factorConfigurationReferencerecursive_worktable_factor Query Tuning 15 Sets the planner's estimate of the average size of the working table of a recursive query, as a multiple of the estimated size of the initial non-r…Configuration · Query Tuning remove_temp_files_after_crashConfigurationReferenceremove_temp_files_after_crash Developer Options 14 When set to on, which is the default, PostgreSQL will automatically remove temporary files after a backend crash. If disabled, the files wi…Configuration · Developer Options replacement_sort_tuplesConfigurationReferencereplacement_sort_tuples Resource Usage 10 When the number of tuples to be sorted is smaller than this number, a sort will produce its first output run using replacement selection rather than…Configuration · Resource Usage replication_timeoutConfigurationReferencereplication_timeout Replication 9.1 Terminate replication connections that are inactive longer than the specified number of milliseconds. This is useful for the primary server to detect a st…Configuration · Replication reserved_connectionsConfigurationReferencereserved_connections Connections and Authentication 16 Determines the number of connection “slots” that are reserved for connections by roles with privileges of the pg_use_reserved_connectio…Configuration · Connections and Authentication restart_after_crashConfigurationReferencerestart_after_crash Error Handling 10 When set to true, which is the default, PostgreSQL will automatically reinitialize after a backend crash. Leaving this value set to true is normally the…Configuration · Error Handling restore_commandConfigurationReferencerestore_command Write-Ahead Log 12 The local shell command to execute to retrieve an archived segment of the WAL file series. This parameter is required for archive recovery, but optional fo…Configuration · Write-Ahead Log restrict_nonsystem_relation_kindConfigurationReferencerestrict_nonsystem_relation_kind Client Connection Defaults 12 Set relation kinds for which access to non-system relations is prohibited. The value takes the form of a comma-separated list o…Configuration · Client Connection Defaults row_securityConfigurationReferencerow_security Client Connection Defaults 10 This variable controls whether to raise an error in lieu of applying a row security policy. When set to on, policies apply normally. When set to of…Configuration · Client Connection Defaults scram_iterationsConfigurationReferencescram_iterations Connections and Authentication 16 The number of computational iterations to be performed when encrypting a password using SCRAM-SHA-256. The default is 4096. A higher number…Configuration · Connections and Authentication search_pathConfigurationReferencesearch_path Client Connection Defaults 10 This variable specifies the order in which schemas are searched when an object (table, data type, function, etc.) is referenced by a simple name wit…Configuration · Client Connection Defaults segment_sizeConfigurationReferencesegment_size Preset Options 10 Reports the number of blocks (pages) that can be stored within a file segment. It is determined by the value of RELSEG_SIZE when building the server. The maxim…Configuration · Preset Options send_abort_for_crashConfigurationReferencesend_abort_for_crash Developer Options 16 By default, after a backend crash the postmaster will stop remaining child processes by sending them SIGQUIT signals, which permits them to exit mor…Configuration · Developer Options send_abort_for_killConfigurationReferencesend_abort_for_kill Developer Options 16 By default, after attempting to stop a child process with SIGQUIT, the postmaster will wait five seconds and then send SIGKILL to force immediate ter…Configuration · Developer Options sepgsql.debug_auditConfigurationPG18sepgsql.debug_audit (boolean) This parameter enables the printing of audit messages regardless of the system policy settings. The default is off, which means that messages will be printed ac…sepgsql — SELinux-, label-based mandatory access control (MAC) security module › GUC Parameters sepgsql.permissiveConfigurationPG18sepgsql.permissive (boolean) This parameter enables sepgsql to function in permissive mode, regardless of the system setting. The default is off. This parameter can only be set in the postgr…sepgsql — SELinux-, label-based mandatory access control (MAC) security module › GUC Parameters seq_page_costConfigurationReferenceseq_page_cost Query Tuning 10 Sets the planner's estimate of the cost of a disk page fetch that is part of a series of sequential fetches. The default is 1.0. This value can be overridden fo…Configuration · Query Tuning serializable_buffersConfigurationReferenceserializable_buffers Resource Usage 17 Specifies the amount of shared memory to use to cache the contents of pg_serial (see Table 65.1). If this value is specified without units, it is taken…Configuration · Resource Usage server_encodingConfigurationReferenceserver_encoding Preset Options 10 Reports the database encoding (character set). It is determined when the database is created. Ordinarily, clients need only be concerned with the value of c…Configuration · Preset Options server_versionConfigurationReferenceserver_version Preset Options 10 Reports the version number of the server. It is determined by the value of PG_VERSION when building the server. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3…Configuration · Preset Options server_version_numConfigurationReferenceserver_version_num Preset Options 10 Reports the version number of the server as an integer. It is determined by the value of PG_VERSION_NUM when building the server. 11 12 13 14 15 16 17 18…Configuration · Preset Options session_preload_librariesConfigurationReferencesession_preload_libraries Client Connection Defaults 10 This variable specifies one or more shared libraries that are to be preloaded at connection start. It contains a comma-separated list …Configuration · Client Connection Defaults session_replication_roleConfigurationReferencesession_replication_role Client Connection Defaults 10 Controls firing of replication-related triggers and rules for the current session. Setting this variable requires superuser privilege a…Configuration · Client Connection Defaults shared_memory_sizeConfigurationReferenceshared_memory_size Preset Options 15 Reports the size of the main shared memory area, rounded up to the nearest megabyte. 16 17 18 19 20 Shows the size of the server's main shared memory are…Configuration · Preset Options shared_memory_size_in_huge_pagesConfigurationReferenceshared_memory_size_in_huge_pages Preset Options 15 Reports the number of huge pages that are needed for the main shared memory area based on the specified huge_page_size. If huge pages are n…Configuration · Preset Options shared_memory_typeConfigurationReferenceshared_memory_type Resource Usage 12 Specifies the shared memory implementation that the server should use for the main shared memory region that holds PostgreSQL's shared buffers and other …Configuration · Resource Usage shared_preload_librariesConfigurationReferenceshared_preload_libraries Client Connection Defaults 10 This variable specifies one or more shared libraries to be preloaded at server start. It contains a comma-separated list of library nam…Configuration · Client Connection Defaults silent_modeConfigurationReferencesilent_mode Reporting and Logging 9.0 Runs the server silently. If this parameter is set, the server will automatically run in background and disassociate from the controlling terminal. This…Configuration · Reporting and Logging sql_inheritanceConfigurationReferencesql_inheritance Version and Platform Compatibility 9.0 This setting controls whether undecorated table references are considered to include inheritance child tables. The default is on, which…Configuration · Version and Platform Compatibility sslConfigurationReferencessl Connections and Authentication 10 Enables SSL connections. Please read Section 18.9 before using this. This parameter can only be set in the postgresql.conf file or on the server command…Configuration · Connections and Authentication ssl_ca_fileConfigurationReferencessl_ca_file Connections and Authentication 10 Specifies the name of the file containing the SSL server certificate authority (CA). Relative paths are relative to the data directory. This par…Configuration · Connections and Authentication ssl_cert_fileConfigurationReferencessl_cert_file Connections and Authentication 10 Specifies the name of the file containing the SSL server certificate. Relative paths are relative to the data directory. This parameter can on…Configuration · Connections and Authentication ssl_ciphersConfigurationReferencessl_ciphers Connections and Authentication 10 Specifies a list of SSL cipher suites that are allowed to be used by SSL connections. See the ciphers manual page in the OpenSSL package for the…Configuration · Connections and Authentication