| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: is it safe to clear oroginal xlog after archiving it? |
| Date: | 2009-06-04 13:55:56 |
| Message-ID: | alpine.GSO.2.01.0906040952570.2894@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Oliva | 2009-06-04 14:03:56 | Re: Upgrading Database: need to dump and restore? |
| Previous Message | Bill Moran | 2009-06-04 13:55:54 | Re: Upgrading Database: need to dump and restore? |