This change integrates changes related to the new Patroni-enabled high availability included in the postgresql helm chart. 1. Updates the version of the postgresql chart 2. Adds users/passphrases for the postgresql replication and exporter users 3. Sets the default number of replicas to 3 (except for skiff & sloop) 4. Adds documentation/scripting for upgrading the chart Co-Authored-By: Evgeniy L <firstname.lastname@example.org> Change-Id: I51e63fb2444610cfb144bc587a6a179fa4830809
|3 years ago|
|README.md||3 years ago|
|patroni_endpoint_cleaner.sh||3 years ago|
|patroni_endpoint_cleaner_remove.sh||3 years ago|
|patroni_endpoint_cleaner_unit.sh||3 years ago|
PostgreSQL Patroni Upgrade Scripts
Upgrading a live site from the old, unclustered PostgreSQL chart to the newer, Patroni-managed version takes a small amount of out-of-band scripting to ensure a smooth hands-free upgrade.
Prior to upgrade
patroni_endpoint_cleaner_unit.sh script should be run prior to upgrading
the postgresql chart. It installs a systemd unit which in turn will run
patroni_endpoint_cleaner.sh script. During chart upgrade, the script
will delete the postgresql endpoints, allowing Patroni to recreate them with the
appropriate annotations for it to manage them ongoing.
This documentation project outlines a reference architecture for automated cloud provisioning and management, leveraging a collection of interoperable open-source tools.
After the chart upgrade is complete, the
script should be run. This will simply clean up the systemd unit that was