Re: primary and hot standby database don' work now - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: primary and hot standby database don' work now
Date
Msg-id 5011E7A8.5070200@ringerc.id.au
Whole thread Raw
In response to primary and hot standby database don' work now  (leo xu <leoxu8703@gmail.com>)
List pgsql-bugs
On 07/22/2012 02:00 PM, leo xu 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.

When did this start happening? At random? After a server crash or power
loss? After an administrative action?

Are you running with fsync=off or using storage that has write caching
enabled?

--
Craig Ringer

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore