There's been some speculation about allowing a standby server to execute
purely read-only operations, but it's just speculation so far.
To add some more speculations, I wonder if that can be workable at
all... given that the data pages are overwritten by WAL records, and not
under transactional
On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
Jim Nasby [EMAIL PROTECTED] writes:
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
Jim Nasby [EMAIL PROTECTED] writes:
On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
The only way to roll time backwards is to replace the data directory
with a backup, so if I understand your question correctly, the answer
is no.
Well, specifically I was thinking of...
Roll PITR forward and
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
Jim Nasby [EMAIL PROTECTED] writes:
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