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@pgmasters.net