Questions tagged [patroni]
Patroni is a template for PostgreSQL high availability.
30
questions
1
vote
2
answers
52
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
49
views
citus high availability setup with patroni
We want to setup patroni HA setup with 3 coordinator, 2 worker node 1 & 2 worker node 2.
I am getting system id mismatch when i start 2nd coordinator. First one is running fine, only facing issue ...
- 101
0
votes
0
answers
426
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
136
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
0
answers
131
views
How to change pgpool role automatically when pg_role changes after patroni cluster switchover leader?
I try to use pgpool-II as loadbalancer to distribute select queries to replica and other dml queries to leader in my patroni cluster. After switchover on Patroni cluster, pgpool can not recognize ...
- 284
0
votes
1
answer
132
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
343
views
Failed to start patroni
I am trying to configure patroni and etcd. Etcd is working fine, but patroni is failing to start. I have 3 servers, I have installed patroni and etcd on each server. When I try to start patroni on ...
0
votes
0
answers
923
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
0
votes
3
answers
2k
views
Patroni Haproxy and pg-bouncer
I'm building a Patroni Postgres cluster; however, I can't decide which is the better architecture:
App > HAproxy > Pgbouncer > PostgreSQL (Patroni)
App > PGBouncer > HAproxy > ...
1
vote
2
answers
534
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
807
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 ...
- 217
1
vote
1
answer
86
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,541
1
vote
1
answer
602
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
5k
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
1
vote
1
answer
440
views
Could Barman backup only one database from PostgreSQL?
In my system, I have postgresql 12 and barman v2.13. I have a few backup disk around 1 TB and i have currently added new DB which has 5 TB. Previously my PostgreSQL had no more than 400 GB.
i think ...
- 284
0
votes
1
answer
7k
views
Issue with Patroni - postgres not starting
I am learning Postgres and I have installed 3 VMs as follows:
node1 - Installed Postgres and etcd here
node2 - Installed Postgres and etcd here
node3 - Installed etcd here
I have setup streaming ...
- 349
1
vote
1
answer
1k
views
Does Postgres CHECKPOINT process affects streaming replication?
Does Postgres CHECKPOINT process affect async streaming replication in any way?
If checkpoint_timeout is increased from 5min (default) to 30min, then CHECKPOINT processes will be triggered less often (...
- 285
1
vote
1
answer
1k
views
HAProxy + Patroni - Configure reads from a master when no slaves available
I have a HAProxy + Patroni setup with split reads and writes.
The problem is, when both my replicas go down, only my writes are supported, the reads stop because both replicas are down.
How is this ...
- 163
7
votes
1
answer
17k
views
Could not receive data from WAL stream: ERROR: requested WAL segment has already been removed
Configuration: Postgres 9.6 with a 3 cluster node. db1 is the master, db2 and db3 are replicas. WAL files are archived in AWS S3 using custom pgrsync tool. Cluster managed by patroni. The ...
- 157
0
votes
1
answer
439
views
postgres cluster: Crash of master crashes the replicas too
Environment:
Postgres version: 9.6
Cluster of 3 servers, with Patroni and etcd
Scenario:
When index of tables were started with 16 parallel requests (on a 16CPU machine), postgres on the master ...
- 157
2
votes
1
answer
1k
views
High Available PostgreSQL with Patroni and Replication
I want to build a highly available PostgreSQL cluster using patroni with etcd. I want to have 3 server (1 master and 2 slaves) in my cluster, so if something goes wrong one of the slaves automatically ...
- 21
0
votes
1
answer
204
views
On which machine we should install WAL-G?
We are using PostgreSQL version 12.1. Currently we have high availability and automatic failover using Patroni and it's working fine.
Now we are planning for disaster recovery and we are planning to ...
- 101
0
votes
1
answer
3k
views
Patroni with etcd starting up
I have an existing PostgreSQL cluster v11.5 with streaming replication.
I want to set up high availability managed by Patroni.
I installed Patroni on both machines, I set up an etcd cluster on three ...
- 351
2
votes
2
answers
2k
views
Highly Available PostgreSQL with patroni
I follow this guide to set up an lab for Postgres HA.
I follow exactly the guide (change the IP address in my case), after all it all work though on Postgres server 1
But when come to Postgres ...
- 145
1
vote
1
answer
807
views
Postgresql Master/Slave Using Patroni
Can I promote a slave node to be a master for insert/update/delete using Patroni once the original master goes down?
1
vote
1
answer
1k
views
What happens if a DC goes down in a Postgresql, Patroni, etcd multi DC setup
I have a question regarding how Patroni and etcd handle the below scenarios.
Assume there are two sites in this deployment, Site1 and Site2 and it's a 5 node cluster spread across these two sites. ...
- 21
3
votes
0
answers
10k
views
psql: FATAL: the database system is starting up [closed]
I'm running into this message but not able to make heads or tails out of why it's throwing this:
-bash-4.2$ /usr/pgsql-10/bin/postgres -D /data/patroni --config-file=/data/patroni/postgresql.conf
...
- 31
0
votes
1
answer
3k
views
HA PostgreSQL installation using patroni and pgbouncer
I'm not having a problem yet, just searching for advise
I want to build installation of PostgreSQL on 3 nodes using patroni: master and 2 standbys (for failover only). There are PostgreSQL and ...
4
votes
2
answers
7k
views
Patroni : How to handle a replica which has been disconnected from primary for long time?
Let's say I am using asynchronous streaming replication with the below configuration in a 3 node cluster with Postgres 10.4 and Patroni 1.4.4
bootstrap:
dcs:
ttl: 30
...
- 1,243