pg2ch icon indicating copy to clipboard operation
pg2ch copied to clipboard

Published 20 hours ago • verified publisher icon mkabilov

How to safely stop replication?

Open maiabdelqader opened this issue 5 years ago • 2 comments

Is there a way to safely stop pg2ch replication?

I need to run pg2ch for few minutes each hour and then to stop it to avoid keeping connections open on PostgreSQL. Is there a way to do that rather than the kill command?

maiabdelqader avatar Sep 10 '19 08:09 maiabdelqader

in the current version that might be possible by killing(sending TERM signal) the pg2ch process.

we're currently working on the new version of pg2ch which will allow pausing replication.

mkabilov avatar Sep 10 '19 08:09 mkabilov

Is there an side effect for the killing? And when I re-run the pg2ch will it resume from where it reached before the killing?

When it is expected to launch the new version?

maiabdelqader avatar Sep 10 '19 11:09 maiabdelqader