Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavan Teja
Subject Re: Point in time Recovery in Postgres?
Date
Msg-id CACh9nsbx35gr1eJbjh9wvjjs_-T1ciSLzM23tSgLLDbs8+agGg@mail.gmail.com
Whole thread Raw
In response to Re: Point in time Recovery in Postgres?  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
Hi Shreeyansh,

Thanks for confirmation. Actually did PITR with basebackup. 

Wanted to know if it could be done by using dump bkp.

Anyways, thanks for confirmation

Regards,
Pavan

On Tue, Oct 23, 2018, 11:17 AM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
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: Shreeyansh Dba
Date:
Subject: Re: Point in time Recovery in Postgres?
Next
From: Evan Bauer
Date:
Subject: Re: Point in time Recovery in Postgres?