Charmed PostgreSQL VM

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
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 363 21 Feb 2024
Ubuntu 22.04
14/candidate 412 28 May 2024
Ubuntu 22.04
14/candidate 413 28 May 2024
Ubuntu 22.04
14/beta 413 28 May 2024
Ubuntu 22.04
14/beta 412 28 May 2024
Ubuntu 22.04
14/edge 418 14 Jun 2024
Ubuntu 22.04
14/edge 417 14 Jun 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
22.04 20.04 18.04 16.04 14.04

Learn about actions >

  • create-backup

    Creates a backup to s3 storage.

  • get-password

    Get the system user's password, which is used by charm. It is for internal charm users and SHOULD NOT be used by applications.

    Params
    • username string

      The username, the default value 'operator'. Possible values - operator, replication, rewind.

  • get-primary

    Get the unit which is the primary/leader in the replication.

  • list-backups

    Lists backups in s3 storage.

  • pre-upgrade-check

    Run necessary pre-upgrade checks and preparations before executing a charm refresh.

  • restore

    Restore a database backup using pgBackRest. S3 credentials are retrieved from a relation with the S3 integrator charm.

    Params
    • backup-id string

      A backup-id to identify the backup to restore (format = %Y-%m-%dT%H:%M:%SZ)

  • set-password

    Change the system user's password, which is used by charm. It is for internal charm users and SHOULD NOT be used by applications.

    Params
    • password string

      The password will be auto-generated if this option is not specified.

    • username string

      The username, the default value 'operator'. Possible values - operator, replication, rewind.

  • set-tls-private-key

    Set the private key, which will be used for certificate signing requests (CSR). Run for each unit separately.

    Params
    • private-key string

      The content of private key for communications with clients. Content will be auto-generated if this option is not specified.