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 17.0
Allowed values 17.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 170000
Allowed values 170000
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 8603
Allowed values 8603
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 4302
Allowed values 4302
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.4
Allowed values 16.4
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 160004
Allowed values 160004
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 8566
Allowed values 8566
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 4283
Allowed values 4283
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.8
Allowed values 15.8
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 150008
Allowed values 150008
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 8566
Allowed values 8566
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 4283
Allowed values 4283
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.13
Allowed values 14.13
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 140013
Allowed values 140013
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.16
Allowed values 13.16
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 130016
Allowed values 130016
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