connection-authentication-timeout | int

Sets the maximum allowed time to complete client authentication. Allowed values are: from 1 to 600.

connection-statement-timeout | int

Sets the maximum allowed duration of any statement. Allowed values are: from 0 to 2147483647.

connection_authentication_timeout | int

Default: 60

Deprecated: Use connection-authentication-timeout instead.

Sets the maximum allowed time to complete client authentication. Allowed values are: from 1 to 600.

connection_statement_timeout | int

Deprecated: Use connection-statement-timeout instead.

Sets the maximum allowed duration of any statement. Allowed values are: from 0 to 2147483647.

cpu-parallel-leader-participation | boolean

Controls whether Gather and Gather Merge also run subplans.

cpu_parallel_leader_participation | boolean

Default: True

Deprecated: Use cpu-parallel-leader-participation instead.

Controls whether Gather and Gather Merge also run subplans.

durability-synchronous-commit | string

Sets the current transactions synchronization level. This charm allows only the “on”, “remote_apply” and “remote_write” values to avoid data loss if the primary crashes and there are replicas.

durability-wal-keep-size | int

Sets the minimum size of the WAL file to be kept for the replication. Allowed values are: from 0 to 2147483647.

durability_synchronous_commit | string

Default: on

Deprecated: Use durability-synchronous-commit instead.

Sets the current transactions synchronization level. This charm allows only the “on”, “remote_apply” and “remote_write” values to avoid data loss if the primary crashes and there are replicas.

durability_wal_keep_size | int

Default: 4096

Deprecated: Use durability-wal-keep-size instead.

Sets the minimum size of the WAL file to be kept for the replication. Allowed values are: from 0 to 2147483647.

experimental-max-connections | int

[EXPERIMENTAL] Force set max_connections.

experimental_max_connections | int

Deprecated: Use experimental-max-connections instead.

[EXPERIMENTAL] Force set max_connections.

instance-default-text-search-config | string

Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. Allowed values start with “pg_catalog.” followed by a language name, like “pg_catalog.english”.

instance-max-locks-per-transaction | int

Specifies the maximum amount of memory to be used by maintenance operations, such as "VACUUM", "CREATE INDEX", and "ALTER TABLE ADD FOREIGN KEY". If this value is specified without units, it is taken as kilobytes. Allowed values are: from 64 to 2147483647.

instance-password-encryption | string

Determines the algorithm to use to encrypt the password. Allowed values are: “md5” and “scram-sha-256”.

instance-synchronize-seqscans | boolean

Enable synchronized sequential scans.

instance_default_text_search_config | string

Default: pg_catalog.simple

Deprecated: Use instance-default-text-search-config instead.

Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. Allowed values start with “pg_catalog.” followed by a language name, like “pg_catalog.english”.

instance_max_locks_per_transaction | int

Default: 64

Deprecated: Use instance-max-locks-per-transaction instead.

Specifies the maximum amount of memory to be used by maintenance operations, such as "VACUUM", "CREATE INDEX", and "ALTER TABLE ADD FOREIGN KEY". If this value is specified without units, it is taken as kilobytes. Allowed values are: from 64 to 2147483647.

instance_password_encryption | string

Default: scram-sha-256

Deprecated: Use instance-password-encryption instead.

Determines the algorithm to use to encrypt the password. Allowed values are: “md5” and “scram-sha-256”.

instance_synchronize_seqscans | boolean

Default: True

Deprecated: Use instance-synchronize-seqscans instead.

Enable synchronized sequential scans.

ldap-map | string

List of mapped LDAP group names to PostgreSQL group names, separated by commas. The map is used to assign LDAP synchronized users to PostgreSQL authorization groups. Example: <ldap_group_1>=<psql_group_1>,<ldap_group_2>=<psql_group_2>

ldap-search-filter | string

The LDAP search filter to match users with. Example: (|(uid=$username)(email=$username))

ldap_map | string

Deprecated: Use ldap-map instead.

List of mapped LDAP group names to PostgreSQL group names, separated by commas. The map is used to assign LDAP synchronized users to PostgreSQL authorization groups. Example: <ldap_group_1>=<psql_group_1>,<ldap_group_2>=<psql_group_2>

ldap_search_filter | string

Default: (uid=$username)

Deprecated: Use ldap-search-filter instead.

The LDAP search filter to match users with. Example: (|(uid=$username)(email=$username))

logging-client-min-messages | string

Sets the message levels that are sent to the client. Allowed values are one of 'debug5', 'debug4', 'debug3', 'debug2', 'debug1', 'log', 'notice', 'warning' or 'error'. Each level includes all the levels that follow it. The later the level, the fewer messages are sent.

logging-log-connections | boolean

Logs each successful connection.

logging-log-disconnections | boolean

Logs end of a session, including duration.

logging-log-lock-waits | boolean

Logs long lock waits.

logging-log-min-duration-statement | int

Sets the minimum running time (milliseconds) above which statements will be logged. Allowed values are: from -1 to 2147483647 (-1 disables logging statement durations).

logging-track-functions | string

Collects function-level statistics on database activity. Allowed values are one of 'none', 'pl', 'all'. Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions

logging_client_min_messages | string

Default: notice

Deprecated: Use logging-client-min-messages instead.

Sets the message levels that are sent to the client. Allowed values are one of 'debug5', 'debug4', 'debug3', 'debug2', 'debug1', 'log', 'notice', 'warning' or 'error'. Each level includes all the levels that follow it. The later the level, the fewer messages are sent.

logging_log_connections | boolean

Default: True

Deprecated: Use logging-log-connections instead.

Logs each successful connection.

logging_log_disconnections | boolean

Default: True

Deprecated: Use logging-log-disconnections instead.

Logs end of a session, including duration.

logging_log_lock_waits | boolean

Deprecated: Use logging-log-lock-waits instead.

Logs long lock waits.

logging_log_min_duration_statement | int

Default: -1

Deprecated: Use logging-log-min-duration-statement instead.

Sets the minimum running time (milliseconds) above which statements will be logged. Allowed values are: from -1 to 2147483647 (-1 disables logging statement durations).

logging_track_functions | string

Default: none

Deprecated: Use logging-track-functions instead.

Collects function-level statistics on database activity. Allowed values are one of 'none', 'pl', 'all'. Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions

logical-replication-subscription-request | string

