Partial-Files: cp or barman get-wal

21 views
Skip to first unread message

Christian Lehmann

unread,
Mar 28, 2022, 5:41:03 AMMar 28
to Barman, Backup and Recovery Manager for PostgreSQL
Hi there
Using barman 2.19 on RHEL with postgres 14.2.

I am currently trying some restore-scenarios with a docker-container for the possibility of partial restores. Our postgres-cluster has multiple tenants and the most possible reason for a restore is a logical / user error with the need of PIT-recover a single database.

My process is restoring into a tmp-dir via barman recover, spin it up with a container and pg_dump the corresponding database.

Now, what i understood and what works is a restore to the latest full-backup and to the latest full-WAL-file. But if i want to restore a point more recent than the latest complete WAL, i either switch-wal or i copy the .partial-file into the wal-folder (without the suffix, of course).

Now my question: what is the reason for the barman get-wal -P command? it seems redundant with a simple copy of the .partial-file to the corresponding folder, isn't it? or does it do some magic with this file?

Chris

Michael Wallace

unread,
Mar 28, 2022, 5:57:05 PMMar 28
to pgba...@googlegroups.com
Hi Chris,

The main reason for `barman get-wal -P` is so that the .partial files can be fetched automatically by the PostgreSQL restore_command when `barman recover` has been called with the `--get-wal` option - this is discussed in the docs here: https://docs.pgbarman.org/release/2.19/#limitations-of-partial-wal-files-with-recovery.

Best regards,

Mike

--
--
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.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/4272894d-016d-471e-bcb3-c85d2941ff2en%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages