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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
local_backup_script.sh
Description: Bourne shell script
-- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
