Backup without blob field(s)

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:

  1. Full backup (including large objects):
    In the “Extra command line parameters” field, add (see the screenshot for reference):

--large-objects

  1. Backup without large objects (BLOBs):
    In a second job, add:

--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:
:link: PostgreSQL: Documentation: 17: pg_dump