Hello all,
We have a two Postgres servers running 8.3 set up for warm standby using xlog
shipping. We had some problems with our warm standby locking up and needing to
be rebooted and have grub reinstalled for the system to boot. Once the server
was back up we noticed the xlog file it was look
Colin Wilson wrote:
> Once the server was back up we noticed the xlog file it was
> looking for was one that the logs say was already applied. It
> was 7 xlogs back to be exact.
It is not unusual for WAL replay to ask for files out of order or
multiple times in certain circumstances. A stand
Agree with Kevin on this one, a new base backup and essentially re-start
the log shipping from scratch. I try and keep at least the last 20-30
applied xlogs on the standby server before removing them, so i have
never seen this issue personally.
On our databases, I try to do a base backup at least
