Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes

Hi,

On 2013-11-26 13:01:52 +0000, strahinjak@nordeus.com wrote:
> Bug reference:      8632
> Logged by:          Strahinja Kustudic
> Email address:      strahinjak@nordeus.com
> PostgreSQL version: 9.1.9
> Operating system:   Centos 6.4 x86
> Description:
>
> 2013-11-26 12:24:57 CET [6393]: [93-1]LOG:  file "pg_subtrans/CEC1" doesn't
> exist, reading as zeroes
> 2013-11-26 12:24:57 CET [6393]: [94-1]CONTEXT:  xlog redo xid assignment

This bug is hopefully fixed in the 9.1.11 release coming in a few
days. As a workaround you can try starting the standby with
hot_standby=off, let it replay a bit, then shut it down and try with
hot_standby=on again.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services