How to safely stop replication?

mkabilov / pg2ch

Data streaming from postgresql to clickhouse via logical replication mechanism

MIT License

195 stars 35 forks source link

How to safely stop replication? #32

Open maiabdelqader opened 5 years ago

maiabdelqader commented 5 years ago

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?

mkabilov commented 5 years ago

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.

maiabdelqader commented 5 years ago

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?