-----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-gene...@bucardo.org, which in general is better than -general. :) - -- Greg Sabino Mullane g...@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
