Hello Ismael,
Please consider using bpipe:
https://www.bacula.lat/using-bpipe-to-stream-dumps-vm-clones-and-another-data-to-your-backup/?lang=en
It is a much more automated way of performing backups using tubes. You can also
automate the restore.
Examples from my book:
PostgreSQL
This method
Dear all,
One of my production Postgres databases is growing faster than
anticipated and I'm exploring the use of FIFO files instead of writing the
output of pg_dump to intermediate files within /tmp structure. Currently
all jobs work fine while using the intermediate files. But when I test with