Set of databases corresponding to list of tables with schema notation in JSON format, which will be requested from publiblisher cluster to subscribe on via logical replication. Example: {"<database>": ["<schema>.<table>", ...], ...}

logical_replication_subscription_request | string

Default: {}

Deprecated: Use logical-replication-subscription-request instead.

Set of databases corresponding to list of tables with schema notation in JSON format, which will be requested from publiblisher cluster to subscribe on via logical replication. Example: {"<database>": ["<schema>.<table>", ...], ...}

memory-maintenance-work-mem | int

Sets the maximum memory (KB) to be used for maintenance operations. Allowed values are: from 1024 to 2147483647.

memory-max-prepared-transactions | int

Sets the maximum number of simultaneously prepared transactions. Allowed values are: from 0 to 262143.

memory-shared-buffers | int

Sets the number of shared memory buffers (8 kB) used by the server. This charm allows to set this value up to 40% of the available memory from the unit, as it is unlikely that an allocation of more than that will work better than a smaller amount. Allowed values are: from 16 to 1073741823.

memory-temp-buffers | int

Sets the maximum number of temporary buffers (8 kB) used by each session. Allowed values are: from 100 to 1073741823.

memory-work-mem | int

Sets the maximum memory (KB) to be used for query workspaces. Allowed values are: from 64 to 2147483647.

memory_maintenance_work_mem | int

Default: 65536

Deprecated: Use memory-maintenance-work-mem instead.

Sets the maximum memory (KB) to be used for maintenance operations. Allowed values are: from 1024 to 2147483647.

memory_max_prepared_transactions | int

Deprecated: Use memory-max-prepared-transactions instead.

Sets the maximum number of simultaneously prepared transactions. Allowed values are: from 0 to 262143.

memory_shared_buffers | int

Deprecated: Use memory-shared-buffers instead.

Sets the number of shared memory buffers (8 kB) used by the server. This charm allows to set this value up to 40% of the available memory from the unit, as it is unlikely that an allocation of more than that will work better than a smaller amount. Allowed values are: from 16 to 1073741823.

memory_temp_buffers | int

Default: 1024

Deprecated: Use memory-temp-buffers instead.

Sets the maximum number of temporary buffers (8 kB) used by each session. Allowed values are: from 100 to 1073741823.

memory_work_mem | int

Default: 4096

Deprecated: Use memory-work-mem instead.

Sets the maximum memory (KB) to be used for query workspaces. Allowed values are: from 64 to 2147483647.

optimizer-constraint-exclusion | string

Enables the planner to use constraints to optimize queries. Allowed values are: “on”, “off” and “partition”.

optimizer-cpu-index-tuple-cost | float

Sets the planner's estimate of the cost of processing each index entry during an index scan. Allowed values are: from 0 to 1.80E+308.

optimizer-cpu-operator-cost | float

Sets the planner's estimate of the cost of processing each operator or function call. Allowed values are: from 0 to 1.80E+308.

optimizer-cpu-tuple-cost | float

Sets the planner's estimate of the cost of processing each tuple (row). Allowed values are: from 0 to 1.80E+308.

optimizer-cursor-tuple-fraction | float

Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. Allowed values are: from 0 to 1.

optimizer-default-statistics-target | int

Sets the default statistics target. Allowed values are: from 1 to 10000.

optimizer-enable-async-append | boolean

Enables the planner's use of async append plans.

optimizer-enable-bitmapscan | boolean

Enables the planner's use of bitmap-scan plans.

optimizer-enable-gathermerge | boolean

Enables the planner's use of gather merge plans.

optimizer-enable-hashagg | boolean

Enables the planner's use of hashed aggregation plans.

optimizer-enable-hashjoin | boolean

Enables the planner's use of hash join plans.

optimizer-enable-incremental-sort | boolean

Enables the planner's use of incremental sort steps.

optimizer-enable-indexonlyscan | boolean

Enables the planner's use of index-only-scan plans.

optimizer-enable-indexscan | boolean

Enables the planner's use of index-scan plans.

optimizer-enable-material | boolean

Enables the planner's use of materialization.

optimizer-enable-memoize | boolean

Enables the planner's use of memoization.

optimizer-enable-mergejoin | boolean

Enables the planner's use of merge join plans.

optimizer-enable-nestloop | boolean

Enables the planner's use of nested-loop join plans.

optimizer-enable-parallel-append | boolean

Enables the planner's use of parallel append plans.

optimizer-enable-parallel-hash | boolean

Enables the planner's use of parallel hash plans.

optimizer-enable-partition-pruning | boolean

Enables plan-time and execution-time partition pruning.

optimizer-enable-partitionwise-aggregate | boolean

Enables partitionwise aggregation and grouping.

optimizer-enable-partitionwise-join | boolean

Enables partitionwise join.

optimizer-enable-seqscan | boolean

Enables the planner's use of sequential-scan plans.

optimizer-enable-sort | boolean

Enables the planner's use of explicit sort steps.

optimizer-enable-tidscan | boolean

Enables the planner's use of TID scan plans.

optimizer-from-collapse-limit | int

Sets the FROM-list size beyond which subqueries are not collapsed. Allowed values are: from 1 to 2147483647.

optimizer-geqo | boolean

Enables genetic query optimization.

optimizer-geqo-effort | int

GEQO: effort is used to set the default for other GEQO parameters. Allowed values are: from 1 to 10.

optimizer-geqo-generations | int

GEQO: number of iterations of the algorithm. Allowed values are: from 0 to 2147483647.

optimizer-geqo-pool-size | int

GEQO: number of individuals in the population. Allowed values are: from 0 to 2147483647.

optimizer-geqo-seed | float

GEQO: seed for random path selection. Allowed values are: from 0 to 1.

optimizer-geqo-selection-bias | float

GEQO: selective pressure within the population. Allowed values are: from 1.5 to 2.

optimizer-geqo-threshold | int

Sets the threshold of FROM items beyond which GEQO is used. Allowed values are: from 2 to 2147483647.

optimizer-jit | boolean

Allow JIT compilation.

optimizer-jit-above-cost | float

Perform JIT compilation if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer-jit-inline-above-cost | float

Perform JIT inlining if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer-jit-optimize-above-cost | float

Optimize JIT-compiled functions if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer-join-collapse-limit | int

Sets the FROM-list size beyond which JOIN constructs are not flattened. Allowed values are: from 1 to 2147483647.

optimizer-min-parallel-index-scan-size | int

