> 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 transactiona
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 fo
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:
> 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 diff
