Postgresql

  • By postgresql-charmers
juju deploy cs:postgresql
Show information
Channel Version Platform
latest/stable 217
20.04 LTS 18.04 LTS 16.04 LTS 14.04 LTS
latest/edge 216
18.04 LTS 16.04 LTS 14.04 LTS

Platform:

20.04 LTS 18.04 LTS 16.04 LTS 14.04 LTS
  • replication-pause

    Pause replication replay on a hot standby unit.

  • replication-resume

    Resume replication replay on a hot standby unit.

  • switchover

    Promote a specific unit to master. Must be run on the leader unit.

    Params
    • master string

      Unit to promote to master (eg. postgresql/3).

    Required

    master

  • wal-e-backup

    Run a wal-e backup to cloud storage now. Requires WAL shipping to be enabled with wal-e. Action terminates when the backup is complete.

    Params
    • prune boolean

      Run the configured prune step if the backup completes successfully, the same as the regularly scheduled backup task.

  • wal-e-list-backups

    List backups available for PITR and their metadata.

    Params
    • storage-uri string

      The WAL-E storage URI to search for backups.

  • wal-e-restore

    PITR database recovery from configured wal-e store. THIS WILL DESTROY YOUR EXISTING DATA. Most of these options correspond to PostgreSQL recovery target settings, documented at http://www.postgresql.org/docs/current/static/recovery-target-settings.html.

    Params
    • backup-name string

      The name of the backup to recover from. Use the wal-e-list-backups action to see what is available. By default, the most recent backup is used. The selected backup must have been created before any specified target-time.

    • confirm boolean

      Recovery destroys the current local database and PITR backups. If this option is false, the action will just report details of what will be destroyed. Set this option to true to perform the recovery.

    • storage-uri string

      The WAL-E storage URI to recover from. If you are rewinding a deployment to an earlier point in time, this may be the same as the wal_e_storage_uri configuration option. See the WAL-E or wal_e_storage_uri configuration option documentation for supported syntax. Requires the relevant os_*, aws_* or wabs_* configuration options to be specified.

    • target-time string

      Target time to recovery database to in ISO8601 format. By default recovers to the latest available.

    • target-timeline string

      The timeline to recover to. Set to an empty string to recover along the same timeline that was current when the backup was taken. The default value 'latest' will to recover to the latest available timeline, following any promotions. Other values will recover along that specific timeline.

    Required

    storage-uri