Pgbelt is a CLI tool used to manage Postgres data migrations from beginning to end, for a single database or a fleet, leveraging pglogical replication.
Apache License 2.0
18
stars
5
forks
source link
Provide a "reset" command, so users can quickly be able to restart pgbelt migrations #561
Users encounter errors. Sometimes due to pgbelt bugs, sometimes due to dataset issues on their end, etc.
Whenever any sort of issue occurs, they need to restart their migration jobs
They can't just teardown and run setup again since data exists in their destination DBs.
Proposed Solution
Provide a command like reset that can only work on a destination database.
In full migrations, truncate all the destination tables, ensure sequences are set to 0, and ensure no FKs exist
In exodus migrations, truncate all destination tables that are in the config, ensure sequences from the config are set to 0, and ensure no FKs exist in the tables from the config
Problem:
setupagain since data exists in their destination DBs.Proposed Solution
resetthat can only work on a destination database.