Full explanation starts here: http://www.postgresql.org/docs/9.3/static/continuous-archiving.html.
While there are some considerations to take in it does not relate to performance. Generally most production systems run with archiving on. Take a minute to read through the documentation and let us know if you have any questions. Most questions about "backup and recovery" should be asked in the admin mailing list.
Good Luck,
jason
On Mon, Feb 23, 2015 at 5:38 AM, Saurabh Gupta A <saurabh.a.gupta@xxxxxxxxxxxx> wrote:
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
