"L'Huillier, Jeff" <Jeff(dot)LHuillier(at)ONSTAR(dot)com> wrote:
> When enabling WAL archiving and setting up the archive_command, is
> it possible to add the date & time as an extension to the %f
> copied to the archive directory in order to avoid overwriting a
> file of the same name?
The recommended behavior is to exit the recovery command (or the
script run as the command) with an exit code of 255 when the target
file already exists. This should never happen unless you
accidentally point two different database clusters to the same
target directory.
> In adding a date-time stamp to the archived file name, would this
> adversely affect the restore_command and render the %f file coming
> back unusable?
Well, you could use a wildcard in the restore command to find a
matching file, but if there is more than one because of the
timestamps added to the filename, which one do you pick?
-Kevin