Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Point in time Recovery (PITR), - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Postgres Point in time Recovery (PITR),
Date
Msg-id CAKoxK+5X14g2sKbRpOsKPBkupWqZeiYCJ3sM0A1fqb_7ZvhsPQ@mail.gmail.com
Whole thread Raw
In response to Postgres Point in time Recovery (PITR),  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses Re: Postgres Point in time Recovery (PITR),
List pgsql-general
Tree view 
On Fri, Oct 18, 2019 at 7:59 AM Daulat Ram <Daulat.Ram@exponential.com> wrote:
> Can you please share some ideas and scenarios how we can do the PITR in case of disaster.

In order to be able to do PITR you need:
- a base backup of your database
- WALs from the backup going on

See <https://www.postgresql.org/docs/12/continuous-archiving.html>.
Then, to keep it simple, if the disaster happens in the time window
between the backup and the last WAL archiving, you can restore an
instance at any point in time previously the disaster itself.

Luca

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: stable for each row before insert trigger
Next
From: Emanuele Musella
Date:
Subject: Re: Postgres Point in time Recovery (PITR),