18.16. Preset Options#
The following“parameters” are read-only. As such, they have been excluded from the samplepostgresql.conf file. These options report various aspects ofPostgres Pro behavior that might be of interest to certain applications, particularly administrative front-ends. Most of them are determined whenPostgres Pro is compiled or when it is installed.
block_size(integer)#Reports the size of a disk block. It is determined by the value of
BLCKSZwhen building the server. The default value is 8192 bytes. The meaning of some configuration variables (such asshared_buffers) is influenced byblock_size. SeeSection 18.4 for information.data_checksums(boolean)#Reports whether data checksums are enabled for this cluster. See
-kfor more information.data_directory_mode(integer)#On Unix systems this parameter reports the permissions the data directory (defined bydata_directory) had at server startup. (On Microsoft Windows this parameter will always display
0700.) Seetheinitdb-goption for more information.debug_assertions(boolean)#Reports whetherPostgres Pro has been built with assertions enabled. That is the case if the macro
USE_ASSERT_CHECKINGis defined whenPostgres Pro is built (accomplished e.g., by theconfigureoption--enable-cassert). By defaultPostgres Pro is built without assertions.huge_pages_status(enum)#Reports the state of huge pages in the current instance:
on,off, orunknown(if displayed withpostgres -C). This parameter is useful to determine whether allocation of huge pages was successful underhuge_pages=try. Seehuge_pages for more information.integer_datetimes(boolean)#Reports whetherPostgres Pro was built with support for 64-bit-integer dates and times. As ofPostgres Pro 10, this is always
on.in_hot_standby(boolean)#Reports whether the server is currently in hot standby mode. When this is
on, all transactions are forced to be read-only. Within a session, this can change only if the server is promoted to be primary. SeeSection 25.4 for more information.lc_collate(string)#Reports the locale in which sorting of textual data is done. SeeSection 22.1 for more information. This value is determined when a database is created.
lc_ctype(string)#Reports the locale that determines character classifications. SeeSection 22.1 for more information. This value is determined when a database is created. Ordinarily this will be the same as
lc_collate, but for special applications it might be set differently.max_function_args(integer)#Reports the maximum number of function arguments. It is determined by the value of
FUNC_MAX_ARGSwhen building the server. The default value is 100 arguments.max_identifier_length(integer)#Reports the maximum identifier length. It is determined as one less than the value of
NAMEDATALENwhen building the server. The default value ofNAMEDATALENis 64; therefore the defaultmax_identifier_lengthis 63 bytes, which can be less than 63 characters when using multibyte encodings.max_index_keys(integer)#Reports the maximum number of index keys. It is determined by the value of
INDEX_MAX_KEYSwhen building the server. The default value is 32 keys.num_os_semaphores(integer)#Reports the number of semaphores that are needed for the server based on the configured number of allowed connections (max_connections), allowed autovacuum worker processes (autovacuum_max_workers), allowed WAL sender processes (max_wal_senders), allowed background processes (max_worker_processes), etc.
pgpro_build(string)#Reports the commit ID ofPostgres Pro source files.
pgpro_edition(string)#Reports thePostgres Pro edition as a string, i.e.
standardorenterprise.pgpro_version(string)#Reports thePostgres Pro server version as a string.
segment_size(integer)#Reports the number of blocks (pages) that can be stored within a file segment. It is determined by the value of
RELSEG_SIZEwhen building the server. The maximum size of a segment file in bytes is equal tosegment_sizemultiplied byblock_size; by default this is 1GB.server_encoding(string)#Reports the database encoding (character set). It is determined when the database is created. Ordinarily, clients need only be concerned with the value ofclient_encoding.
server_version(string)#Reports the version number of the server. It is determined by the value of
PG_VERSIONwhen building the server.server_version_num(integer)#Reports the version number of the server as an integer. It is determined by the value of
PG_VERSION_NUMwhen building the server.shared_memory_size(integer)#Reports the size of the main shared memory area, rounded up to the nearest megabyte.
shared_memory_size_in_huge_pages(integer)#Reports the number of huge pages that are needed for the main shared memory area based on the specifiedhuge_page_size. If huge pages are not supported, this will be
-1.This setting is supported only onLinux. It is always set to
-1on other platforms. For more details about using huge pages onLinux, seeSection 17.4.5.ssl_library(string)#Reports the name of the SSL library that thisPostgres Pro server was built with (even if SSL is not currently configured or in use on this instance), for example
OpenSSL, or an empty string if none.wal_block_size(integer)#Reports the size of a WAL disk block. It is determined by the value of
XLOG_BLCKSZwhen building the server. The default value is 8192 bytes.wal_segment_size(integer)#Reports the size of write ahead log segments. The default value is 16MB. SeeSection 27.5 for more information.