Questions tagged [patroni]
Patroni is a template for PostgreSQL high availability.
23
questions
0
votes
0
answers
45
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
1
answer
890
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
196
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
482
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 ...
- 197
1
vote
1
answer
62
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,421
1
vote
1
answer
428
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 ...
- 123
1
vote
0
answers
2k
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
3k
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 ...
- 123
1
vote
1
answer
277
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 ...
- 274
0
votes
1
answer
3k
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
725
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 (...
- 165
1
vote
1
answer
816
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
12k
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
341
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
1
vote
1
answer
519
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 ...
- 11
0
votes
1
answer
162
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
2k
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 ...
- 311
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
601
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
846
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
9k
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
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 ...
4
votes
2
answers
4k
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,153