Re: [GENERAL] WAL contains references to invalid pages

2013-05-24 Thread JotaComm
Hello, > > > > > 2013/5/21 Adarsh Sharma > >> Try to take backups of that table & index only. If succeeded drop and >> recreate them. May be it fix your issue. >> > > On Monday night I made the slave server. Yesterday I was analyzing the log > files and I found the following messages. > > 2013-05-

Re: [GENERAL] WAL contains references to invalid pages

2013-05-21 Thread Adarsh Sharma
Try to take backups of that table & index only. If succeeded drop and recreate them. May be it fix your issue. Thanks On Thu, May 16, 2013 at 11:14 PM, JotaComm wrote: > Hello, Fabrízio > > > 2013/5/16 Fabrízio de Royes Mello > >> >> On Thu, May 16, 2013 at 11:12 AM, JotaComm wrote: >> >>> >

Re: [GENERAL] WAL contains references to invalid pages

2013-05-16 Thread JotaComm
Hello, Fabrízio 2013/5/16 Fabrízio de Royes Mello > > On Thu, May 16, 2013 at 11:12 AM, JotaComm wrote: > >> >> [...] >> >> 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= CO

Re: [GENERAL] WAL contains references to invalid pages

2013-05-16 Thread Fabrízio de Royes Mello
On Thu, May 16, 2013 at 11:12 AM, JotaComm wrote: > > [...] > 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, > lastBlockVa