pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Point in time Recovery in Postgres?
5+ messages / 5 participants
[nested] [flat]
* Re: Point in time Recovery in Postgres?
@ 2018-10-23 04:43 pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: pavan95 @ 2018-10-23 04:43 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Point in time Recovery in Postgres?
@ 2018-10-23 05:46 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Shreeyansh Dba @ 2018-10-23 05:46 UTC (permalink / raw)
To: pavan95 <pavan.postgresdba@gmail.com>; +Cc: pgsql-admin
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.
<http://www.shreeyansh.com;
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Point in time Recovery in Postgres?
@ 2018-10-23 05:50 Pavan Teja <pavan.postgresdba@gmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Pavan Teja @ 2018-10-23 05:50 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
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.
>
> <http://www.shreeyansh.com;
>
>
> 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
>>
>>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Point in time Recovery in Postgres?
@ 2018-10-23 05:56 Evan Bauer <evanbauer@mac.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Evan Bauer @ 2018-10-23 05:56 UTC (permalink / raw)
To: pavan95 <pavan.postgresdba@gmail.com>; 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@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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Point in time Recovery in Postgres?
@ 2018-10-23 05:57 Vikas Gupta <vikasmanya1@gmail.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Vikas Gupta @ 2018-10-23 05:57 UTC (permalink / raw)
To: pavan.postgresdba@gmail.com; +Cc: pgsql-admin
Hi Pavan,
Is it not possible with the pg_dump backup and with the wal files.
to do he PITR we need the pg_base backup along with WAL files.
Thanks and Regards
Vikas Gupta PMP
+91-987181913
+91-9953999863
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2018-10-23 05:57 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-23 04:43 Re: Point in time Recovery in Postgres? pavan95 <pavan.postgresdba@gmail.com>
2018-10-23 05:46 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-10-23 05:50 ` Pavan Teja <pavan.postgresdba@gmail.com>
2018-10-23 05:56 ` Evan Bauer <evanbauer@mac.com>
2018-10-23 05:57 ` Vikas Gupta <vikasmanya1@gmail.com>
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