Hello, guys
Yesterday I identified the following messages in my log file (slave):
user=,db= WARNING: page 6629 of relation base/
20449/24818 is uninitialized
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631, lastBlockVacuumed 6626
user=,db= PANIC: WAL contains references to invalid pages
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631, lastBlockVacuumed 6626
user=,db= LOG: startup process (PID 26293) was terminated by signal 6: Aborted
user=,db= LOG: terminating any other active server processes
Information:
PostgreSQL 9.2.3 (master and slave)
Operational System: CentOS release 6.3 (Final)
The parameter full_page_writes is enabled in both servers.
Analyzing the objects in my cluster (master) I identified the database [20449] and the relation [24818]. The relation 24818 is an index, so I ran the command REINDEX to try solving the problem. Immediately after, I tried to up the slave but I received the same errors.
user=,db= WARNING: page 6629 of relation base/
20449/24818 is uninitialized
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631, lastBlockVacuumed 6626
user=,db= PANIC: WAL contains references to invalid pages
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631, lastBlockVacuumed 6626
user=,db= LOG: startup process (PID 26293) was terminated by signal 6: Aborted
user=,db= LOG: terminating any other active server processes
As the problem is in the wal file, so the process (above) doesn't work according my wish.
Any idea?
Thanks a lot.
Regards
