Ashish Karalkar wrote:
Hello All,can anybody please tell me which file name should given in %f parameter of archive_command. As per documantation "When not using WAL archiving, the system normally creates just a few segment files and then "recycles" them by renaming no-longer-needed segment files to higher segment numbers." So there are 4/5 files. Now i want to switch to archiving mode. which file name should be given in place of %f parameter of archive command my command looks like this: 'cp -i /usr/local/pgsql/data/pg_xlog /mnt/server/archivedir/%f'
I think you've got the wrong idea. You need to place %p and %f in your command-string, and the server replaces them with the correct path/filename.
So - %p will be the full path to the file the system wants you to archive and %f is just its name. Re-read section 23.3 of the manuals and start off with the example commands perhaps.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
