Re: Reliable WAL file shipping over unreliable network - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Reliable WAL file shipping over unreliable network
Date
Msg-id 45F65094-CF9C-4BC4-AF56-2FE299F79EFF@icloud.com
Whole thread Raw
In response to Re: Reliable WAL file shipping over unreliable network  (scott ribe <scott_ribe@elevated-dev.com>)
Responses Re: Reliable WAL file shipping over unreliable network  (Nagy László Zsolt <gandalf@shopzeus.com>)
List pgsql-admin


On Feb 28, 2018, at 1:12 PM, scott ribe <scott_ribe@elevated-dev.com> wrote:

There seem to be 2 fundamental misunderstandings here:

1) That other processes cannot see data written to a file until it is flushed to disk; this is not true; while file data is still in file cache, it is visible to other processes.

2) That rsync writes the file on the destination directly; it does not; it writes into a temporary file and renames that file when it is complete.


While you’re correct; I never made either of those assumptions 

pgsql-admin by date:

Previous
From: Evan Rempel
Date:
Subject: Re: Separate log for a specfic database
Next
From: Dianne Skoll
Date:
Subject: Re: Reliable WAL file shipping over unreliable network