Thread: [GENERAL] 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