Sample archive_command is still problematic

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Sample archive_command is still problematic
Date: 2014-08-08 23:41:47
Message-ID: 53E5603B.5040102@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

All:

The example archive_command we give in the docs is this one:

archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p
/mnt/server/archivedir/%f'

This is a problematic recommendation. If there's any reason why copying
the archive file gets interrupted (storage blip, for example), then the
command will fail and will continue to fail forever, ending archiving.

Is there some good reason why "test ! -f" was added to the sample?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message MauMau 2014-08-10 13:24:03 Re: pageinspect forks
Previous Message Marti Raudsepp 2014-08-01 12:57:10 Re: PL/PgSQL INTO (used to be BUG #8870)