[Bucardo-general] Dropping Tables Breaks VAC
Greg Sabino Mullane
greg at endpoint.com
Wed Oct 2 14:40:49 UTC 2013
> So, a few questions:
> * Is it safe to delete these records?
> * 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.
> * Do I need to change anything on target systems, or just sources?
> * 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.
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general