Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [patroni]

Patroni is a template for PostgreSQL high availability.

Filter by
Sorted by
Tagged with
0 votes
0 answers
92 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, ...
mymarcelsql's user avatar
0 votes
1 answer
40 views

Patroni management - are there any UI application options? [closed]

For my one-person software development company and my projects, I have a new PostgreSQL cluster which high availability is being controlled by Patroni. So far, I have been using Patroni' command-line ...
user avatar
0 votes
0 answers
64 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 ...
Farid Jafarzadeh's user avatar
0 votes
0 answers
40 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 ...
Melih's user avatar
  • 284
0 votes
1 answer
83 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 ...
Abizer Susnerwala's user avatar
0 votes
0 answers
229 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 ...
Farid Zahidov's user avatar
0 votes
0 answers
324 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 ...
user avatar
0 votes
1 answer
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 > ...
Nullyinthesky's user avatar
1 vote
2 answers
411 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 ...
Lucky Shofar's user avatar
1 vote
2 answers
728 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 ...
0xCAFEBABE's user avatar
1 vote
1 answer
77 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 ...
guettli's user avatar
  • 1,521
1 vote
1 answer
557 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 ...
JulioQc's user avatar
  • 143
1 vote
1 answer
3k 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. ...
Pramod's user avatar
  • 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 ...
JulioQc's user avatar
  • 143
1 vote
1 answer
371 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 ...
Melih's user avatar
  • 284
0 votes
1 answer
6k 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 ...
user1930901's user avatar
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 (...
elBastarde's user avatar
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 ...
DMin's user avatar
  • 163
7 votes
1 answer
16k 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 ...
rsmoorthy's user avatar
  • 157
0 votes
1 answer
403 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 ...
rsmoorthy's user avatar
  • 157
2 votes
1 answer
805 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 ...
Tobias's user avatar
  • 21
0 votes
1 answer
200 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 ...
Tekchand Dagar's user avatar
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 ...
Mika's user avatar
  • 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 ...
Lê Minh Quân's user avatar
1 vote
1 answer
761 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?
Mohamed Ammar's user avatar
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. ...
user191155's user avatar
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 ...
Tom K's user avatar
  • 31
0 votes
1 answer
2k 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 ...
Vladimir Aleshin's user avatar
4 votes
2 answers
6k 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 ...
tuk's user avatar
  • 1,203