Re: Point in time Recovery in Postgres?

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