Sets the minimum amount of index data for a parallel scan. Allowed values are: from 0 to 715827882.

optimizer-min-parallel-table-scan-size | int

Sets the minimum amount of table data for a parallel scan. Allowed values are: from 0 to 715827882.

optimizer-parallel-setup-cost | float

Sets the planner's estimate of the cost of starting up worker processes for parallel query. Allowed values are: from 0 to 1.80E+308.

optimizer-parallel-tuple-cost | float

Sets the planner's estimate of the cost of passing each tuple (row) from worker to leader backend. Allowed values are: from 0 to 1.80E+308.

optimizer_constraint_exclusion | string

Default: partition

Deprecated: Use optimizer-constraint-exclusion instead.

Enables the planner to use constraints to optimize queries. Allowed values are: “on”, “off” and “partition”.

optimizer_cpu_index_tuple_cost | float

Default: 0.005

Deprecated: Use optimizer-cpu-index-tuple-cost instead.

Sets the planner's estimate of the cost of processing each index entry during an index scan. Allowed values are: from 0 to 1.80E+308.

optimizer_cpu_operator_cost | float

Default: 0.0025

Deprecated: Use optimizer-cpu-operator-cost instead.

Sets the planner's estimate of the cost of processing each operator or function call. Allowed values are: from 0 to 1.80E+308.

optimizer_cpu_tuple_cost | float

Default: 0.01

Deprecated: Use optimizer-cpu-tuple-cost instead.

Sets the planner's estimate of the cost of processing each tuple (row). Allowed values are: from 0 to 1.80E+308.

optimizer_cursor_tuple_fraction | float

Default: 0.1

Deprecated: Use optimizer-cursor-tuple-fraction instead.

Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. Allowed values are: from 0 to 1.

optimizer_default_statistics_target | int

Default: 100

Deprecated: Use optimizer-default-statistics-target instead.

Sets the default statistics target. Allowed values are: from 1 to 10000.

optimizer_enable_async_append | boolean

Default: True

Deprecated: Use optimizer-enable-async-append instead.

Enables the planner's use of async append plans.

optimizer_enable_bitmapscan | boolean

Default: True

Deprecated: Use optimizer-enable-bitmapscan instead.

Enables the planner's use of bitmap-scan plans.

optimizer_enable_gathermerge | boolean

Default: True

Deprecated: Use optimizer-enable-gathermerge instead.

Enables the planner's use of gather merge plans.

optimizer_enable_hashagg | boolean

Default: True

Deprecated: Use optimizer-enable-hashagg instead.

Enables the planner's use of hashed aggregation plans.

optimizer_enable_hashjoin | boolean

Default: True

Deprecated: Use optimizer-enable-hashjoin instead.

Enables the planner's use of hash join plans.

optimizer_enable_incremental_sort | boolean

Default: True

Deprecated: Use optimizer-enable-incremental-sort instead.

Enables the planner's use of incremental sort steps.

optimizer_enable_indexonlyscan | boolean

Default: True

Deprecated: Use optimizer-enable-indexonlyscan instead.

Enables the planner's use of index-only-scan plans.

optimizer_enable_indexscan | boolean

Default: True

Deprecated: Use optimizer-enable-indexscan instead.

Enables the planner's use of index-scan plans.

optimizer_enable_material | boolean

Default: True

Deprecated: Use optimizer-enable-material instead.

Enables the planner's use of materialization.

optimizer_enable_memoize | boolean

Default: True

Deprecated: Use optimizer-enable-memoize instead.

Enables the planner's use of memoization.

optimizer_enable_mergejoin | boolean

Default: True

Deprecated: Use optimizer-enable-mergejoin instead.

Enables the planner's use of merge join plans.

optimizer_enable_nestloop | boolean

Default: True

Deprecated: Use optimizer-enable-nestloop instead.

Enables the planner's use of nested-loop join plans.

optimizer_enable_parallel_append | boolean

Default: True

Deprecated: Use optimizer-enable-parallel-append instead.

Enables the planner's use of parallel append plans.

optimizer_enable_parallel_hash | boolean

Default: True

Deprecated: Use optimizer-enable-parallel-hash instead.

Enables the planner's use of parallel hash plans.

optimizer_enable_partition_pruning | boolean

Default: True

Deprecated: Use optimizer-enable-partition-pruning instead.

Enables plan-time and execution-time partition pruning.

optimizer_enable_partitionwise_aggregate | boolean

Deprecated: Use optimizer-enable-partitionwise-aggregate instead.

Enables partitionwise aggregation and grouping.

optimizer_enable_partitionwise_join | boolean

Deprecated: Use optimizer-enable-partitionwise-join instead.

Enables partitionwise join.

optimizer_enable_seqscan | boolean

Default: True

Deprecated: Use optimizer-enable-seqscan instead.

Enables the planner's use of sequential-scan plans.

optimizer_enable_sort | boolean

Default: True

Deprecated: Use optimizer-enable-sort instead.

Enables the planner's use of explicit sort steps.

optimizer_enable_tidscan | boolean

Default: True

Deprecated: Use optimizer-enable-tidscan instead.

Enables the planner's use of TID scan plans.

optimizer_from_collapse_limit | int

Default: 8

Deprecated: Use optimizer-from-collapse-limit instead.

Sets the FROM-list size beyond which subqueries are not collapsed. Allowed values are: from 1 to 2147483647.

optimizer_geqo | boolean

Default: True

Deprecated: Use optimizer-geqo instead.

Enables genetic query optimization.

optimizer_geqo_effort | int

Default: 5

Deprecated: Use optimizer-geqo-effort instead.

GEQO: effort is used to set the default for other GEQO parameters. Allowed values are: from 1 to 10.

optimizer_geqo_generations | int

Deprecated: Use optimizer-geqo-generations instead.

GEQO: number of iterations of the algorithm. Allowed values are: from 0 to 2147483647.

optimizer_geqo_pool_size | int

Deprecated: Use optimizer-geqo-pool-size instead.

GEQO: number of individuals in the population. Allowed values are: from 0 to 2147483647.

optimizer_geqo_seed | float

Deprecated: Use optimizer-geqo-seed instead.

GEQO: seed for random path selection. Allowed values are: from 0 to 1.

optimizer_geqo_selection_bias | float

Default: 2.0

Deprecated: Use optimizer-geqo-selection-bias instead.

