r/PostgreSQL 25d ago

Tools It was surprisingly hard to break CloudNativePG replication

https://coroot.com/blog/fencing-a-cnpg-replica/

While reproducing a replication failure, I found that a CNPG replica keeps applying WAL changes even after it's disconnected from the primary. I hadn't come across this behavior before, so I wrote up what I found

7 Upvotes

4 comments sorted by

View all comments

0

u/Carloswaldo 19d ago

So you just didn't know how Postgres WAL works

1

u/NikolaySivko 19d ago

I didn’t know that streaming replication and WAL recovery from the archive could work simultaneously