Re: very long secondary->primary switch time

2021-04-27 Thread Tomas Pospisek
Hi Tom, hi list participants, thanks a lot for replying Tom. On 27.04.21 22:16, Tom Lane wrote: Tomas Pospisek writes: I maintain a postgresql cluster that does failover via patroni. The problem is that after a failover happens it takes the secondary too long (that is about 35min) to come up

Re: very long secondary->primary switch time

2021-04-27 Thread Tom Lane
Tomas Pospisek writes: > I maintain a postgresql cluster that does failover via patroni. The > problem is that after a failover happens it takes the secondary too long > (that is about 35min) to come up and answer queries. The log of the > secondary looks like this: > 04:00:29.777 [9679] LOG:

very long secondary->primary switch time

2021-04-27 Thread Tomas Pospisek
Hello all, I maintain a postgresql cluster that does failover via patroni. The problem is that after a failover happens it takes the secondary too long (that is about 35min) to come up and answer queries. The log of the secondary looks like this: 04:00:29.777 [9679] LOG: received promote r