---
title: Charmhub | Deploy Charmed PostgreSQL VM Bundle using Charmhub - The Open Operator
  Collection
description: Deploy the latest version of Charmed PostgreSQL VM Bundle on any cloud.
url: https://charmhub.io/postgresql-bundle/configurations/postgresql
---

##### We've discontinued the registration of new Bundles

New Bundle registrations are no longer accepted. Existing bundles remain functional. We recommend using the Juju Terraform Provider for new deployments.

[Learn more](https://discourse.charmhub.io/t/discontinuing-new-charmhub-bundle-registrations/15344)

# Charmed PostgreSQL VM Bundle

[Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical")
| bundle

* [Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical")
  | bundle
* [Databases](https://charmhub.io/?filter=databases)

Platform:

14/edge 385

```
juju deploy postgresql-bundle --channel 14/edge
```

[Learn to deploy on juju >](https://juju.is/docs/juju/manage-applications)

* [Data Integrator](https://charmhub.io/postgresql-bundle/configurations/data-integrator)
* [Grafana Agent](https://charmhub.io/postgresql-bundle/configurations/grafana-agent)
* [Landscape Client](https://charmhub.io/postgresql-bundle/configurations/landscape-client)
* [Pgbouncer](https://charmhub.io/postgresql-bundle/configurations/pgbouncer)
* [Pgbouncer](https://charmhub.io/postgresql-bundle/configurations/pgbouncer)
* [Postgresql](https://charmhub.io/postgresql-bundle/configurations/postgresql)
* [Postgresql Test App](https://charmhub.io/postgresql-bundle/configurations/postgresql-test-app)
* [S3 Integrator](https://charmhub.io/postgresql-bundle/configurations/s3-integrator)
* [Self Signed Certificates](https://charmhub.io/postgresql-bundle/configurations/self-signed-certificates)
* [Sysbench](https://charmhub.io/postgresql-bundle/configurations/sysbench)
* [Ubuntu Advantage](https://charmhub.io/postgresql-bundle/configurations/ubuntu-advantage)

[Learn about configurations >](https://juju.is/docs/juju/configuration#heading--application-configuration)

* 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-max-logical-replication-workers | string

  Default: auto

  Sets the maximum number of logical replication workers. Should be either "auto"
  or a positive integer value. Restart is required when changed.
  auto = max\_worker\_processes.
* cpu-max-parallel-apply-workers-per-subscription | string

  Default: auto

  Sets the maximum number of parallel apply workers per subscription.
  Should be either "auto" or a positive integer value.
  auto = max\_worker\_processes.
* cpu-max-parallel-maintenance-workers | string

  Default: auto

  Sets the maximum number of workers that can be used for parallel maintenance operations
  like CREATE INDEX. Should be either "auto" or a positive integer value.
  Cannot exceed max\_parallel\_workers.
  auto = max\_worker\_processes.
* cpu-max-parallel-workers | string

  Default: auto

  Sets the maximum number of workers that can be used for parallel operations.
  Should be either "auto" or a positive integer value. Cannot exceed max\_worker\_processes.
  auto = max\_worker\_processes.
* cpu-max-sync-workers-per-subscription | string

  Default: auto

  Sets the maximum number of synchronization workers per subscription.
  Should be either "auto" or a positive integer value.
  auto = max\_worker\_processes.
* cpu-max-worker-processes | string

  Default: auto

  Sets the maximum number of background processes that the system can support.
  Should be either "auto" or a positive integer value.
  auto = minimum(8, 2 \* vCores). Value will be capped at 10 \* vCores if exceeded.
  Restart is required when changed.
* cpu-parallel-leader-participation | boolean

  Controls whether Gather and Gather Merge also run subplans.
* cpu-wal-compression | boolean

  Default: True

  Enable compression of full-page writes written in WAL. Compression reduces
  the I/O needed for local storage and replication.
  Default is on (true).
* cpu\_parallel\_leader\_participation | boolean

  Default: True

  Deprecated: Use cpu-parallel-leader-participation instead.
  Controls whether Gather and Gather Merge also run subplans.
* durability-maximum-lag-on-failover | int

  Default: 1048576

  The amount of transactions that can be lost in bytes to consider failover is safe.
  Default is 1048576.
* 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
* 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-pg-stat-statements-save | boolean

  Specifies whether to save statement statistics across server shutdowns.
* optimizer-pg-stat-statements-track | string

  Default: top

  Controls which statements are counted by the pg\_stat\_statements.
  Allowed values are: none, top, all.
* optimizer-pg-stat-statements-track-utility | boolean

  Default: True

  Controls whether utility commands are tracked by pg\_stat\_statements.
* optimizer-track-functions | string

  Default: none

  Enables tracking of function call counts and time used.
  Allowed values are: pl, all, none.
* optimizer-track-io-timing | boolean

  Enables timing of database I/O calls.
* optimizer-track-wal-io-timing | boolean

  Enables timing of WAL I/O calls.
* 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-stat-statements-enable | boolean

  Enable pg\_stat\_statements 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-hot-standby-feedback | boolean

  Send feedback to the primary or upstream standby about queries currently executing on
  the standby.
  Warning: enabling can cause database bloat on the Primary for some workloads.
  Default is false.
* 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-mode-strict | boolean

  Default: True

  Enforce transactions to be committed on Primary and at least one more synchronous node.
  Default is true.
* 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.