Hello,
Using Postgresql
Is it possible to de-select few fields (eg. bytea) before taking backup? Sometimes, we need to take backup without images and restore into a different server for some testing purposes.
Is it possible?
Hello,
Using Postgresql
Is it possible to de-select few fields (eg. bytea) before taking backup? Sometimes, we need to take backup without images and restore into a different server for some testing purposes.
Is it possible?
Hello,
Thank you for your message.
To achieve backups with and without BLOB (bytea
) fields, the easiest approach is to use custom pg_dump
command-line options, which SQLBackupAndFTP supports.
We recommend setting up two separate backup jobs:
--large-objects
--no-large-objects
This will allow you to switch between backup modes depending on your needs.
You can find more information about these options in the official PostgreSQL documentation:
PostgreSQL: Documentation: 17: pg_dump