WAL

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