GEQO: selective pressure within the population. Allowed values are: from 1.5 to 2.

optimizer_geqo_threshold | int

Default: 12

Deprecated: Use optimizer-geqo-threshold instead.

Sets the threshold of FROM items beyond which GEQO is used. Allowed values are: from 2 to 2147483647.

optimizer_jit | boolean

Default: True

Deprecated: Use optimizer-jit instead.

Allow JIT compilation.

optimizer_jit_above_cost | float

Default: 100000.0

Deprecated: Use optimizer-jit-above-cost instead.

Perform JIT compilation if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer_jit_inline_above_cost | float

Default: 500000.0

Deprecated: Use optimizer-jit-inline-above-cost instead.

Perform JIT inlining if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer_jit_optimize_above_cost | float

Default: 500000.0

Deprecated: Use optimizer-jit-optimize-above-cost instead.

Optimize JIT-compiled functions if query is more expensive. Allowed values are: from -1 to 1.80E+308.

optimizer_join_collapse_limit | int

Default: 8

Deprecated: Use optimizer-join-collapse-limit instead.

Sets the FROM-list size beyond which JOIN constructs are not flattened. Allowed values are: from 1 to 2147483647.

optimizer_min_parallel_index_scan_size | int

Default: 64

Deprecated: Use optimizer-min-parallel-index-scan-size instead.

Sets the minimum amount of index data for a parallel scan. Allowed values are: from 0 to 715827882.

optimizer_min_parallel_table_scan_size | int

Default: 1024

Deprecated: Use optimizer-min-parallel-table-scan-size instead.

Sets the minimum amount of table data for a parallel scan. Allowed values are: from 0 to 715827882.

optimizer_parallel_setup_cost | float

Default: 1000.0

Deprecated: Use optimizer-parallel-setup-cost instead.

Sets the planner's estimate of the cost of starting up worker processes for parallel query. Allowed values are: from 0 to 1.80E+308.

optimizer_parallel_tuple_cost | float

Default: 0.1

Deprecated: Use optimizer-parallel-tuple-cost instead.

Sets the planner's estimate of the cost of passing each tuple (row) from worker to leader backend. Allowed values are: from 0 to 1.80E+308.

pause-after-unit-refresh | string

Default: first

Wait for manual confirmation to resume refresh after these units refresh Allowed values: "all", "first", "none"

plugin-address-standardizer-data-us-enable | boolean

Enable address_standardizer_data_us extension

plugin-address-standardizer-enable | boolean

Enable address_standardizer extension

plugin-audit-enable | boolean

Enable pgAudit extension

plugin-bloom-enable | boolean

Enable bloom extension

plugin-bool-plperl-enable | boolean

Enable bool_plperl extension

plugin-btree-gin-enable | boolean

Enable btree_gin extension

plugin-btree-gist-enable | boolean

Enable btree_gist extension

plugin-citext-enable | boolean

Enable citext extension

plugin-cube-enable | boolean

Enable cube extension

plugin-debversion-enable | boolean

Enable debversion extension

plugin-dict-int-enable | boolean

Enable dict_int extension

plugin-dict-xsyn-enable | boolean

Enable dict_xsyn extension

plugin-earthdistance-enable | boolean

Enable earthdistance extension

plugin-fuzzystrmatch-enable | boolean

Enable fuzzystrmatch extension

plugin-hll-enable | boolean

Enable hll extension

plugin-hstore-enable | boolean

Enable hstore extension

plugin-hypopg-enable | boolean

Enable hypopg extension

plugin-icu-ext-enable | boolean

Enable icu_ext extension

plugin-intarray-enable | boolean

Enable intarray extension

plugin-ip4r-enable | boolean

Enable ip4r extension

plugin-isn-enable | boolean

Enable isn extension

plugin-jsonb-plperl-enable | boolean

Enable jsonb_plperl extension

plugin-lo-enable | boolean

Enable lo extension

plugin-ltree-enable | boolean

Enable ltree extension

plugin-old-snapshot-enable | boolean

Enable old_snapshot extension

plugin-orafce-enable | boolean

Enable orafce extension

plugin-pg-freespacemap-enable | boolean

Enable pg_freespacemap extension

plugin-pg-similarity-enable | boolean

Enable pg_similarity extension

plugin-pg-trgm-enable | boolean

Enable pg_trgm extension

plugin-pg-visibility-enable | boolean

Enable pg_visibility extension

plugin-pgrowlocks-enable | boolean

Enable pgrowlocks extension

plugin-pgstattuple-enable | boolean

Enable pgstattuple extension

plugin-plperl-enable | boolean

Enable plperl extension

plugin-plpython3u-enable | boolean

Enable PL/Python extension

plugin-pltcl-enable | boolean

Enable pltcl extension

plugin-postgis-enable | boolean

Enable postgis extension

plugin-postgis-raster-enable | boolean

Enable postgis_raster extension

plugin-postgis-tiger-geocoder-enable | boolean

Enable postgis_tiger_geocoder extension

plugin-postgis-topology-enable | boolean

Enable postgis_topology extension

plugin-prefix-enable | boolean

Enable prefix extension

plugin-rdkit-enable | boolean

Enable rdkit extension

plugin-seg-enable | boolean

Enable seg extension

plugin-spi-enable | boolean

Enable spi extension

plugin-tablefunc-enable | boolean

Enable tablefunc extension

plugin-tcn-enable | boolean

Enable tcn extension

plugin-tds-fdw-enable | boolean

Enable tds_fdw extension

plugin-timescaledb-enable | boolean

Enable timescaledb extension

plugin-tsm-system-rows-enable | boolean

Enable tsm_system_rows extension

plugin-tsm-system-time-enable | boolean

Enable tsm_system_time extension

plugin-unaccent-enable | boolean

Enable unaccent extension

plugin-uuid-ossp-enable | boolean

Enable uuid_ossp extension

plugin-vector-enable | boolean

Enable pgvector extension

plugin_address_standardizer_data_us_enable | boolean

Deprecated: Use plugin-address-standardizer-data-us-enable instead.

Enable address_standardizer_data_us extension

plugin_address_standardizer_enable | boolean

Deprecated: Use plugin-address-standardizer-enable instead.

Enable address_standardizer extension

plugin_audit_enable | boolean

Default: True

Deprecated: Use plugin-audit-enable instead.

Enable pgAudit extension

plugin_bloom_enable | boolean

Deprecated: Use plugin-bloom-enable instead.

