Postgres Pro
Downloads
Home   >   mailing lists

Re: Point in time Recovery in Postgres? - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Point in time Recovery in Postgres?
Date
Msg-id CAGDYbUO+4OPB62RBcB-Vf4b8cb8B7vBttCW0qmEAeony5TAd3Q@mail.gmail.com
Whole thread Raw
In response to Re: Point in time Recovery in Postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Point in time Recovery in Postgres?
List pgsql-admin
Tree view
Hi Pavan,

PITR is the ability to restore a database cluster up to the present or to a specified point of time in the past with the help of WAL’s.  PITR uses full database cluster backup and the write-ahead logs(i.e WAL’s). For that we should have cluster level (file system level) backup like pg_basebackup.

In PostgreSQL it is possible to have PITR but it requires file system level backup (like pg_basebackup).
So, It is not possible to do PITR with pg_dump backup.




On Tue, Oct 23, 2018 at 10:14 AM pavan95 <pavan.postgresdba@gmail.com> wrote:
Hi all,

Is it possible to do PITR in postgres for a database provided that database
pg_dump backup is available and archive logs are also configured....

Could you please confirm?  Thanks in Advance!!


Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Re: Point in time Recovery in Postgres?
Next
From: Pavan Teja
Date:
Subject: Re: Point in time Recovery in Postgres?