Preset Options
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.3 |
| Allowed values | 16.3 |
| 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 | 160003 |
| Allowed values | 160003 |
| 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 | 8567 |
| Allowed values | 8567 |
| 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 | 4284 |
| Allowed values | 4284 |
| 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.7 |
| Allowed values | 15.7 |
| 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 | 150007 |
| Allowed values | 150007 |
| 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 | 8567 |
| Allowed values | 8567 |
| 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 | 4284 |
| Allowed values | 4284 |
| 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.12 |
| Allowed values | 14.12 |
| 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 | 140012 |
| Allowed values | 140012 |
| 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.15 |
| Allowed values | 13.15 |
| 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 | 130015 |
| Allowed values | 130015 |
| 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.19 |
| Allowed values | 12.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 | 120019 |
| Allowed values | 120019 |
| 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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for