Enable bloom extension

plugin_bool_plperl_enable | boolean

Deprecated: Use plugin-bool-plperl-enable instead.

Enable bool_plperl extension

plugin_btree_gin_enable | boolean

Deprecated: Use plugin-btree-gin-enable instead.

Enable btree_gin extension

plugin_btree_gist_enable | boolean

Deprecated: Use plugin-btree-gist-enable instead.

Enable btree_gist extension

plugin_citext_enable | boolean

Deprecated: Use plugin-citext-enable instead.

Enable citext extension

plugin_cube_enable | boolean

Deprecated: Use plugin-cube-enable instead.

Enable cube extension

plugin_debversion_enable | boolean

Deprecated: Use plugin-debversion-enable instead.

Enable debversion extension

plugin_dict_int_enable | boolean

Deprecated: Use plugin-dict-int-enable instead.

Enable dict_int extension

plugin_dict_xsyn_enable | boolean

Deprecated: Use plugin-dict-xsyn-enable instead.

Enable dict_xsyn extension

plugin_earthdistance_enable | boolean

Deprecated: Use plugin-earthdistance-enable instead.

Enable earthdistance extension

plugin_fuzzystrmatch_enable | boolean

Deprecated: Use plugin-fuzzystrmatch-enable instead.

Enable fuzzystrmatch extension

plugin_hll_enable | boolean

Deprecated: Use plugin-hll-enable instead.

Enable hll extension

plugin_hstore_enable | boolean

Deprecated: Use plugin-hstore-enable instead.

Enable hstore extension

plugin_hypopg_enable | boolean

Deprecated: Use plugin-hypopg-enable instead.

Enable hypopg extension

plugin_icu_ext_enable | boolean

Deprecated: Use plugin-icu-ext-enable instead.

Enable icu_ext extension

plugin_intarray_enable | boolean

Deprecated: Use plugin-intarray-enable instead.

Enable intarray extension

plugin_ip4r_enable | boolean

Deprecated: Use plugin-ip4r-enable instead.

Enable ip4r extension

plugin_isn_enable | boolean

Deprecated: Use plugin-isn-enable instead.

Enable isn extension

plugin_jsonb_plperl_enable | boolean

Deprecated: Use plugin-jsonb-plperl-enable instead.

Enable jsonb_plperl extension

plugin_lo_enable | boolean

Deprecated: Use plugin-lo-enable instead.

Enable lo extension

plugin_ltree_enable | boolean

Deprecated: Use plugin-ltree-enable instead.

Enable ltree extension

plugin_old_snapshot_enable | boolean

Deprecated: Use plugin-old-snapshot-enable instead.

Enable old_snapshot extension

plugin_orafce_enable | boolean

Deprecated: Use plugin-orafce-enable instead.

Enable orafce extension

plugin_pg_freespacemap_enable | boolean

Deprecated: Use plugin-pg-freespacemap-enable instead.

Enable pg_freespacemap extension

plugin_pg_similarity_enable | boolean

Deprecated: Use plugin-pg-similarity-enable instead.

Enable pg_similarity extension

plugin_pg_trgm_enable | boolean

Deprecated: Use plugin-pg-trgm-enable instead.

Enable pg_trgm extension

plugin_pg_visibility_enable | boolean

Deprecated: Use plugin-pg-visibility-enable instead.

Enable pg_visibility extension

plugin_pgrowlocks_enable | boolean

Deprecated: Use plugin-pgrowlocks-enable instead.

Enable pgrowlocks extension

plugin_pgstattuple_enable | boolean

Deprecated: Use plugin-pgstattuple-enable instead.

Enable pgstattuple extension

plugin_plperl_enable | boolean

Deprecated: Use plugin-plperl-enable instead.

Enable plperl extension

plugin_plpython3u_enable | boolean

Deprecated: Use plugin-plpython3u-enable instead.

Enable PL/Python extension

plugin_pltcl_enable | boolean

Deprecated: Use plugin-pltcl-enable instead.

Enable pltcl extension

plugin_postgis_enable | boolean

Deprecated: Use plugin-postgis-enable instead.

Enable postgis extension

plugin_postgis_raster_enable | boolean

Deprecated: Use plugin-postgis-raster-enable instead.

Enable postgis_raster extension

plugin_postgis_tiger_geocoder_enable | boolean

Deprecated: Use plugin-postgis-tiger-geocoder-enable instead.

Enable postgis_tiger_geocoder extension

plugin_postgis_topology_enable | boolean

Deprecated: Use plugin-postgis-topology-enable instead.

Enable postgis_topology extension

plugin_prefix_enable | boolean

Deprecated: Use plugin-prefix-enable instead.

Enable prefix extension

plugin_rdkit_enable | boolean

Deprecated: Use plugin-rdkit-enable instead.

Enable rdkit extension

plugin_seg_enable | boolean

Deprecated: Use plugin-seg-enable instead.

Enable seg extension

plugin_spi_enable | boolean

Deprecated: Use plugin-spi-enable instead.

Enable spi extension

plugin_tablefunc_enable | boolean

Deprecated: Use plugin-tablefunc-enable instead.

Enable tablefunc extension

plugin_tcn_enable | boolean

Deprecated: Use plugin-tcn-enable instead.

Enable tcn extension

plugin_tds_fdw_enable | boolean

Deprecated: Use plugin-tds-fdw-enable instead.

Enable tds_fdw extension

plugin_timescaledb_enable | boolean

Deprecated: Use plugin-timescaledb-enable instead.

Enable timescaledb extension

plugin_tsm_system_rows_enable | boolean

Deprecated: Use plugin-tsm-system-rows-enable instead.

Enable tsm_system_rows extension

plugin_tsm_system_time_enable | boolean

Deprecated: Use plugin-tsm-system-time-enable instead.

Enable tsm_system_time extension

plugin_unaccent_enable | boolean

Deprecated: Use plugin-unaccent-enable instead.

Enable unaccent extension

plugin_uuid_ossp_enable | boolean

Deprecated: Use plugin-uuid-ossp-enable instead.

Enable uuid_ossp extension

plugin_vector_enable | boolean

Deprecated: Use plugin-vector-enable instead.

Enable pgvector extension

profile | string

Default: production

Profile representing the scope of deployment, and used to tune resource allocation. Allowed values are: “production” and “testing”. Production will tune postgresql for maximum performance while testing will tune for minimal running performance.

