"L'Huillier, Jeff" <Jeff.LHuillier@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
