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@xxxxxxxxxxxxx
