pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Grega Bremec <gregab@p0f.net>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: FW: Setting up of PITR system.
Date: Thu, 13 Apr 2006 10:01:01 +0200
Message-ID: <443E053D.4080506@p0f.net> (raw)
In-Reply-To: <a97c77030604081010p70ef330au57dc838c40127ca0@mail.gmail.com>
References: <!&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAAB0heSWPqq+QLrrk5Lik5sLAQAAAAA=@mailnetwork.co.uk>
	<442B93DD.4020305@p0f.net>
	<a97c77030603312023k7bdc705eif22af429dc3c943d@mail.gmail.com>
	<442E1945.4030006@p0f.net>
	<a97c77030604010258j657622fcj6a42a10c8c38f344@mail.gmail.com>
	<442FDC7F.9010001@p0f.net>
	<a97c77030604020914n38b3e3bco2138b9673f25b176@mail.gmail.com>
	<4430BC59.7040006@p0f.net>
	<a97c77030604031129m6e014adcu52df9eee26510ea1@mail.gmail.com>
	<4437AF15.3020707@p0f.net>
	<a97c77030604081010p70ef330au57dc838c40127ca0@mail.gmail.com>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

Rajesh Kumar Mallah wrote:
> Is cluttering of the wal archive area in cases where that backup
> had to be re-started for whatever reasons is the *only* concern ?

Well, yes, to be honest. But it may in consequence cause problems of
another kind, which I don't feel qualified to reassure you on: I am not
positive about what happens if you try to replay an old WAL on a current
database backup.

If nothing else, it is going to make the person restoring the backup
rather unnerved about success of the operation they are currently
performing, which is not a good thing, IMHO. They are restoring a backup
afterall, which means they'd already undergone a fair amount of stress
as it is. :)

End all, it is your choice to decide which is more trouble and which is
worth more: fixing the script to produce clean backups or informing your
backup operators about the extra care they need to take when restoring
backups.

> Please do not put too much effort, as i the drives in my other
> server has got installed and i am adapting the script for doing
> remote backup ( which is a more common senerio).

Very nice! How is it going? And how are you copying the WALs? scp? rsync?

Kind regards,
- --
    Grega Bremec
    gregab at p0f dot net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQFEPgU9fu4IwuB3+XoRA+MeAJ0dbbfcgBqP9SCYq0VICN8xrtGN0wCffE6i
kq1LlDwlJwmfrOtwRBwGqFg=
=olf3
-----END PGP SIGNATURE-----



view thread (36+ messages)  latest in thread

Message-ID: <443E053D.4080506@p0f.net>
Permalink:  ../443E053D.4080506@p0f.net/
Also on:    postgresql.org/message-id/443E053D.4080506@p0f.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gregab@p0f.net, mallah.rajesh@gmail.com
  Subject: Re: FW: Setting up of PITR system.
  In-Reply-To: <443E053D.4080506@p0f.net>
  References: <!&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAAB0heSWPqq+QLrrk5Lik5sLAQAAAAA=@mailnetwork.co.uk> <442B93DD.4020305@p0f.net> <a97c77030603312023k7bdc705eif22af429dc3c943d@mail.gmail.com> <442E1945.4030006@p0f.net> <a97c77030604010258j657622fcj6a42a10c8c38f344@mail.gmail.com> <442FDC7F.9010001@p0f.net> <a97c77030604020914n38b3e3bco2138b9673f25b176@mail.gmail.com> <4430BC59.7040006@p0f.net> <a97c77030604031129m6e014adcu52df9eee26510ea1@mail.gmail.com> <4437AF15.3020707@p0f.net> <a97c77030604081010p70ef330au57dc838c40127ca0@mail.gmail.com> <443E053D.4080506@p0f.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox