Re: PgBackRest question?

On 12/15/17 4:36 PM, chiru r wrote:
>
> 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?.

Yes. See the documentation here on how to create a standby:

http://pgbackrest.org/user-guide.html#replication/hot-standby

And to recover to a specific point in time:

http://pgbackrest.org/user-guide.html#pitr

Then simply promote the standby and you have a dev server.

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

The transactions since the last backup are tracked in the WAL. Here's
how to setup WAL archiving:

http://pgbackrest.org/user-guide.html#quickstart/configure-archiving

It looks like you have a lot of WAL volume so you'll want to use async
archiving:

http://pgbackrest.org/user-guide.html#backup-host/async-archiving

You mentioned in your original post:

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

But it's not clear to me why you would need to do that based on your use
case.

Regards,
--
-David
david(at)pgmasters(dot)net