Re: standby questions - Mailing list pgsql-general

From Greg Smith
Subject Re: standby questions
Date
Msg-id Pine.GSO.4.64.0802090211020.1627@westnet.com
Whole thread Raw
In response to Re: standby questions  (David Wall <d.wall@computer.org>)
Responses Re: standby questions
List pgsql-general
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: David Wall
Date:
Subject: Re: standby questions
Next
From: David Wall
Date:
Subject: Re: standby questions