| From: | Jim Nasby <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | PITR timeline question |
| Date: | 2006-08-03 18:25:18 |
| Message-ID: | 2608192E-3683-4475-8B47-5F5B60D93671@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If you're using multiple timelines with PITR, do you have to re-copy
all the data files into the cluster every time you start a new
timeline? Or can you copy the data files out of the backup once, and
then perform multiple recoveries, each to different timelines?
Ultimately, what I'd like to be able to do is periodically bring a
'PITR slave' live. I know I can do this by first copying the base
files and then recovering every time, but it would be nice if I
didn't have to actually copy the base files first.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-08-03 18:26:19 | Re: PostgreSQL on RAM Disk / tmpfs |
| Previous Message | Thomas F. O'Connell | 2006-08-03 17:43:18 | SAVEPOINT and FOR UPDATE |