Regarding "Point-in-time Recovery" feature

From: Saurabh Gupta A <saurabh(dot)a(dot)gupta(at)ericsson(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Regarding "Point-in-time Recovery" feature
Date: 2015-02-23 11:38:42
Message-ID: 23D91C5830493B4DB8AA6E18238717CAD10FB2@ESESSMB105.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mathis, Jason 2015-02-23 16:03:35 Re: Regarding "Point-in-time Recovery" feature
Previous Message Nicolas Paris 2015-02-20 18:09:39 Re: PG 9.3 materialized view VS Views, indexes, shared memory