Hi, I am using Bucardo to migrate a db that is several terabytes. I did some initial tests and it was going to take about a week. I am a little worried about setting session_replication_role to 'replica' for that long and was hoping to speed up the process by using pg_dump/pg_restore and then finish up with bucardo to get the final few rows.
I'm having some trouble figuring out the exact sequence of commands to get this working. My guess is something like: 1) pg_dump source_db 2) Add dbs and tables to bucardo 3) Add the sync -- ./bucardo add sync the_sync status=inactive onetimecopy=0 relgroup=copying_herd dbs=source_db:source,dest_db:target herd dbs=source_db:source,dest_db:target 4) pg_restore dest_db 5) ./bucardo activate the_sync Is this the right way? One thing I am confused about is what the 'autokick' option does and if it is needed here. Thanks, David
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
