WAL and pg_dump

From: Mike C <smith(dot)not(dot)western(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: WAL and pg_dump
Date: 2005-12-12 22:18:43
Message-ID: bd0eabd0512121418h4c39a3e6mc71947264e18656f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ameet Kini 2005-12-13 02:01:39 Re: pg_autovacuum log size in postgres v8.0
Previous Message Michael Fuhr 2005-12-12 20:15:40 Re: pg_restore fails with postgis