Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> It would seem logical to use the same logic for archive recovery as we
> do for streaming replication, and only set XLogReceiptTime when you have
> to wait for a WAL segment to arrive into the archive, ie. when
> restore_command fails.
That would not do what you want at all in the case where you're
recovering from archive --- XLogReceiptTime would never advance
at all for the duration of the recovery.
It might be useful if you knew that it was a standby-with-log-shipping
situation, but we have no way to tell the difference.
The restore_command might know the difference, though. Is it
worth modifying its API somehow so that the command could tell us
whether to advance XLogReceiptTime? How would we do that?
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-07-03 15:47:53|
|Subject: Re: reassign owned to change the ownership for op class and family |
|Previous:||From: Simon Riggs||Date: 2010-07-03 14:46:30|
|Subject: Re: Keeping separate WAL segments for each database|