profile-limit-memory | int

Amount of memory in Megabytes to limit PostgreSQL and associated process to. If unset, this will be decided according to the default memory limit in the selected profile. Only comes into effect when the production profile is selected.

profile_limit_memory | int

Deprecated: Use profile-limit-memory instead.

Amount of memory in Megabytes to limit PostgreSQL and associated process to. If unset, this will be decided according to the default memory limit in the selected profile. Only comes into effect when the production profile is selected.

request-array-nulls | boolean

Enable input of NULL elements in arrays.

request-backslash-quote | string

Sets whether "'" is allowed in string literals. Allowed values are "safe_encoding" and "on" and "off". Safe_encoding is allow only if client encoding does not allow ASCII \ within a multibyte character.

request-date-style | string

Sets the display format for date and time values. Allowed formats are explained in https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DATESTYLE.

request-deadlock-timeout | int

Sets the time to wait on a lock before checking for deadlock. Allowed values are: from 1 to 2147483647.

request-default-transaction-deferrable | boolean

Sets the default deferrable status of new transactions.

request-default-transaction-isolation | string

Sets the transaction isolation level of each new transaction. Allowed values are one of 'serializable', 'repeatable read', 'read committed', 'read uncommitted'. Read commited or read uncommited is a statement can only see rows committed before it began. Repeatable read is all statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction. Serializable is all statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction.

request-default-transaction-read-only | boolean

Sets the default read-only status of new transactions.

request-escape-string-warning | boolean

Warn about backslash escapes in ordinary string literals.

request-lock-timeout | int

Sets the maximum allowed duration of any wait for a lock. Allowed values are: from 0 to 2147483647.

request-standard-conforming-strings | boolean

Causes ... strings to treat backslashes literally.

request-time-zone | string

Sets the time zone for displaying and interpreting time stamps. Allowed values are the ones from IANA time zone data, a time zone abbreviation like PST and POSIX-style time zone specifications.

request-track-activity-query-size | int

Sets the size reserved for pg_stat_activity.query, in bytes. Allowed values are: from 100 to 1048576.

request-transform-null-equals | boolean

Treats "expr=NULL" as "expr IS NULL"

request-xmlbinary | string

Sets how binary values are to be encoded in XML. Allowed values are one of 'base64', 'hex'.

request-xmloption | string

Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments. Allowed values are one of 'content', 'document'.

request_array_nulls | boolean

Default: True

Deprecated: Use request-array-nulls instead.

Enable input of NULL elements in arrays.

request_backslash_quote | string

Default: safe_encoding

Deprecated: Use request-backslash-quote instead.

Sets whether "'" is allowed in string literals. Allowed values are "safe_encoding" and "on" and "off". Safe_encoding is allow only if client encoding does not allow ASCII \ within a multibyte character.

request_date_style | string

Default: ISO, MDY

Deprecated: Use request-date-style instead.

Sets the display format for date and time values. Allowed formats are explained in https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DATESTYLE.

request_deadlock_timeout | int

Default: 1000

Deprecated: Use request-deadlock-timeout instead.

Sets the time to wait on a lock before checking for deadlock. Allowed values are: from 1 to 2147483647.

request_default_transaction_deferrable | boolean

Deprecated: Use request-default-transaction-deferrable instead.

Sets the default deferrable status of new transactions.

request_default_transaction_isolation | string

Default: read committed

Deprecated: Use request-default-transaction-isolation instead.

Sets the transaction isolation level of each new transaction. Allowed values are one of 'serializable', 'repeatable read', 'read committed', 'read uncommitted'. Read commited or read uncommited is a statement can only see rows committed before it began. Repeatable read is all statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction. Serializable is all statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction.

request_default_transaction_read_only | boolean

Deprecated: Use request-default-transaction-read-only instead.

Sets the default read-only status of new transactions.

request_escape_string_warning | boolean

Default: True

Deprecated: Use request-escape-string-warning instead.

Warn about backslash escapes in ordinary string literals.

request_lock_timeout | int

Deprecated: Use request-lock-timeout instead.

Sets the maximum allowed duration of any wait for a lock. Allowed values are: from 0 to 2147483647.

request_standard_conforming_strings | boolean

Default: True

Deprecated: Use request-standard-conforming-strings instead.

Causes ... strings to treat backslashes literally.

request_time_zone | string

Default: UTC

Deprecated: Use request-time-zone instead.

Sets the time zone for displaying and interpreting time stamps. Allowed values are the ones from IANA time zone data, a time zone abbreviation like PST and POSIX-style time zone specifications.

request_track_activity_query_size | int

Default: 1024

Deprecated: Use request-track-activity-query-size instead.

Sets the size reserved for pg_stat_activity.query, in bytes. Allowed values are: from 100 to 1048576.

request_transform_null_equals | boolean

Deprecated: Use request-transform-null-equals instead.

Treats "expr=NULL" as "expr IS NULL"

request_xmlbinary | string

Default: base64

Deprecated: Use request-xmlbinary instead.

Sets how binary values are to be encoded in XML. Allowed values are one of 'base64', 'hex'.

request_xmloption | string

Default: content

Deprecated: Use request-xmloption instead.

Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments. Allowed values are one of 'content', 'document'.

response-bytea-output | string

Sets the output format for bytes. Allowed values are: “escape” and “hex”.

response-exit-on-error | boolean

Terminate session on any error.

response-extra-float-digits | int

Sets the number of digits displayed for floating-point values. Allowed values are: from -15 to 3.

response-gin-fuzzy-search-limit | int

Sets the maximum allowed result for exact search by GIN. Allowed values are: from 0 to 2147483647.

response-lc-monetary | string

Sets the locale for formatting monetary amounts. Allowed values are the locales available in the unit.

response-lc-numeric | string

Sets the locale for formatting numbers. Allowed values are the locales available in the unit.

response-lc-time | string

Sets the locale for formatting date and time values. Allowed values are the locales available in the unit.

response_bytea_output | string

Default: hex

Deprecated: Use response-bytea-output instead.

Sets the output format for bytes. Allowed values are: “escape” and “hex”.

response_exit_on_error | boolean

Deprecated: Use response-exit-on-error instead.

Terminate session on any error.

response_extra_float_digits | int

Default: 1

Deprecated: Use response-extra-float-digits instead.

Sets the number of digits displayed for floating-point values. Allowed values are: from -15 to 3.

