On Fri, 8 Feb 2008, David Wall wrote:
Is 'scp' by itself considered an "atomic tool" for copying files to the standby server? Does "atomic" mean that the program should copy a file over using a temp file name and then renames at the end or does it mean something else?
That's correct. You have to do it that way or the system in recovery mode can start to consume the new segment file before it has been completely copied over yet.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster