-----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@xxxxxxxxxxx, which in general is better than -general. :) - -- Greg Sabino Mullane greg@xxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
