WAL and pg_dump - Mailing list pgsql-admin

From Mike C
Subject WAL and pg_dump
Date
Msg-id bd0eabd0512121418h4c39a3e6mc71947264e18656f@mail.gmail.com
Whole thread Raw
Responses Re: WAL and pg_dump
List pgsql-admin
All the documentation I've seen for PITR points to having to do a file system copy of sorts.

Is it possible to have a weekly pg_dump and restore the database up to the last archived WAL file if the db server fails? If so, how? Is it just a matter of restoring the database then copying the archived WAL files into the xlog dir and creating a recovery.conf file?

Cheers,

Mike C.

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: pg_restore fails with postgis
Next
From: Ameet Kini
Date:
Subject: Re: pg_autovacuum log size in postgres v8.0