Re: primary and hot standby database don' work now

On 22 July 2012 07:00, leo xu <leoxu8703@gmail.com> wrote:
> hello everyone:
>               my pg version is 9.1.2 running on red hat 5.4 x64 servers.one
> day,i found all database indexes can't work,reindex database,it can work,but
> some table has primary key,found exists the same two records in table.
>              primary database error:

> 2012-07-19 21:18:36.133 CST,,,476,,4fde7dd3.1dc,22,,2012-06-18 09:01:07
> CST,1/0,0,WARNING,01000,"specified item offset is too large",,,,,"xlog redo
> insert: rel 17673/16386/16780; tid 409/151",,,,""

There's something badly wrong with your WAL records.

I'd suggest you move to a later version of 9.1 and retry.

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