Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?


Mike C.


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group