Postgres Pro
Downloads
Home   >   mailing lists

Re: PgBackRest question? - Mailing list pgsql-general

From chiru r
Subject Re: PgBackRest question?
Date
Msg-id CA+RSxMgR-avEre8eCAkc795iNUiq_S3cmrvS1Lz_Lw6vZxdhPg@mail.gmail.com
Whole thread Raw
In response to Re: PgBackRest question?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: PgBackRest question?
Re: PgBackRest question?
List pgsql-general
Tree view
Hi All,

Thanks,I am thinking about a specific recovery case.

Lets assume Heavy transactional system we configured.
It is generating WAL 2000/hr and recycling automatically in pg_wal directory. 

QA :

Sunday -- 11 PM  -- Full backup done.
Monday -- 11 PM  -- Differential Backup done
Tuesday-- 10 AM incremental backup is done
Note :  Every  2 hrs  incremental backup scheduled on system.

For example, if we want to restore to DEV server:

We want to recover database as of 11:30 AM Tuesday on DEV server using QA backups.

Is it possible to restore using pgbackrest tool for this scenario?.

How pgbackrest keeps track of transactions since the last backup? Where it stores transaction information for recovery ?.

Thanks,
Chiru


On Wed, Dec 13, 2017 at 5:45 PM, Stephen Frost <sfrost@snowman.net> wrote:
Greetings,

* chiru r (chirupg@gmail.com) wrote:
> The pgbackrest.conf  configuration file has the option *repo-path* to mention
> the mount point to store the backups and wal archive files.

That's correct, that's where the backups and the WAL are stored.

> We are looking for an option, Can we store online backups and wal archive
> files separately in different directories?.

That's an interesting requirement- why would you need them to be
different directories?

I'll point out that PostgreSQL backups absolutely require the WAL in
order to be able to be restored (at least the WAL generated during the
backup) in order to reach consistency.  If the two were to be seperated,
you'd probably still want the backups to 'stand alone' and that would
mean duplicating all of the WAL which is created during the backup and
storing it with the backup.

The first question really is why you're looking for this though..?  If
there's a good use-case for it, we could look at adding that it as an
option.

Thanks!

Stephen

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: pgbench
Next
From: Corey Taylor
Date:
Subject: How to see index was rejected for seq scan?