Partial-Files: cp or barman get-wal

[Christian Lehmann]

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]

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.