Questions tagged [patroni]
Patroni is a template for PostgreSQL high availability.
30 questions
0 votes
0 answers
80 views
Postgres pg_wal size increasing possibly from patroni outage
I've recently hit an issue of pg_wal files not being cleaned up on a replica postgres instance server despite these being archived on the master instance. Patroni was out during the time due to an ...
1 vote
1 answer
162 views
Is this Patroni topology safe?
My organization is planning to implement a high-availability PostgreSQL cluster using Patroni and etcd. However, we only have two data center sites available, which makes deploying a standard 3-node ...
0 votes
0 answers
143 views
etcd is out of space, getting NOSPACE alarm
We have two node patroni postgres databases on preprod environment. Today I tried to do patronictl edit-config and saw etcd was out of space. I looked at /var/lib/etcd/member directory and it was ...
1 vote
0 answers
93 views
How to prevent PostgreSQL logging Patroni health check connections?
I have PostgreSQL 15.2 from the Percona repo, along with Patroni 3.0.1 as management tool, HAProxy 2.5.11 for proxying and PGBouncer 1.18.0 as server side pool and keepalived 2.1. for the virtual IP. ...
- 163
1 vote
2 answers
468 views
Postgres Hot standby stuck starting waiting for contrrecord despite wal file being present
We are experimenting with patroni Multi Datacenter HA with postgres16 using replication slots. At high level for building the remote cluster from scratch , we are by running base backup, while active ...
- 121
0 votes
0 answers
1k views
Patroni failed to get list of machines from etcd
I am running a patroni cluster (3.4) on linux with an etcd cluster. Normally the cluster runs perfectly fine but sometimes I get some errors saying Request to etcd server failed (ReadtmeoutError, ...
- 21
0 votes
0 answers
239 views
Pgbackrest connection to Patroni cluster with HAProxy (VIP)
I have Patroni cluster with: 1 VIP 3 nodes HAProxy 3 nodes PostgreSQL Patroni 3 nodes etcd And dedicated pgbackrest server, from which I want to connect to Patroni cluster and take backups. But I ...
0 votes
1 answer
191 views
High Availability postgres db cluster with Patroni and Etcd
I am building a HA Postgres db cluster with one master and multiple slaves. Please look at the below points and correct me if I am wrong: For each slave node, I need to use pg_basebackup to sync and ...
0 votes
0 answers
3k views
TimeZone Setting On PostgreSQL Databases
I have a Patroni cluster with two Ubuntu 22 db server. The timezone of my instances was set to UTC. I have needed to edit them to set the local timezone to Europe/Istanbul. I have made the timezone ...
user274715
1 vote
2 answers
860 views
what after WAL LSN value of type pg_lsn reach its limit
I am trying to determine the optimal Standby for automated failover based on the highest value of pg_last_wal_receive_lsn() of all slaves. But what if max_wal_size is reached, does pg_lsn values go to ...
- 13
1 vote
2 answers
1k views
PostgreSQL-Patroni-Cluster: Installing oracle_fdw, dependency problem
For Oracle to PostgreSQL migrations we're currently looking into ora2pg. However, the performance using either writes to file or direct read from Oracle and write to PostgreSQL have both been very ...
- 227
1 vote
1 answer
150 views
Many PG Clusters on more than one machine
I want to run ~10k PostgreSQL clusters. Each cluster will be quite small with moderate traffic. I have will have roughly 100 virtual machines. Each VM should run roughly 100 clusters. Each cluster ...
- 1,631
1 vote
1 answer
738 views
PostgreSQL process stuck in a "forked new backend" loop when used with Patroni
I have a 3 node Patroni2.1.1 + PGSQL13.4 cluster and one of the nodes is acting weird once it finished the basebackup bootstrap. I have another identical node working fine when put thru the same ...
- 143
1 vote
1 answer
4k views
Is it good practice to use both PGBouncer and PGPool together?
We have setup a streaming replication on Postgres 13 and it all works fine. Current setup is as follows. We have one Primary Postgres and one Secondary Postgres connected via streaming replication. ...
- 111
0 votes
1 answer
6k views
FATAL: no pg_hba.conf entry for replication connection from host
Ok before this gets flag as duplicate, bear with me. I'm trying to connect two replicas (.12 & .13) to a primary PGSQL13 DB (.11) in a lab environment using synchronous stream replication but it ...
- 143