Regarding "Point-in-time Recovery" feature - Mailing list pgsql-general

From Saurabh Gupta A
Subject Regarding "Point-in-time Recovery" feature
Date
Msg-id 23D91C5830493B4DB8AA6E18238717CAD10FC5@ESESSMB105.ericsson.se
Whole thread Raw
Responses Re: Regarding "Point-in-time Recovery" feature  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general

 

Hello,

Has anybody used online backup feature of postgreSQL? In fact precise postgreSQL term is called: "Point-in-time Recovery" (PITR)
This means enabling following additional options in config:
---
archive_command = on
archive_command = 'cp %p /usr/local/pgsql/pgDataPITR/wals/%f' # This is only example path
---

 

If yes then may I know how it is used and how it impacts database performance?

 

 

Regards:

Saurabh

 

 

pgsql-general by date:

Previous
From: Giuseppe Sacco
Date:
Subject: Re: Postgres architecture for multiple instances
Next
From: George Woodring
Date:
Subject: SQL solution for my JDBC timezone issue