search

sorintlab / stolon

PostgreSQL cloud native High Availability and more.
https://talk.stolon.io
Apache License 2.0
4.64k stars 445 forks source link

drop replication slot #873

Open seadba opened 2 years ago

seadba commented 2 years ago

we have an issue with offline replicas - i have an orphaned stolon replication slot in primary - pgwal needs to be trimmed - can i safely drop the stolon replication slot? and when we re-add the replicas , will stolon recreate the slot? thanks

viggy28 commented 2 years ago

Did you try removekeeper first? I would be interested to know what caused an orphaned stolon replication slot at the first place.

(FWIW, It's not end of the world if you drop a replication slot manually which is not used by any replicas)