Restoring a PITR backup

Started by Just Someonealmost 20 years ago2 messagesgeneral
Jump to latest
#1Just Someone
just.some@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Just Someone (#1)
Re: Restoring a PITR backup

"Just Someone" <just.some@gmail.com> writes:

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?

If by "latest" you mean "all the WAL files since the backup was made",
it'd probably work.

regards, tom lane