suggestions for archive_command to a remote standby - Mailing list pgsql-general

From John DeSoi
Subject suggestions for archive_command to a remote standby
Date
Msg-id 46ECF6EB-BBF6-4E87-836D-C38A6DA7F4A1@pgedit.com
Whole thread Raw
Responses Re: suggestions for archive_command to a remote standby
List pgsql-general
rsync seems to be suggested in a number of references for the archive_command when copying WAL files to another server.
Butthe documentation states in bold letters that the command should refuse to overwrite existing files, *and that it
returnsnonzero status in this case*. You can keep rsync from overwriting files, but I don't see any options for
generatingan error if the file exists. 

Anyone care to share a method or script for handling this correctly with rsync or some other common utility?

Thanks!


John DeSoi, Ph.D.





pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: COPY from .csv File and Remove Duplicates
Next
From: Rich Shepard
Date:
Subject: Re: suggestions for archive_command to a remote standby