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
