Re: 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