Enable PITR in Postgresql

Started by Adarsh Sharmaover 14 years ago2 messagesgeneral
Jump to latest
#1Adarsh Sharma
adarsh.sharma@orkash.com

Dear all,

Today I need to enable PITR in my Postgres Production Server.
I followed the below links for this purpose :

http://scale-out-blog.blogspot.com/2009/02/simple-ha-with-postgresql-point-in-time.html
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html

But I am confused about the below line , do we manually write the name
of each file to archive in the archive directory :

I have just installed PostgresPlus-8.4 and load some data in the demo
server and at present there is only one file name
(000000010000000000000000) and archive_status directory is empty.
Now do we need to change the below command each time new log file is
created or there is some standard way to do that.

|archive_command = 'cp -v %p /data/pgsql/archives/%f'

Thanks
|

#2John R Pierce
pierce@hogranch.com
In reply to: Adarsh Sharma (#1)
Re: Enable PITR in Postgresql

On 08/29/11 10:53 PM, Adarsh Sharma wrote:

Now do we need to change the below command each time new log file is
created or there is some standard way to do that.

|archive_command = 'cp -v %p /data/pgsql/archives/%f'|

%p and %f automatically get replaced with the name of the logfile being
archived.

do you really want that copy to be verbose?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast