Re: Spontaneous PITR standby activiation

David Christensen wrote:
> 1) is there a hard limit of the number of times the archive_command will
> attempt? I didn't see anything documented about this in the PITR or
> config docs, so I'm guessing the 10 failures I saw in the log were just
> coincidental.

There's no limit. It will try forever.

> 2) are the archive_command failures in the master's log responsible for
> the redo records?

No, archive_command failures shouldn't affect the standby.

> 3) would a Pg forced shutdown cause issues with the generated WAL when
> replaying?

No.

> 4) at first I thought it had to do with a bug/failure in pg_standby, but
> I'm wondering if it has to do with the "record with zero length"
> referenced in the standby's logs. Thoughts?

That basically means that WAL replay reached end of WAL. The rest of the
WAL file is probably full of zeros. It's quite normal in crash recovery,
for example. But I have no explanation for why such a WAL file was archived.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com