postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
Target VMs: ``` lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.1 LTS Release: 22.04 Codename: jammy ``` Ansible: ``` ansible --version ansible [core 2.13.2] config...
Hello, when using variable "gpgcheck = no" gpgkey is always necessaire - block: # RedHat/CentOS - name: Add repository yum_repository: name: "{{ item.name }}" description: "{{ item.description }}" baseurl: "{{...
Offline installation(installation_method: "file") does not contain pgbouncer ，How to add pgbouncer to offline installation？
Hi, I installed it as "true". I created the database and user. `tail -f /var/log/pgbouncer/pgbouncer.log 2021-02-02 03:06:46.962 +03 [30376] WARNING C-0x563860fd9ef0: zabbix/[email protected]:49466 pooler error: query_wait_timeout`
[](https://www.timescale.com) **Question:** Could you please send across, or the changes that i need to make on postgresql cluster to make it work for timescaledb. **Answer:** Everything is very simple! And...
Hello, I am getting following issue after changing default storage folder, it doesn't pickup properly after changing OS "Debian" variable ``` # PostgreSQL variables postgresql_cluster_name: "main" postgresql_data_dir: "/opt/data/postgresql/{{ postgresql_version }}/{{...
Automate database backup in a cluster - [ ] pgbackrest - [ ] wal-g --- _Make your contribution to the development of the project, become a [sponsor](https://www.patreon.com/vitabaks)_
- [ ] PostgreSQL - [ ] Patroni --- _Make your contribution to the development of the project, become a [sponsor](https://www.patreon.com/vitabaks)_
TODO --- _Make your contribution to the development of the project, become a [sponsor](https://www.patreon.com/vitabaks)_