Re: [HACKERS]odd output in restore mode - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: [HACKERS]odd output in restore mode
Date
Msg-id 488D7506.9000903@enterprisedb.com
Whole thread Raw
In response to Re: [HACKERS]odd output in restore mode  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [HACKERS]odd output in restore mode  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-patches
Andrew Dunstan wrote:
> Kevin Grittner wrote:
>>>>> "Heikki Linnakangas" <heikki@enterprisedb.com> wrote:
>>> We really need a more reliable way of detecting that a file has been
>>> fully copied.
>>
>> In our scripts we handle this by copying to a temp directory on the
>> same mount point as the archive directory and doing a mv to the
>> archive location when the copy is successfully completed.  I think
>> that this even works on Windows.  Could that just be documented as a
>> strong recommendation for the archive script?
>
> Needs testing at least. If it does in fact work then we can just adjust
> the docs and be done

Yeah.

> - or maybe provide a .bat file or perl script that
> would work as na archive_command on Windows.

We're not talking about archive_command. We're talking about the thing
that copies files to the directory that pg_standby polls.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_dump additional options for performance
Next
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS]odd output in restore mode