response_gin_fuzzy_search_limit | int

Deprecated: Use response-gin-fuzzy-search-limit instead.

Sets the maximum allowed result for exact search by GIN. Allowed values are: from 0 to 2147483647.

response_lc_monetary | string

Default: C

Deprecated: Use response-lc-monetary instead.

Sets the locale for formatting monetary amounts. Allowed values are the locales available in the unit.

response_lc_numeric | string

Default: C

Deprecated: Use response-lc-numeric instead.

Sets the locale for formatting numbers. Allowed values are the locales available in the unit.

response_lc_time | string

Default: C

Deprecated: Use response-lc-time instead.

Sets the locale for formatting date and time values. Allowed values are the locales available in the unit.

session-idle-in-transaction-session-timeout | int

Sets the maximum allowed idle time between queries, when in a transaction. Allowed values are: from 0 to 2147483647.

session_idle_in_transaction_session_timeout | int

Deprecated: Use session-idle-in-transaction-session-timeout instead.

Sets the maximum allowed idle time between queries, when in a transaction. Allowed values are: from 0 to 2147483647.

storage-bgwriter-lru-maxpages | int

Background writer maximum number of LRU pages to flush per round. Allowed values are: from 0 to 1073741823.

storage-bgwriter-lru-multiplier | float

Multiple of the average buffer usage to free per round. Allowed values are: from 0 to 10.

storage-default-table-access-method | string

Sets the default table access method for new tables. These entries can be created using the CREATE ACCESS METHOD SQL command.

storage-gin-pending-list-limit | int

Sets the maximum size of the pending list for GIN index. Allowed values are: from 64 to 2147483647.

storage-old-snapshot-threshold | int

Time before a snapshot is too old to read pages changed after the snapshot was taken. Allowed values are: from -1 to 86400.

storage_bgwriter_lru_maxpages | int

Default: 100

Deprecated: Use storage-bgwriter-lru-maxpages instead.

Background writer maximum number of LRU pages to flush per round. Allowed values are: from 0 to 1073741823.

storage_bgwriter_lru_multiplier | float

Default: 2.0

Deprecated: Use storage-bgwriter-lru-multiplier instead.

Multiple of the average buffer usage to free per round. Allowed values are: from 0 to 10.

storage_default_table_access_method | string

Default: heap

Deprecated: Use storage-default-table-access-method instead.

Sets the default table access method for new tables. These entries can be created using the CREATE ACCESS METHOD SQL command.

storage_gin_pending_list_limit | int

Default: 4096

Deprecated: Use storage-gin-pending-list-limit instead.

Sets the maximum size of the pending list for GIN index. Allowed values are: from 64 to 2147483647.

storage_old_snapshot_threshold | int

Default: -1

Deprecated: Use storage-old-snapshot-threshold instead.

Time before a snapshot is too old to read pages changed after the snapshot was taken. Allowed values are: from -1 to 86400.

synchronous-node-count | string

Sets the number of synchronous nodes to be maintained in the cluster. Should be either "all", "majority" or a positive integer value.

synchronous_node_count | string

Default: all

Deprecated: Use synchronous-node-count instead.

Sets the number of synchronous nodes to be maintained in the cluster. Should be either "all", "majority" or a positive integer value.

system-users | secret

Configure the internal system users and their passwords. The passwords will be auto-generated if this option is not set. It is for internal use only and SHOULD NOT be used by applications. This needs to be a Juju Secret URI pointing to a secret that contains the following content: <username>: <password>. Possible users: backup, monitoring, operator, replication, rewind.

vacuum-autovacuum-analyze-scale-factor | float

Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.1, means 10% of table size. Allowed values are: from 0 to 100.

vacuum-autovacuum-analyze-threshold | int

Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. Allowed values are: from 0 to 2147483647.

vacuum-autovacuum-freeze-max-age | int

Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. Allowed values are: from 100000 to 2000000000.

vacuum-autovacuum-naptime | int

Time to sleep between autovacuum runs. Allowed values are: from 1 to 2147483.

vacuum-autovacuum-vacuum-cost-delay | float

Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. Allowed values are: from -1 to 100 (-1 tells PostgreSQL to use the regular vacuum_cost_delay value).

vacuum-autovacuum-vacuum-cost-limit | int

Vacuum cost amount available before napping, for autovacuum. Allowed values are: from -1 to 10000.

vacuum-autovacuum-vacuum-insert-scale-factor | float

Number of tuple inserts prior to vacuum as a fraction of reltuples. Allowed values are: from 0 to 100.

vacuum-autovacuum-vacuum-insert-threshold | int

Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. Allowed values are: from -1 to 2147483647.

vacuum-autovacuum-vacuum-scale-factor | float

Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.2, means 20% of table size. Allowed values are: from 0 to 100.

vacuum-autovacuum-vacuum-threshold | int

Minimum number of tuple updates or deletes prior to vacuum. Allowed values are: from 0 to 2147483647.

vacuum-vacuum-cost-delay | float

Vacuum cost delay in milliseconds. Allowed values are: from 0 to 100.

vacuum-vacuum-cost-limit | int

Vacuum cost amount available before napping. Allowed values are: from 1 to 10000.

vacuum-vacuum-cost-page-dirty | int

Vacuum cost for a page dirtied by vacuum. Allowed values are: from 0 to 10000.

vacuum-vacuum-cost-page-hit | int

Vacuum cost for a page found in the buffer cache. Allowed values are: from 0 to 10000.

vacuum-vacuum-cost-page-miss | int

Vacuum cost for a page not found in the buffer cache. Allowed values are: from 0 to 10000.

vacuum-vacuum-failsafe-age | int

Age at which VACUUM should trigger failsafe to avoid a wraparound outage. Allowed values are: from 0 to 2100000000.

vacuum-vacuum-freeze-min-age | int

Minimum age at which VACUUM should freeze a table row. Allowed values are: from 0 to 1000000000.

vacuum-vacuum-freeze-table-age | int

Age (in transactions) at which VACUUM should scan whole table to freeze tuples. Allowed values are: from 0 to 2000000000.

vacuum-vacuum-multixact-failsafe-age | int

Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage. Allowed values are: from 0 to 2100000000.

vacuum-vacuum-multixact-freeze-min-age | int

Minimum age at which VACUUM should freeze a MultiXactId in a table row. Allowed values are: from 0 to 1000000000.

