Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the mode of the data directory. The parameter value is a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).). |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
huge_pages_status
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Indicates the status of huge pages. |
| Data type | enumeration |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | huge_pages_status |
in_hot_standby
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether hot standby is currently active. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | in_hot_standby |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
num_os_semaphores
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of semaphores required for the server. |
| Data type | integer |
| Default value | 3511 |
| Allowed values | 3511 |
| Parameter type | read-only |
| Documentation | num_os_semaphores |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 18.0 |
| Allowed values | 18.0 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 180000 |
| Allowed values | 180000 |
| Parameter type | read-only |
| Documentation | server_version_num |
shared_memory_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of the server's main shared memory area (rounded up to the nearest MB). |
| Data type | integer |
| Default value | 8709 |
| Allowed values | 8709 |
| Parameter type | read-only |
| Documentation | shared_memory_size |
shared_memory_size_in_huge_pages
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of huge pages needed for the main shared memory area. -1 indicates that the value could not be determined. |
| Data type | integer |
| Default value | 4355 |
| Allowed values | 4355 |
| Parameter type | read-only |
| Documentation | shared_memory_size_in_huge_pages |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
huge_pages_status
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Indicates the status of huge pages. |
| Data type | enumeration |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | huge_pages_status |
in_hot_standby
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether hot standby is currently active. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | in_hot_standby |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 17.6 |
| Allowed values | 17.6 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 170006 |
| Allowed values | 170006 |
| Parameter type | read-only |
| Documentation | server_version_num |
shared_memory_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of the server's main shared memory area (rounded up to the nearest MB). |
| Data type | integer |
| Default value | 8623 |
| Allowed values | 8623 |
| Parameter type | read-only |
| Documentation | shared_memory_size |
shared_memory_size_in_huge_pages
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of huge pages needed for the main shared memory area. |
| Data type | integer |
| Default value | 4312 |
| Allowed values | 4312 |
| Parameter type | read-only |
| Documentation | shared_memory_size_in_huge_pages |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
in_hot_standby
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether hot standby is currently active. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | in_hot_standby |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 16.10 |
| Allowed values | 16.10 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 160010 |
| Allowed values | 160010 |
| Parameter type | read-only |
| Documentation | server_version_num |
shared_memory_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of the server's main shared memory area (rounded up to the nearest MB). |
| Data type | integer |
| Default value | 8586 |
| Allowed values | 8586 |
| Parameter type | read-only |
| Documentation | shared_memory_size |
shared_memory_size_in_huge_pages
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of huge pages needed for the main shared memory area. |
| Data type | integer |
| Default value | 4293 |
| Allowed values | 4293 |
| Parameter type | read-only |
| Documentation | shared_memory_size_in_huge_pages |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
in_hot_standby
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether hot standby is currently active. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | in_hot_standby |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
lc_collate
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the collation order locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_collate |
lc_ctype
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the character classification and case conversion locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_ctype |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 15.14 |
| Allowed values | 15.14 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 150014 |
| Allowed values | 150014 |
| Parameter type | read-only |
| Documentation | server_version_num |
shared_memory_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of the server's main shared memory area (rounded up to the nearest MB). |
| Data type | integer |
| Default value | 8586 |
| Allowed values | 8586 |
| Parameter type | read-only |
| Documentation | shared_memory_size |
shared_memory_size_in_huge_pages
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of huge pages needed for the main shared memory area. |
| Data type | integer |
| Default value | 4293 |
| Allowed values | 4293 |
| Parameter type | read-only |
| Documentation | shared_memory_size_in_huge_pages |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
in_hot_standby
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether hot standby is currently active. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | in_hot_standby |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
lc_collate
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the collation order locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_collate |
lc_ctype
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the character classification and case conversion locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_ctype |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 14.19 |
| Allowed values | 14.19 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 140019 |
| Allowed values | 140019 |
| Parameter type | read-only |
| Documentation | server_version_num |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
lc_collate
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the collation order locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_collate |
lc_ctype
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the character classification and case conversion locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_ctype |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Sets the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 13.22 |
| Allowed values | 13.22 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 130022 |
| Allowed values | 130022 |
| Parameter type | read-only |
| Documentation | server_version_num |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
lc_collate
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the collation order locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_collate |
lc_ctype
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the character classification and case conversion locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_ctype |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Sets the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 12.20 |
| Allowed values | 12.20 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 120020 |
| Allowed values | 120020 |
| Parameter type | read-only |
| Documentation | server_version_num |
ssl_library
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Name of the SSL library. |
| Data type | string |
| Default value | OpenSSL |
| Allowed values | OpenSSL |
| Parameter type | read-only |
| Documentation | ssl_library |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |
block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of a disk block. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | block_size |
data_checksums
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether data checksums are turned on for this cluster. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | data_checksums |
data_directory_mode
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Mode of the data directory. |
| Data type | integer |
| Default value | 0700 |
| Allowed values | 0700 |
| Parameter type | read-only |
| Documentation | data_directory_mode |
debug_assertions
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows whether the running server has assertion checks enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation |
integer_datetimes
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Datetimes are integer based. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | integer_datetimes |
lc_collate
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the collation order locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_collate |
lc_ctype
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the character classification and case conversion locale. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_ctype |
max_function_args
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of function arguments. |
| Data type | integer |
| Default value | 100 |
| Allowed values | 100 |
| Parameter type | read-only |
| Documentation | max_function_args |
max_identifier_length
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum identifier length. |
| Data type | integer |
| Default value | 63 |
| Allowed values | 63 |
| Parameter type | read-only |
| Documentation | max_identifier_length |
max_index_keys
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the maximum number of index keys. |
| Data type | integer |
| Default value | 32 |
| Allowed values | 32 |
| Parameter type | read-only |
| Documentation | max_index_keys |
segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the number of pages per disk file. |
| Data type | integer |
| Default value | 131072 |
| Allowed values | 131072 |
| Parameter type | read-only |
| Documentation | segment_size |
server_encoding
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Sets the server (database) character set encoding. |
| Data type | string |
| Default value | UTF8 |
| Allowed values | UTF8 |
| Parameter type | read-only |
| Documentation | server_encoding |
server_version
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version. |
| Data type | string |
| Default value | 11.22 |
| Allowed values | 11.22 |
| Parameter type | read-only |
| Documentation | server_version |
server_version_num
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the server version as an integer. |
| Data type | integer |
| Default value | 110022 |
| Allowed values | 110022 |
| Parameter type | read-only |
| Documentation | server_version_num |
wal_block_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the block size in the write ahead log. |
| Data type | integer |
| Default value | 8192 |
| Allowed values | 8192 |
| Parameter type | read-only |
| Documentation | wal_block_size |
wal_segment_size
| Attribute | Value |
|---|---|
| Category | Preset Options |
| Description | Shows the size of write ahead log segments. |
| Data type | integer |
| Default value | 16777216 |
| Allowed values | 16777216 |
| Parameter type | read-only |
| Documentation | wal_segment_size |