On Oct 2, 2013, at 7:40 AM, Greg Sabino Mullane <[email protected]> wrote:
>> * Is it safe to delete these records? > > Yes. Great. Any idea where else they come from? AFAIK, we have only dropped one table. I don't know why there are 19 unknown OIDs. >> * What other stuff do I need to clean up for dropped tables? > > I think that should cover it. The only place it should be referenced > is the delta table, the track table, and the target table. Okay. >> * Do I need to change anything on target systems, or just sources? > > Just source. Good, as I thought. > >> * Should we updated the `validate` command to clean things up, something >> like: >> >> DELETE FROM bucardo.bucardo_delta_targets >> where tablename NOT IN (select oid from pg_class); > > That's a great idea. Done. https://github.com/bucardo/bucardo/commit/df0ef60a5a1227f9a0822fb39ac1f0875ec46cfe Best, David _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
