Skip site navigation (1) Skip section navigation (2)

seeking PITR archive_command advice

From: Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in>
To: pgsql-novice(at)postgresql(dot)org
Subject: seeking PITR archive_command advice
Date: 2007-04-17 06:46:24
Message-ID: 779726.24498.qm@web94312.mail.in2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello All,
   
  I am trying to set up continues archiving of WAL files.
  I have some doubt about the archive command %p and %f parameter.
   
  I am havining all 5/6 WAL files in following directory.  
   
  usr/local/pgsql/data/pg_xlog
   
  My questions are 
   
  1) what will be the value for %p parameter
  will  it be
  /usr/local/pgsql/data/pg_xlog ?
   
  is yes it is giving me following error
  cp: omitting directory `/usr/local/pgsql/data/pg_xlog/
   
  2)
  which file name i should give in place of %f parameter as there are 5/6 files already?
   
  Thanks in Advance
   
  With Regards
  Ashish Karalkar
   

       
---------------------------------
 Check out what you're missing if you're not on Yahoo! Messenger 

pgsql-novice by date

Next:From: NathanielDate: 2007-04-19 09:52:16
Subject: Adding a conditional unique constraint
Previous:From: John KollerDate: 2007-04-13 04:34:29
Subject: Re: Install question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group