Re: [GENERAL] Enable PITR in Postgresql

2011-08-29 Thread John R Pierce
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 arc

[GENERAL] Enable PITR in Postgresql

2011-08-29 Thread Adarsh Sharma
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 abo