Re: somewhat wrong archive_command example - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: somewhat wrong archive_command example
Date
Msg-id 20120825234026.GG10814@momjian.us
Whole thread Raw
In response to Re: somewhat wrong archive_command example  (Bruce Momjian <bruce@momjian.us>)
Responses Re: somewhat wrong archive_command example
List pgsql-docs
On Sat, Aug 25, 2012 at 07:07:55PM -0400, Bruce Momjian wrote:
> > >I have made all the suggestions posted and would like to add the
> > >attached script to our documentation as a simple example.
> >
> > Btw., is anyone else concerned about using plain cp for this?  If
> > the cp fails half-way, it leaves a partial file around, but
> > subsequent file existence checks will find the file OK and skip it.
> >
> > I have occasionally used some combination of mktemp + cp + mv, which
> > seems to work around this problem.
>
> I am unclear why the script returns success if the file already exists
> --- seems if the file exists, we should throw an error, like we have
> always done with cp -i < /dev/null.
>
> Updated version attached.
>
> Another option in this case would be to re-issue the copy.

Sorry, proper attached file this time.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Attachment

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: somewhat wrong archive_command example
Next
From: Bruce Momjian
Date:
Subject: Re: CREATE TABLE LIKE, regarding constraints