On Mon, 18 Apr 2005, Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:Tom Lane wrote:Bruce Momjian <pgman@candle.pha.pa.us> writes:I guess I didn't see the connection between the file system backup and the WAL files, when in fact you need the WAL files that go with the file system badckup to do the recovery. Do you have new suggested text?
I think it probably needs to mention *both* the tar dump and the WAL segment file(s). I can take a whack at it if you like.
I modified the sentence to say:
Once you have safely archived the file system backup and the WAL segment files used during the backup (as specified in the backup history file), you can delete all archived WAL segments with names numerically less.
Feel free to whack it a second time.
whack...
...you can delete all archived WAL segments with names numerically less.
but I'm not sure it's best practice to delete them at that point. I would recommend that users keep at least the last 3 backups. So, I'd prefer the wording
...all archived WAL segments with names numerically less will no longer be needed as part of that backup set. You may delete them at that point, though you should consider keeping more than one backup set to be absolutely certain that you are can recover your data.
I see that clear and deterministic procedure of online backup as I imagined earlier becomes fuzzy and blurred :) This is obviously not suited even for my notebook.
Best Regards, Simon Riggs
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
