Re: Replication with Patroni not working after killing secondary and starting again

2022-05-06 Thread Zb B
> Does https://patroni.readthedocs.io/en/latest/replication_modes.html help? Thanks. I have found the same meanwhile. The effects I experienced were caused by the fact that Patroni configures async replication by default. After changing it to sync everything worked as expected

Re: Replication with Patroni not working after killing secondary and starting again

2022-05-04 Thread Peter J. Holzer
On 2022-05-04 10:21:56 +0200, Zb B wrote: > Apparently there is something wrong with my cluster. How to debug i?. > Do I need to configure anything so the replication is synchronous? Does https://patroni.readthedocs.io/en/latest/replication_modes.html help? hp -- _ | Peter J. Holzer

Re: Replication with Patroni not working after killing secondary and starting again

2022-05-04 Thread Zb B
> What does `patronictl list` show during that interval? Well. I can't repeat the situation anymore. Now the replication starts immediately after starting the patroni on secondary. I did several switchover commands meanwhile though Meanwhile I did another test where I run a Java app with a large

Re: Replication with Patroni not working after killing secondary and starting again

2022-04-29 Thread Peter J. Holzer
On 2022-04-28 11:09:12 +0200, Zb B wrote: > > When the secondary starts up it should continue replicating from where > > it stopped. However, it can only do this if the necessary information is > > still available. If WAL files have been deleted in the mean time. it > > can't replay them. There sho

Re: Replication with Patroni not working after killing secondary and starting again

2022-04-28 Thread Zb B
> When the secondary starts up it should continue replicating from where > it stopped. However, it can only do this if the necessary information is > still available. If WAL files have been deleted in the mean time. it > can't replay them. There should be error messages in your logs on what > went

Re: Replication with Patroni not working after killing secondary and starting again

2022-04-27 Thread Peter J. Holzer
On 2022-04-27 15:27:34 +0200, Zb B wrote: > Hi, > I am new to Patroni and PostgreSQL.We have set up a cluster with etcd (3 > nodes), Patroni (2 nodes) and PostgreSQL (2 nodes) with replication from > primary to secondary. Pretty much the setup we have. > Seemed to be working fine and we started s

Replication with Patroni not working after killing secondary and starting again

2022-04-27 Thread Zb B
Hi, I am new to Patroni and PostgreSQL.We have set up a cluster with etcd (3 nodes), Patroni (2 nodes) and PostgreSQL (2 nodes) with replication from primary to secondary. Seemed to be working fine and we started some tests. One of the tests gave us unsatisfactory results. Specifically when we star