[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?
Yes.
> * 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?
Just source.
> * 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...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20131002/5b05127f/attachment.sig>
More information about the Bucardo-general
mailing list