[Bucardo-general] how to re-sync databases?

Greg Sabino Mullane greg at endpoint.com
Wed Nov 5 19:32:24 UTC 2008

> to purge the deltas, do I just execute the SQL in a cronjob every 5  
> mins:
> >> (SELECT bucardo_purge_delta('5
> >> minutes'::interval);
> as you mentioned?  I think so but, since this is now in a live  
> database I'm getting paranoid in case I break the whole thing...

Yep. If you've never done that, or not done it a long time, you might want
to do a few manual runs first at larger time intervals to prune things in
tages, e.g. select bucardo_purge_delta('1 week'::interval); The function
will output the number of rows removed. Once you are caught up, it's
prbably a good idea to vacuum both of those tables as well. Perhaps even a
vacuum full and then reindex if there were many rows removed, and you can
stand the locking hit.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation 610-983-9073
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20081105/4b176ffd/attachment.bin 

More information about the Bucardo-general mailing list