[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.


>> * 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 mailing list