Search Postgresql Archives

Re: standby questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux