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

From Nagy László Zsolt
Subject Re: Reliable WAL file shipping over unreliable network
Date
Msg-id 10bea809-cf89-4e5d-6064-95dd95164e20@shopzeus.com
Whole thread Raw
In response to Re: Reliable WAL file shipping over unreliable network  (Rui DeSousa <rui.desousa@icloud.com>)
List pgsql-admin

2018. 02. 28. 19:11 keltezéssel, Rui DeSousa írta:
> Easiest thing to do is to keep the replica from seeing the file until
> it’s successfully transferred; i.e.
>
> 1. Transfer the file successfully first with a temporary extension:  
> $ARCH_DIR/$WALFILE.swap
> 2. If successfully transferred then move it into place:
>     mv $ARCH_DIR/$WALFILE.swap $ARCH_DIR/$WALFILE
This works ONLY if the directory is mounted on the master, and you can
execute "mv" on the master (as part of the archive_command) to rename
the file that is stored on the slave.

But the original question specified that mounting is not an option.



pgsql-admin by date:

Previous
From: scott ribe
Date:
Subject: Re: Reliable WAL file shipping over unreliable network
Next
From: Rui DeSousa
Date:
Subject: Re: Reliable WAL file shipping over unreliable network