On 2006-12-13, "Simon Riggs" <[EMAIL PROTECTED]> wrote: > On Wed, 2006-12-13 at 19:28 +0000, Simon Riggs wrote: >> On Wed, 2006-12-13 at 04:23 +0000, Andrew - Supernews wrote: >> > While testing a PITR recovery, I discovered that recovery.conf doesn't >> > seem to allow specifying ' in the command string, making it hard to >> > protect the restore_command against problematic filenames (whitespace >> > etc.). This doesn't seem to be a problem for archive_command, which >> > allows \' (e.g. archive_command = '/path/to/script \'%f\' \'%p\''). > > Immediate workaround is to use a script to encapsulate the actual > desired request.
That only helps if you can trust %p not to contain whitespace or $. If it is always relative to somewhere in the data dir then this is probably ok, but if it's an absolute path then you can't assume that. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match