How to restore only from barman base backup

[Dan]

HI

I have a few barman bacup folder with the WAL folder and i would like to restore only the base backup with out the WAL folder,

Could you please help me to understand how to do it 

Thanks

Dan

[Gabriele Bartolini]

Hi Dan,

I am afraid I have not understood your request. A base backup is not
consistent without any WAL files between the start and the end of the
backup process, for recovery purposes. Is this what you were looking
for?

Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele....@2ndQuadrant.it | www.2ndQuadrant.it

> --
> --
> You received this message because you are subscribed to the "Barman for
> PostgreSQL" group.
> To post to this group, send email to pgba...@googlegroups.com
> To unsubscribe from this group, send email to
> pgbarman+u...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/pgbarman?hl=en?hl=en-GB
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Barman, Backup and Recovery Manager for PostgreSQL" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to pgbarman+u...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Dan]

Thanks For your answer

I will try to describe what i want

I have set barman backup for 3 history backup my list-backup is

main 20140829T190002 - Sat Aug 30 04:16:48 2014 - Size: 320.1 GiB - WAL Size: 72.9 GiB

main 20140822T190001 - Sat Aug 23 04:11:35 2014 - Size: 319.6 GiB - WAL Size: 116.2 GiB

main 20140815T190002 - Sat Aug 16 04:11:58 2014 - Size: 319.3 GiB - WAL Size: 109.6 GiB

i would like to take only the latest backup 20140829T190002 (320.1 gig) and did restore on dev machine

So my question is can i copy only the base folder on this backup without the WAL, since all WAL folder hold all wal barman backup and it  is about 300GIG,  i whould like to save this WAL folder copy.

Or there is a way to to tell barman to hold each base backup with his wal folder? 

Thanks again

On Wednesday, September 3, 2014 7:21:23 PM UTC+3, Gabriele Bartolini wrote:

Hi Dan,

  I am afraid I have not understood your request. A base backup is not
consistent without any WAL files between the start and the end of the
backup process, for recovery purposes. Is this what you were looking
for?

Thanks,
Gabriele
--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support

 gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

[Gabriele Bartolini]

Hi Dan,

I guess you might be interested in this article:
http://blog.2ndquadrant.com/management-wal-archive-barman/

Let me know if that does not cover your expectations.

Regards,

Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support

gabriele....@2ndQuadrant.it | www.2ndQuadrant.it

>> gabriele....@2ndQuadrant.it | www.2ndQuadrant.it

[Dan]

Thanks it's help me to understand the wals issue

Just to make sure i understand the recovery process if i would like to recover only the base backup to dev machine (like 20140829T190002 ) 

1. rsync to base backup of  20140829T190002

2.rsync the all wals on 20140829 date

3.run below barman recover command

barman recover --target-time '2014-08-29' main 20140829T190002 /var/lib/postgresql/9.3/main

4.restart postgresql

Thanks

On Thursday, September 4, 2014 11:14:42 AM UTC+3, Gabriele Bartolini wrote:

Hi Dan,

  I guess you might be interested in this article:
http://blog.2ndquadrant.com/management-wal-archive-barman/

  Let me know if that does not cover your expectations.

Regards,
Gabriele
--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support

 gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

>>  gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it