Our WAL backup documentation says in some parts of it:
..."%p is replaced by the absolute path of the file to archive..." [1]I think this is (at least for 8.1 and upcoming 8.2 releases) wrong, since the archiver
replaces this with pg_xlog/<LOGFILENAME> only, so that the archive commandis invoked with the relative path to the database data directory and its xlog files. This applies to the restore_command as well. Attached is a small patch against HEAD, which
will adjust things in the documentation.[1] http://www.postgresql.org/docs/8.1/interactive/backup-online.html#BACKUP-ARCHIVING-WAL
-- Thanks Bernd
wal_backup_doc.patch
Description: Binary data
---------------------------(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