postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
When recovering from a backup using PITR with pgbackrest, the following command is run in the "Start PostgreSQL for Recovery" task: `"/usr/bin/pg_ctlcluster {{ postgresql_version }} {{ postgresql_cluster_name }} start -o...
Current situation: I use ansible tower (a.k.a. AWX) to manage our infrastructure Names of our hosts are human-readable names like `pg-node-01`, `pg-node-02`, ... When I run `deploy_pgcluster.yaml` playbook it fails...
Hi all, I recently had a client request to install the Oracle FDW plugin on their Postgresql cluster which is deployed and maintained with this wonderful set of playbooks. I...
Since apt_key is deprecated in Debian12, the deb822_repository module must be used instead. Major changes: - new tasks "Add repository and repository apt-key" for Debian 12 version for installation: -...
Fix syntax issue inside cron file #657 Plus fix problem with wal-g run, config file now specified in command directly. This is a simplest solution I found. Minimum changes required,...
It is not clear why it doesnt work. Problem seems like here `'%{http_code}'`. I see that it marked was tested in Ubuntu 22.04. Was wal-g also tested? https://github.com/vitabaks/postgresql_cluster/blob/f59badf3513b3b7eac2ec4edfa11ff1ef72ac4ed/vars/main.yml#L483-L488 Tried with...
I have restored my entire cluster from a other pgbackrest host and after making the necessary changes , I was able to start the database using the below command :...
Add ability use specific IP. Fix inventory group etcd_cluster: use hostnames instead of ip-address #612
Hi Vitabaks, We receive the following error when running Patroni on the RHEL9 operating system. Can you help us? ``` May 07 15:30:24 patroni[152654]: Traceback (most recent call last): May...
Issue reference: #683 This change shouldn't affect the working environment, so, by default, the keepalived configuration remains the same. These fixes make the keepalived role configurable. They also update the...
