Re: Replication and fsync - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Replication and fsync
Date
Msg-id 1383061237.99931.YahooMailNeo@web162901.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Replication and fsync  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
Tomas Vondra <tv@fuzzy.cz> wrote:

> I think it's safe as long as you don't try to reuse the cluster
> after a crash (be it due to OS error, power outage, ...). If the
> primary crashes for any reasons, you have to start from scratch,
> otherwise there might be silent corruption as you've described.

I agree.  It seems to me that as long as you never try to start the
old master after a crash of the OS (directly or because of hardware
or VM failure), the standby should be usable without risk of
corruption.  As soon as you start the old master after such a crash
though, you could be replicating corrupted blocks; you would need
to be very hard-line about never bringing the old master back up.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: Matt
Date:
Subject: Re: INSERT/UPDATE statements sometimes choosing not to use PK index?
Next
From: Perry Smith
Date:
Subject: Re: Cursor Example Needed