[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