Re: Recovery will take 10 hours

[Markus Schaber <schabi(at)logix-tt(dot)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