Skip site navigation (1) Skip section navigation (2)

Re: primary and hot standby database don' work now

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: leo xu <leoxu8703(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: primary and hot standby database don' work now
Date: 2012-07-27 00:58:16
Message-ID: 5011E7A8.5070200@ringerc.id.au (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-bugs by date

Next:From: Craig RingerDate: 2012-07-27 01:00:36
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore
Previous:From: fabio.lunkesDate: 2012-07-26 23:52:12
Subject: BUG #6768: Failure in OBDC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group