Re: Point in time Recovery in Postgres?

From: Evan Bauer <evanbauer(at)mac(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Point in time Recovery in Postgres?
Date: 2018-10-23 05:56:06
Message-ID: A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Since pg_dump is logical, it won’t provide the basis for PITR. A number of other tools will.

There is a good discussion of the capabilities of most of the PostgreSQL backup tools here: https://severalnines.com/blog/top-backup-tools-postgresql

Cheers,

- Evan

Evan Bauer
eb(at)evanbauer(dot)com
+1 646 641 2973
Skype: evanbauer

> On Oct 23, 2018, at 00:43, pavan95 <pavan(dot)postgresdba(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vikas Gupta 2018-10-23 05:57:21 Re: Point in time Recovery in Postgres?
Previous Message Pavan Teja 2018-10-23 05:50:26 Re: Point in time Recovery in Postgres?