Questions tagged [patroni]

Patroni is a template for PostgreSQL high availability.

Filter by
Sorted by
Tagged with
1 vote
2 answers
30 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 ...
user avatar
1 vote
1 answer
36 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 ...
user avatar
  • 1,331
1 vote
1 answer
72 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 ...
user avatar
  • 123
0 votes
0 answers
42 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. ...
user avatar
  • 101
0 votes
0 answers
187 views

ERROR: Error when fetching backup: pg_basebackup exited with code=1 when start patroni service for a replica

I created a cluster including 3 servers via Patroni. Everything was alright like failover, switchover... but when I try to add another replica server I am getting an error like this: Eki 25 13:19:22 ...
user avatar
0 votes
1 answer
668 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 ...
user avatar
  • 123
1 vote
1 answer
57 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 ...
user avatar
  • 264
0 votes
1 answer
660 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 ...
user avatar
0 votes
1 answer
150 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 (...
user avatar
1 vote
1 answer
102 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 ...
user avatar
  • 153
5 votes
1 answer
4k 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 ...
user avatar
  • 137
0 votes
1 answer
187 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 ...
user avatar
  • 137
0 votes
1 answer
219 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 ...
user avatar
  • 1
0 votes
1 answer
98 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 ...
user avatar
0 votes
1 answer
871 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 ...
user avatar
  • 141
2 votes
2 answers
1k 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 ...
user avatar
1 vote
1 answer
246 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?
user avatar
1 vote
1 answer
486 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. ...
user avatar
3 votes
0 answers
7k 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 ...
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 ...
user avatar
4 votes
2 answers
1k 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 ...
user avatar
  • 889