Lists: | pgsql-general |
---|
From: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Enable PITR in Postgresql |
Date: | 2011-08-30 05:53:22 |
Message-ID: | 4E5C7AD2.8040006@orkash.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
|
From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Enable PITR in Postgresql |
Date: | 2011-08-30 06:40:53 |
Message-ID: | 4E5C85F5.7060908@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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