vacuum-vacuum-multixact-freeze-table-age | int

Multixact age at which VACUUM should scan whole table to freeze tuples. Allowed values are: from 0 to 2000000000.

vacuum_autovacuum_analyze_scale_factor | float

Default: 0.1

Deprecated: Use vacuum-autovacuum-analyze-scale-factor instead.

Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.1, means 10% of table size. Allowed values are: from 0 to 100.

vacuum_autovacuum_analyze_threshold | int

Default: 50

Deprecated: Use vacuum-autovacuum-analyze-threshold instead.

Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. Allowed values are: from 0 to 2147483647.

vacuum_autovacuum_freeze_max_age | int

Default: 200000000

Deprecated: Use vacuum-autovacuum-freeze-max-age instead.

Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. Allowed values are: from 100000 to 2000000000.

vacuum_autovacuum_naptime | int

Default: 60

Deprecated: Use vacuum-autovacuum-naptime instead.

Time to sleep between autovacuum runs. Allowed values are: from 1 to 2147483.

vacuum_autovacuum_vacuum_cost_delay | float

Default: 2.0

Deprecated: Use vacuum-autovacuum-vacuum-cost-delay instead.

Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. Allowed values are: from -1 to 100 (-1 tells PostgreSQL to use the regular vacuum_cost_delay value).

vacuum_autovacuum_vacuum_cost_limit | int

Default: -1

Deprecated: Use vacuum-autovacuum-vacuum-cost-limit instead.

Vacuum cost amount available before napping, for autovacuum. Allowed values are: from -1 to 10000.

vacuum_autovacuum_vacuum_insert_scale_factor | float

Default: 0.2

Deprecated: Use vacuum-autovacuum-vacuum-insert-scale-factor instead.

Number of tuple inserts prior to vacuum as a fraction of reltuples. Allowed values are: from 0 to 100.

vacuum_autovacuum_vacuum_insert_threshold | int

Default: 1000

Deprecated: Use vacuum-autovacuum-vacuum-insert-threshold instead.

Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. Allowed values are: from -1 to 2147483647.

vacuum_autovacuum_vacuum_scale_factor | float

Default: 0.2

Deprecated: Use vacuum-autovacuum-vacuum-scale-factor instead.

Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.2, means 20% of table size. Allowed values are: from 0 to 100.

vacuum_autovacuum_vacuum_threshold | int

Default: 50

Deprecated: Use vacuum-autovacuum-vacuum-threshold instead.

Minimum number of tuple updates or deletes prior to vacuum. Allowed values are: from 0 to 2147483647.

vacuum_vacuum_cost_delay | float

Deprecated: Use vacuum-vacuum-cost-delay instead.

Vacuum cost delay in milliseconds. Allowed values are: from 0 to 100.

vacuum_vacuum_cost_limit | int

Default: 200

Deprecated: Use vacuum-vacuum-cost-limit instead.

Vacuum cost amount available before napping. Allowed values are: from 1 to 10000.

vacuum_vacuum_cost_page_dirty | int

Default: 20

Deprecated: Use vacuum-vacuum-cost-page-dirty instead.

Vacuum cost for a page dirtied by vacuum. Allowed values are: from 0 to 10000.

vacuum_vacuum_cost_page_hit | int

Default: 1

Deprecated: Use vacuum-vacuum-cost-page-hit instead.

Vacuum cost for a page found in the buffer cache. Allowed values are: from 0 to 10000.

vacuum_vacuum_cost_page_miss | int

Default: 2

Deprecated: Use vacuum-vacuum-cost-page-miss instead.

Vacuum cost for a page not found in the buffer cache. Allowed values are: from 0 to 10000.

vacuum_vacuum_failsafe_age | int

Default: 1600000000

Deprecated: Use vacuum-vacuum-failsafe-age instead.

Age at which VACUUM should trigger failsafe to avoid a wraparound outage. Allowed values are: from 0 to 2100000000.

vacuum_vacuum_freeze_min_age | int

Default: 50000000

Deprecated: Use vacuum-vacuum-freeze-min-age instead.

Minimum age at which VACUUM should freeze a table row. Allowed values are: from 0 to 1000000000.

vacuum_vacuum_freeze_table_age | int

Default: 150000000

Deprecated: Use vacuum-vacuum-freeze-table-age instead.

Age (in transactions) at which VACUUM should scan whole table to freeze tuples. Allowed values are: from 0 to 2000000000.

vacuum_vacuum_multixact_failsafe_age | int

Default: 1600000000

Deprecated: Use vacuum-vacuum-multixact-failsafe-age instead.

Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage. Allowed values are: from 0 to 2100000000.

vacuum_vacuum_multixact_freeze_min_age | int

Default: 5000000

Deprecated: Use vacuum-vacuum-multixact-freeze-min-age instead.

Minimum age at which VACUUM should freeze a MultiXactId in a table row. Allowed values are: from 0 to 1000000000.

vacuum_vacuum_multixact_freeze_table_age | int

Default: 150000000

Deprecated: Use vacuum-vacuum-multixact-freeze-table-age instead.

Multixact age at which VACUUM should scan whole table to freeze tuples. Allowed values are: from 0 to 2000000000.

Channel	Revision	Published	Runs on
latest/stable	591	10 Apr 2025	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable	239	09 Feb 2022	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable	226	01 Apr 2021	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable	553	04 Feb 2025	Ubuntu 22.04
14/stable	552	04 Feb 2025	Ubuntu 22.04
14/candidate	593	16 Apr 2025	Ubuntu 22.04
14/candidate	592	16 Apr 2025	Ubuntu 22.04
14/beta	605	27 Apr 2025	Ubuntu 22.04
14/beta	606	27 Apr 2025	Ubuntu 22.04
14/edge	908	Today	Ubuntu 22.04
14/edge	907	Today	Ubuntu 22.04
16/stable	843	11 Jul 2025	Ubuntu 24.04
16/stable	844	11 Jul 2025	Ubuntu 24.04
16/candidate	843	11 Jul 2025	Ubuntu 24.04
16/candidate	844	11 Jul 2025	Ubuntu 24.04
16/beta	843	11 Jul 2025	Ubuntu 24.04
16/beta	844	11 Jul 2025	Ubuntu 24.04
16/edge	904	15 Sep 2025	Ubuntu 24.04
16/edge	903	15 Sep 2025	Ubuntu 24.04

Charmed PostgreSQL