New answers tagged

0

Replication Slots filling up disk? Even if you specify use_slots in Patroni's configuration, the slot will be automatically removed if the replica fails to renew it's member key in the DCS (distributed consensus store). By default this means a slot for a disappeared replica will be dropped after 30 seconds (this corresponds to the ttl setting, which ...


4

You can fail over to a readable secondary. The author is either wrong, or just using some confusing terminology. Reading the exact quote you included, I'd lean towards the former explanation. But I don't know all the context around that statement. Here I have an AG - all replicas are configured to be readable when they are in the secondary role, and NODE2 ...


2

I see the list of all the operations that can trigger a scan but none of them are happening on my machine, is there a way to tell what causes the scan? It's a CHECKPOINT on database ID 8. It says so right in the message. Do you have INDIRECT CHECKPOINT enabled? What does select database_id , name, target_recovery_time_in_seconds from sys.databases where ...


Top 50 recent answers are included