pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Sriram Dandapani <sdandapani@counterpane.com>
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: andy.shellam@mailnetwork.co.uk
Cc: pgsql-admin@postgresql.org
Subject: Re: FW: Setting up of PITR system.
Date: Sat, 1 Apr 2006 09:58:04 +0530
Message-ID: <a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com> (raw)
In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local>
References: <6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local>

On 3/31/06, Sriram Dandapani <sdandapani@counterpane.com> wrote:
> We have high volume inserts happening with wal files being generated
> very rapidly. Will the fact that the files change as the tar happens
> have any effect at all on the recovery..assuming all the appropriate wal
> archive logs are available.


Its absolutely safe. The documentation specifically and sufficiently
dispels this
doubt[ Refer Online Backup ] . All the changes to the data pages
(tables/indexes)
are logged to WAL before the data files are modified so the WAL replay during
recovery changes the files again in the same manner. As long as wal is archived
properly/securly there should not be any doubt.


Regds
Rajesh Kumar Mallah.




>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jim C. Nasby
> Sent: Friday, March 31, 2006 10:11 AM
> To: Tom Lane
> Cc: andy.shellam@mailnetwork.co.uk; 'Rajesh Kumar Mallah';
> pgsql-admin@postgresql.org
> Subject: Re: FW: [ADMIN] Setting up of PITR system.
>
> On Wed, Mar 29, 2006 at 09:46:30AM -0500, Tom Lane wrote:
> > It definitely is a pain in the neck that GNU tar complains about files
> > changing underneath it --- I've looked for a way to disable that, or
> at
> > least reduce it to a warning instead of an error condition, but gtar
> > doesn't seem to have such a switch.  You should try alternative backup
> > tools such as cpio or rsync.
>
> Or you might submit a patch to GNU tar. There's also a BSD version of
> tar, it's on at least FreeBSD (not sure if there's a stand-alone version
> avaiable). It might not suffer from the same problem, though I haven't
> tried it. I do have a machine I could try it with if that would help.
> --
> Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> Pervasive Software      http://pervasive.com    work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>



view thread (36+ messages)  latest in thread

Message-ID: <a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com>
Permalink:  ../a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com

 · 

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: mallah.rajesh@gmail.com, sdandapani@counterpane.com, jnasby@pervasive.com, tgl@sss.pgh.pa.us, andy.shellam@mailnetwork.co.uk
  Subject: Re: FW: Setting up of PITR system.
  In-Reply-To: <a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com>
  References: <6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local> <a97c77030603312028x54384c34w1bc0f5f900bbecf8@mail.gmail.com>

* 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