Search PostgreSQL documentation

ssl_crl_dirConfigurationReferencessl_crl_dir Connections and Authentication 14 Specifies the name of the directory containing the SSL client certificate revocation list (CRL). Relative paths are relative to the data directo…Configuration · Connections and Authentication ssl_crl_fileConfigurationReferencessl_crl_file Connections and Authentication 10 Specifies the name of the file containing the SSL client certificate revocation list (CRL). Relative paths are relative to the data directory. …Configuration · Connections and Authentication ssl_dh_params_fileConfigurationReferencessl_dh_params_file Connections and Authentication 10 Specifies the name of the file containing Diffie-Hellman parameters used for so-called ephemeral DH family of SSL ciphers. The default is…Configuration · Connections and Authentication ssl_ecdh_curveConfigurationReferencessl_ecdh_curve Connections and Authentication 10 Specifies the name of the curve to use in ECDH key exchange. It needs to be supported by all clients that connect. It does not need to be the…Configuration · Connections and Authentication ssl_groupsConfigurationReferencessl_groups Connections and Authentication 18 Specifies the named group to use for TLS key exchange. It needs to be supported by all clients that connect. Multiple groups can be specified by …Configuration · Connections and Authentication ssl_key_fileConfigurationReferencessl_key_file Connections and Authentication 10 Specifies the name of the file containing the SSL server private key. Relative paths are relative to the data directory. This parameter can onl…Configuration · Connections and Authentication ssl_libraryConfigurationReferencessl_library Preset Options 12 Reports the name of the SSL library that this PostgreSQL server was built with (even if SSL is not currently configured or in use on this instance), for example…Configuration · Preset Options ssl_max_protocol_versionConfigurationReferencessl_max_protocol_version Connections and Authentication 12 Sets the maximum SSL/TLS protocol version to use. Valid values are as for ssl_min_protocol_version, with addition of an empty strin…Configuration · Connections and Authentication ssl_min_protocol_versionConfigurationReferencessl_min_protocol_version Connections and Authentication 12 Sets the minimum SSL/TLS protocol version to use. Valid values are currently: TLSv1, TLSv1.1, TLSv1.2, TLSv1.3. Older versions of t…Configuration · Connections and Authentication ssl_passphrase_commandConfigurationReferencessl_passphrase_command Connections and Authentication 11 Sets an external command to be invoked when a passphrase for decrypting an SSL file such as a private key needs to be obtained. By de…Configuration · Connections and Authentication ssl_passphrase_command_supports_reloadConfigurationReferencessl_passphrase_command_supports_reload Connections and Authentication 11 This parameter determines whether the passphrase command set by ssl_passphrase_command will also be called during a c…Configuration · Connections and Authentication ssl_prefer_server_ciphersConfigurationReferencessl_prefer_server_ciphers Connections and Authentication 10 Specifies whether to use the server's SSL cipher preferences, rather than the client's. This parameter can only be set in the post…Configuration · Connections and Authentication ssl_renegotiation_limitConfigurationReferencessl_renegotiation_limit Connections and Authentication 9.0 Specifies how much data can flow over an SSL-encrypted connection before renegotiation of the session keys will take place. Renegot…Configuration · Connections and Authentication ssl_sniConfigurationReferencessl_sni Connections and Authentication 19 Enables SNI configuration for SSL connections. When set to on host configuration from hosts_file is used, see Section 18.9.6 for more details. This …Configuration · Connections and Authentication ssl_tls13_ciphersConfigurationReferencessl_tls13_ciphers Connections and Authentication 18 Specifies a list of cipher suites that are allowed by connections using TLS version 1.3. Multiple cipher suites can be specified by using …Configuration · Connections and Authentication standard_conforming_stringsConfigurationReferencestandard_conforming_strings Version and Platform Compatibility 10 This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. Beginn…Configuration · Version and Platform Compatibility statement_timeoutConfigurationReferencestatement_timeout Client Connection Defaults 10 Abort any statement that takes more than the specified number of milliseconds, starting from the time the command arrives at the server from t…Configuration · Client Connection Defaults stats_fetch_consistencyConfigurationReferencestats_fetch_consistency Statistics 15 Determines the behavior when cumulative statistics are accessed multiple times within a transaction. When set to none, each access re-fetches counters f…Configuration · Statistics stats_temp_directoryConfigurationReferencestats_temp_directory Statistics 10 Sets the directory to store temporary statistics data in. This can be a path relative to the data directory or an absolute path. The default is pg_stat_tmp…Configuration · Statistics subtransaction_buffersConfigurationReferencesubtransaction_buffers Resource Usage 17 Specifies the amount of shared memory to use to cache the contents of pg_subtrans (see Table 65.1). If this value is specified without units, it is t…Configuration · Resource Usage summarize_walConfigurationReferencesummarize_wal Write-Ahead Log 17 Enables the WAL summarizer process. Note that WAL summarization can be enabled either on a primary or on a standby. This parameter can only be set in the pos…Configuration · Write-Ahead Log superuser_reserved_connectionsConfigurationReferencesuperuser_reserved_connections Connections and Authentication 10 Determines the number of connection “slots” that are reserved for connections by PostgreSQL superusers. At most max_connectio…Configuration · Connections and Authentication sync_replication_slotsConfigurationReferencesync_replication_slots Replication 17 It enables a physical standby to synchronize logical failover slots from the primary server so that logical subscribers can resume replication from the …Configuration · Replication synchronize_seqscansConfigurationReferencesynchronize_seqscans Version and Platform Compatibility 10 This allows sequential scans of large tables to synchronize with each other, so that concurrent scans read the same block at about …Configuration · Version and Platform Compatibility synchronized_standby_slotsConfigurationReferencesynchronized_standby_slots Replication 17 A comma-separated list of streaming replication standby server slot names that logical WAL sender processes will wait for. Logical WAL sender proces…Configuration · Replication synchronous_commitConfigurationReferencesynchronous_commit Write-Ahead Log 10 Specifies how much WAL processing must complete before the database server returns a “success” indication to the client. Valid values are remote_apply, …Configuration · Write-Ahead Log synchronous_standby_namesConfigurationReferencesynchronous_standby_names Replication 10 Specifies a list of standby servers that can support synchronous replication, as described in Section 26.2.8. There will be one or more active synchr…Configuration · Replication syslog_facilityConfigurationReferencesyslog_facility Reporting and Logging 10 When logging to syslog is enabled, this parameter determines the syslog “facility” to be used. You can choose from LOCAL0, LOCAL1, LOCAL2, LOCAL3, LO…Configuration · Reporting and Logging syslog_identConfigurationReferencesyslog_ident Reporting and Logging 10 When logging to syslog is enabled, this parameter determines the program name used to identify PostgreSQL messages in syslog logs. The default is postgr…Configuration · Reporting and Logging syslog_sequence_numbersConfigurationReferencesyslog_sequence_numbers Reporting and Logging 10 When logging to syslog and this is on (the default), then each message will be prefixed by an increasing sequence number (such as [2]). This …Configuration · Reporting and Logging syslog_split_messagesConfigurationReferencesyslog_split_messages Reporting and Logging 10 When logging to syslog is enabled, this parameter determines how messages are delivered to syslog. When on (the default), messages are split by…Configuration · Reporting and Logging tcp_keepalives_countConfigurationReferencetcp_keepalives_count Connections and Authentication 10 Specifies the number of TCP keepalives that can be lost before the server's connection to the client is considered dead. A value of 0 u…Configuration · Connections and Authentication tcp_keepalives_idleConfigurationReferencetcp_keepalives_idle Connections and Authentication 10 Specifies the number of seconds of inactivity after which TCP should send a keepalive message to the client. A value of 0 uses the syste…Configuration · Connections and Authentication tcp_keepalives_intervalConfigurationReferencetcp_keepalives_interval Connections and Authentication 10 Specifies the number of seconds after which a TCP keepalive message that is not acknowledged by the client should be retransmitted. …Configuration · Connections and Authentication tcp_user_timeoutConfigurationReferencetcp_user_timeout Connections and Authentication 12 Specifies the amount of time that transmitted data may remain unacknowledged before the TCP connection is forcibly closed. If this value is…Configuration · Connections and Authentication temp_buffersConfigurationReferencetemp_buffers Resource Usage 10 Sets the maximum number of temporary buffers used by each database session. These are session-local buffers used only for access to temporary tables. The defau…Configuration · Resource Usage temp_file_limitConfigurationReferencetemp_file_limit Resource Usage 10 Specifies the maximum amount of disk space that a process can use for temporary files, such as sort and hash temporary files, or the storage file for a held…Configuration · Resource Usage temp_tablespacesConfigurationReferencetemp_tablespaces Client Connection Defaults 10 This variable specifies tablespaces in which to create temporary objects (temp tables and indexes on temp tables) when a CREATE command does no…Configuration · Client Connection Defaults TimeZoneConfigurationReferenceTimeZone Client Connection Defaults 10 Sets the time zone for displaying and interpreting time stamps. The built-in default is GMT, but that is typically overridden in postgresql.conf; initd…Configuration · Client Connection Defaults timezone_abbreviationsConfigurationReferencetimezone_abbreviations Client Connection Defaults 10 Sets the collection of time zone abbreviations that will be accepted by the server for datetime input. The default is 'Default', which is…Configuration · Client Connection Defaults