From: Markus Schaber <schabi@logix-tt.com>
To: Brendan Duddridge <brendan@clickspace.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Recovery will take 10 hours
Date: Mon, 24 Apr 2006 10:29:44 +0200
Message-ID: <444C8C78.1000906@logix-tt.com> (raw)
In-Reply-To: <F823FC8E-70C4-41D0-A812-F2C7E2ECFF1E@clickspace.com>
References: <85A15B2E-F59C-4FEF-82D4-61F48ABDCDE5@clickspace.com>
<1145808368.3112.222.camel@localhost.localdomain>
<F823FC8E-70C4-41D0-A812-F2C7E2ECFF1E@clickspace.com>
Hi, Brandan,
Brendan Duddridge wrote:
> So how do you overlap the restore process with the retrieving of files?
You need a shell script as restore command that does both uncompressing
the current file, and starting a background decompress of the next
file(s). It also has to check whether the current file is already in
progress from a last run, and wait until this is finished instead of
decompressing it. Seems to be a little complicated than it sounds first.
> restore_command = 'gunzip </wal_archive/%f.gz>%p &'
Warning: Don't do it this way!
It will break things because PostgreSQL will try to access a
not-completely-restored wal file.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabi@logix-tt.com, brendan@clickspace.com
Subject: Re: Recovery will take 10 hours
In-Reply-To: <444C8C78.1000906@logix-tt.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