search

dimitri / pgcopydb

Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)
Other
1.16k stars 76 forks source link

Problem: Extension copy is not resumable #742

Open arajkumar opened 5 months ago

arajkumar commented 5 months ago

Attempt copying extension using pgcopydb copy extensions and interrupt the copy in the middle. When you resume extension copy again, it would attempt copying already processed extension configuration tables.

I think we can solve this by introducing a transaction to handle the extension config table copy along with sqlite summary entry to skip if transaction is already complete.

dimitri commented 5 months ago

Sounds familiar... #725 ?

arajkumar commented 5 months ago

@dimitri Yes, I will polish #725 to address this.