pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Evan Bauer <evanbauer@mac.com>
To: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Point in time Recovery in Postgres?
Date: Tue, 23 Oct 2018 01:56:06 -0400
Message-ID: <A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com> (raw)
In-Reply-To: <1540269835111-0.post@n3.nabble.com>
References: <1540269835111-0.post@n3.nabble.com>

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@evanbauer.com
+1 646 641 2973
Skype: evanbauer


> On Oct 23, 2018, at 00:43, 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
> 





view thread (5+ messages)  latest in thread

Message-ID: <A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com>
Permalink:  ../A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com/
Also on:    postgresql.org/message-id/A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: evanbauer@mac.com, pavan.postgresdba@gmail.com
  Subject: Re: Point in time Recovery in Postgres?
  In-Reply-To: <A4C27751-C22B-4687-BDB2-516A8D40B902@mac.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox