{"repo":"canonical/postgresql-operator","free":true,"listed":false,"github":"https://github.com/canonical/postgresql-operator","clone":"git clone https://github.com/canonical/postgresql-operator.git","description":"A Charmed Operator for running PostgreSQL on machines","language":"Python","stars":18,"topics":["data-platform","postgresql","charm","python"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Charmed PostgreSQL VM Operator This repository contains a charmed operator for deploying PostgreSQL on virtual machines via the Juju orchestration engine. To learn more about how to deploy and operate Charmed PostgreSQL, see the official documentation. Overview This operator provides a PostgreSQL database with replication enabled: one primary instance and one (or more) hot standby replicas. The Operator in this repository is a Python script which wraps PostgreSQL versions distributed by Ubuntu Jammy series and adding Patroni on top of it, providing lifecycle management and handling events (install, configure, integrate, remove, etc). Basic usage Deployment Bootstrap a lxd controller and create a new Juju model: To deploy a single unit of PostgreSQL using its default configuration, run the following command: It is customary to use PostgreSQL with replication to ensure high availability. A replica is equivalent to a juju unit. To deploy PostgreSQL with multiple replicas, specify the number of desired units with the -n option: To add replicas to an existing deployment, see the Add replicas section. [!TIP] It is generally recommended to have an odd number of units to avoid a \"split-brain)\" scenario Primary replica To retrieve the primary replica, use the action get-primary on any of the units running PostgreSQL. Similarly, the primary replica is displayed as a status message in juju status . Note that this hook gets called at regular time intervals, so the primary may be outdated","default_branch":null,"files":null,"tree":[],"storefront":"/r/canonical","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/canonical/postgresql-operator/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}