I have a slave database that is being replicated from a Master DB.
All of a sudden, my slave DB just exited and wasn't able to restart. Here are the error messages when it exits. Similar ones appear when I restart:
WARNING: page 21561636 of relation base/16384/54391 is uninitialized CONTEXT: xlog redo visible: rel 1663/16384/54391; blk 21561636 PANIC: WAL contains references to invalid pages CONTEXT: xlog redo visible: rel 1663/16384/54391; blk 21561636 LOG: startup process (PID 1573) was terminated by signal 6: Aborted LOG: terminating any other active server processes
Both slave and master are using Postgres 9.2.3 in a Centos 5 quad-core server with 32 GB of RAM each.
When I try to restart the slave, with "zero_damaged_pages=true", the server still refuses to start with lines like the ones above.
At this point, I don't care if the slave ever starts as I can start from scratch. But is this an issue with Postgres? Has anyone encountered this and is it fixed in future versions?
Looking up research online doesn't give me much confidence, so that's why I'm posting here.