[Bucardo-general] Dropping Tables Breaks VAC
David E. Wheeler
david at justatheory.com
Wed Oct 2 16:37:03 UTC 2013
On Oct 2, 2013, at 7:40 AM, Greg Sabino Mullane <greg at endpoint.com> wrote:
>> * Is it safe to delete these records?
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.
>> * 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.
More information about the Bucardo-general