A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [patroni]

Patroni is a template for PostgreSQL high availability.

Filter by
Sorted by
Tagged with
0
votes
1answer
40 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 ...
2
votes
1answer
203 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 ...
1
vote
1answer
44 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?
0
votes
1answer
68 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. ...
1
vote
0answers
1k 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 ...
0
votes
1answer
448 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 ...
1
vote
1answer
392 views

Patroni : How to handle a slave which has been disconnected from master for long time?

Let's say if 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 loop_wait: 10 ...