[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