| From: | "Just Someone" <just(dot)some(at)gmail(dot)com> |
|---|---|
| To: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Restoring a PITR backup |
| Date: | 2006-04-11 15:24:34 |
| Message-ID: | 36932f270604110824j3e9d713awbbf87cc801a2324e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a process for PITR backups running nicely. I'm pretty amazed by
the smoothness of it all!
Now I'm looking at the retrieval part, and I have something I'm
looking for clarification on.
The documentation say that a recovery.conf file is needed for the
restore. My tests indicate that I can just restore the backup, copy
over the latest WAL files and launch postgres. Is that ok? Can I just
use this way?
I could create the recovery file and have it copy the files, but as
the second machine I am restoring into can always have the DB
reloaded, I wonder if it isn't easier just to copy the files. I
actually rsync my backup directory and my WAL archive directories,
into the second machine.
Bye,
Guy.
--
Family management on rails: http://www.famundo.com - coming soon!
My development related blog: http://devblog.famundo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-04-11 15:46:29 | Re: LW Boston |
| Previous Message | Alban Hertroys | 2006-04-11 14:58:14 | Re: Asking advice on speeding up a big table |