[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?
>
> 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
More information about the Bucardo-general
mailing list