On Thu, 4 Jun 2009, hubert depesz lubaczewski wrote:
is it safe, if i would do: dd if=/dev/zero of=$ORIGINAL_XLOG_SEGMENT bs=1M count=16 before returning from archive_command script?
Nope. At that point, the files are still needed for crash recovery on that system. There will be a future point where a checkpoint will note the files aren't needed anymore, and at that point they'll be recycled (renamed with a new id and used again) or deleted. You can't change the files until then though, and that time can be several minutes after archive_command is called.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
