Bucardo syncrun

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

Emanuel Araújo asked:

Can I purge data on Postgrebucardo table syncrun ?

If I will follow this steps:

bucardo stop
psql bucardo
truncate bucardo.syncrun ;
\q
bucardo start

The steps to purge all past data that table. Is correct? Is this Simple method?

Yes, you could also simply remove older entries without needing to
stop bucardo first, like so:

delete from bucardo.syncrun where ended < now() - interval '1 week';

If there were a very large number of rows deleted, you should also:

vacuum full bucardo.syncrun;

The data in that table is not critical to Bucardo running - it is mostly
used for the output of "bucardo status" and for auditing of past syncs.

P.S. Bucardo has its own mailing list: bucardo-general@bucardo.org,
which in general is better than -general. :)

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201710261427
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlnyKbAACgkQvJuQZxSWSsj3WQCgtYecAxqk09rvJTKITRL/fcBo
oBgAoK5AaZc2Z+/UEE4HvY042iYnyvmv
=SETH
-----END PGP SIGNATURE-----

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general