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 -- JotaComm http://jotacomm.wordpress.com
