9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename - Mailing list pgsql-admin

From L'Huillier, Jeff
Subject 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Date
Msg-id 7CF5C5C9FE3CE140AD240A391A7681FBF5CC0F@USRN4EX0ONS06.onstar.ad.gm.com
Whole thread Raw
Responses Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
List 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.LHUILLIER@onstar.com

 

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

 

pgsql-admin by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Warnings in Standby Logs
Next
From: Tom Lane
Date:
Subject: Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename