Bruce Momjian br...@momjian.us wrote:
if a write happens in both the first and second half of a second,
While I'm not sure whether I believe that granularity is really to
the nanosecond, a stat of a table in a production database on xfs
shows this:
Modify: 2012-07-24 10:15:44.096415501
Le dimanche 15 juillet 2012 07:02:01, Stephen Frost a écrit :
Bruce,
* Bruce Momjian (br...@momjian.us) wrote:
On Sat, Jul 14, 2012 at 09:17:22PM -0400, Stephen Frost wrote:
So, can you explain which case you're specifically worried about?
OK. The basic problem is that I previously
Bruce,
* Bruce Momjian (br...@momjian.us) wrote:
If two writes happens in the middle of a file in the same second, it
seems one might be missed. Yes, I suppose the WAL does fix that during
replay, though if both servers were shut down cleanly, WAL would not be
replayed.
If you using it
On Sat, Jul 14, 2012 at 09:17:22PM -0400, Stephen Frost wrote:
Bruce,
* Bruce Momjian (br...@momjian.us) wrote:
If two writes happens in the middle of a file in the same second, it
seems one might be missed. Yes, I suppose the WAL does fix that during
replay, though if both servers were
Bruce,
* Bruce Momjian (br...@momjian.us) wrote:
On Sat, Jul 14, 2012 at 09:17:22PM -0400, Stephen Frost wrote:
So, can you explain which case you're specifically worried about?
OK. The basic problem is that I previously was not clear about how
reliant our use of rsync (without
On Mon, Jul 9, 2012 at 08:00:48PM -0700, David Kerr wrote:
On Jul 9, 2012, at 7:48 PM, Bruce Momjian wrote:
Rsync is popular with Postgres users, but I don't understand how they
are using the default check mode (file size, modification time) to
synchronize shut-down data directories?
Rsync is popular with Postgres users, but I don't understand how they
are using the default check mode (file size, modification time) to
synchronize shut-down data directories? It seems they would have to use
--checksum because it is too easy for files to change in the same
second, and for a
On Jul 9, 2012, at 7:48 PM, Bruce Momjian wrote:
Rsync is popular with Postgres users, but I don't understand how they
are using the default check mode (file size, modification time) to
synchronize shut-down data directories? It seems they would have to use
--checksum because it is too easy