Re: Dangers of fsync = off - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Dangers of fsync = off
Date
Msg-id 1178718007.4260.77.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Dangers of fsync = off  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Dangers of fsync = off
List pgsql-general
> [snip] Take the example of a query "UPDATE tablename SET x = x + 1".
> When this query is erroneously issued twice, data corruption will occur.

Huh ? I thought slony is replicating data, not queries... what on the
master is "UPDATE tablename SET x = x + 1" will translate to "UPDATE
tablename SET x = new_value" on the slave, where new_value equals that x
+ 1. That's why slony is working well even if you do "UPDATE tablename
SET x = now()".

Cheers,
Csaba.



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Issue with database Postgresql :(
Next
From: Bill Moran
Date:
Subject: Re: Dangers of fsync = off