PgBouncer

Channel Revision Published Runs on
latest/stable 5 17 Jan 2022
Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04
1/stable 397 11 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/stable 396 11 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/stable 395 11 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/stable 394 11 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/candidate 397 02 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/candidate 396 02 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/candidate 395 02 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/candidate 394 02 Sep 2024
Ubuntu 22.04 Ubuntu 20.04
1/beta 397 29 Aug 2024
Ubuntu 22.04 Ubuntu 20.04
1/beta 396 29 Aug 2024
Ubuntu 22.04 Ubuntu 20.04
1/beta 395 29 Aug 2024
Ubuntu 22.04 Ubuntu 20.04
1/beta 394 29 Aug 2024
Ubuntu 22.04 Ubuntu 20.04
1/edge 514 Yesterday
Ubuntu 22.04 Ubuntu 20.04
1/edge 513 Yesterday
Ubuntu 22.04 Ubuntu 20.04
1/edge 512 Yesterday
Ubuntu 22.04 Ubuntu 20.04
1/edge 511 Yesterday
Ubuntu 22.04 Ubuntu 20.04
juju deploy pgbouncer
Show information

Platform:

Ubuntu
22.04 20.04 18.04 16.04

Learn about configurations >

  • admin_users | string

    Default: ubuntu, postgres, root, pgbouncer

    Comma-separated list of database users that are allowed to connect and run all commands on the console. Ignored when auth_type is any, in which case any user name is allowed in as admin.

  • client_ca | string

    Root certificate file to validate client certificates. Must be in base64 format, e.g.: $ juju config pgbouncer client_ca="$(cat my-client-ca | base64 -w0)" If set, client_tls_sslmode is set to "verify-ca" mode.

  • client_crt | string

    Private certificate for PgBouncer to accept client connections. Must be in base64 format, e.g.: $ juju config pgbouncer client_crt="$(cat my-client-crt | base64 -w0)"

  • client_idle_timeout | int

    Client connections idling longer than this many seconds are closed. This should be larger than the client-side connection lifetime settings, and only used for network problems. [seconds]

  • client_key | string

    Private key for PgBouncer to accept client connections. Must be in base64 format, e.g.: $ juju config pgbouncer client_key="$(cat my-client-key | base64 -w0)"

  • client_login_timeout | int

    Default: 60

    If a client connects but does not manage to login in this amount of time, it will be disconnected. Mainly needed to avoid dead connections stalling SUSPEND and thus online restart. [seconds]

  • conn_crit | int

    Default: 90

    The parameters to pass to the nrpe plugin check_pgbouncer_connection_count for critical level.

  • conn_warn | int

    Default: 75

    The parameters to pass to the nrpe plugin check_pgbouncer_connection_count for warn level.

  • default_pool_size | int

    Default: 20

    How many server connections to allow per user/database pair. Can be overridden in the per-database configuration.

  • extra_packages | string

    Space separated list of extra deb packages to install.

  • ha-cluster-dns | string

    DNS entry to use with the HA Cluster subordinate charm. Mutually exclusive with ha-cluster-vip.

  • ha-cluster-vip | string

    Virtual IP for the charm to use with the HA Cluster subordinate charm Mutually exclusive with ha-cluster-dns. Multiple virtual IPs are separated by spaces.

  • idle_transaction_timeout | int

    If a client has been in "idle in transaction" state longer, it will be disconnected. [seconds]

  • ignore_startup_parameters | string

    Default: application_name

    By default, PgBouncer allows only parameters it can keep track of in startup packets - client_encoding, datestyle, timezone and standard_conforming_strings. All other parameters will raise an error. To allow other parameters, they can be specified here, so that pgbouncer knows that they are handled by admin and it can ignore them.

  • install_keys | string

    List of signing keys for install_sources package sources, per charmhelpers standard format (a yaml list of strings encoded as a string). The keys should be the full ASCII armoured GPG public keys. While GPG key ids are also supported and looked up on a keyserver, operators should be aware that this mechanism is insecure. null can be used if a standard package signing key is used that will already be installed on the machine, and for PPA sources where the package signing key is securely retrieved from Launchpad.

  • install_sources | string

    List of extra apt sources, per charm-helpers standard format (a yaml list of strings encoded as a string). Each source may be either a line that can be added directly to sources.list(5), or in the form ppa:<user>/<ppa-name> for adding Personal Package Archives, or a distribution component to enable.

  • listen_port | int

    Default: 6432

    Which port to listen on. Applies to both TCP and Unix sockets.

  • max_client_conn | int

    Default: 100

    Maximum number of client connections allowed. When increased then the file descriptor limits should also be increased. Note that actual number of file descriptors used is more than max_client_conn.

  • nagios_context | string

    Default: juju

    Used by the nrpe subordinate charms. A string that will be prepended to instance name to set the host name in nagios. So for instance the hostname would be something like: juju-myservice-0 If you're running multiple environments with the same services in them this allows you to differentiate between them.

  • nagios_servicegroups | string

    A comma-separated list of nagios servicegroups. If left empty, the nagios_context will be used as the servicegroup

  • package_status | string

    Default: install

    The status of service-affecting packages will be set to this value in the dpkg database. Valid values are "install" and "hold".

  • pool_mode | string

    Default: transaction

    Specifies when a server connection can be reused by other clients.

  • reserve_pool_size | int

    How many additional connections to allow to a pool. 0 disables.

  • reserve_pool_timeout | int

    Default: 5

    If a client has not been serviced in this many seconds, use additional connections from the reserve pool. 0 disables.

  • server_ca | string

    Root certificate file to validate client certificates. Must be in base64 format, e.g.: $ juju config pgbouncer server_ca="$(cat my-server-ca | base64 -w0)" If set, server_tls_sslmode is set to "verify-ca" mode.

  • server_check_delay | int

    Default: 30

    How long to keep released connections available for immediate re-use, without running sanity-check queries on it. If 0 then the query is ran always.

  • server_connect_timeout | int

    Default: 15

    If connection and login wont finish in this amount of time, the connection will be closed. [seconds]

  • server_crt | string

    Private certificate for PgBouncer to accept client connections. Must be in base64 format, e.g.: $ juju config pgbouncer server_crt="$(cat my-server-crt | base64 -w0)"

  • server_idle_timeout | int

    Default: 600

    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds]

  • server_key | string

    Private key for PgBouncer to accept client connections. Must be in base64 format, e.g.: $ juju config pgbouncer server_key="$(cat my-server-key | base64 -w0)"

  • server_lifetime | int

    Default: 3600

    The pooler will try to close server connections that have been connected longer than this. Setting it to 0 means the connection is to be used only once, then closed. [seconds]

  • server_login_retry | int

    Default: 15

    If login failed, because of failure from connect() or authentication that pooler waits this much before retrying to connect. [seconds]

  • vip | string

    Virtual IP to use to front pgbouncer units.

  • wait_crit | int

    Default: 20

    The parameters to pass to the nrpe plugin check_pgbouncer_pool_waittime for critical level.

  • wait_warn | int

    Default: 5

    The parameters to pass to the nrpe plugin check_pgbouncer_pool_waittime for warning level.