9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

From: "L'Huillier, Jeff" <Jeff(dot)LHuillier(at)ONSTAR(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Date: 2012-04-11 13:54:31
Message-ID: 7CF5C5C9FE3CE140AD240A391A7681FBF5CC0F@USRN4EX0ONS06.onstar.ad.gm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello -

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?

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?

Thanx!

Jeff

Jeff L'Huillier ( La-Hill-Yer )
JEFF(dot)LHUILLIER(at)onstar(dot)com

....Snappy little phrases here just get me in trouble ....

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-04-11 14:08:41 Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Previous Message Fujii Masao 2012-04-11 04:54:29 Re: Warnings in Standby Logs