You can add custom pg_dump options to your PostgreSQL database nodes.

By default, you don't need to specify any option. However, in some cases, you may need to specify custom options depending on your needs.

Once you add your option then test your backup using on-demand backup to make sure your backup is valid and options are working as per your requirement.

For application security, BackupSheep doesn't allow all the pg_dump options. The pg_dump options mentioned in the table below are allowed. If you want us to include any option in this list then contact support.

Your PostgreSQL may not support all options. Refer https://www.postgresql.org/docs/current/app-pgdump.html to check supported options.

--data-only

--if-exists

--blobs

--inserts

--no-blobs

--lock-wait-timeout=timeout

--clean

--no-comments

--create

--no-publications

--encoding=encoding

--no-security-labels

--format=format

--no-subscriptions

--jobs=njobs

--no-sync

--no-owner

--no-table-access-method

--schema-only

--no-tablespaces

--verbose

--no-toast-compression

--no-privileges

--no-unlogged-table-data

--compress=0..9

--on-conflict-do-nothing

--column-inserts

--quote-all-identifiers

--attribute-inserts

--rows-per-insert=nrows

--disable-dollar-quoting

--section=sectionname

--disable-triggers

--serializable-deferrable

--enable-row-security

--snapshot=snapshotname

--extra-float-digits=ndigits

--strict-names

How to add pd_dump options?

To add the pg_dump option to your PostgreSQL node open the node detail page and click on the node modify button.

node modify

On the node modify page you will see text box with the label PostgresSQL(pg_dump) Options. Add all your options here. Options must be separated by space. Example

--column-inserts --no-owner --no-comments --no-privileges --rows-per-insert=500 --if-exists --clean

PostgresSQL(pg_dump) Options\

Did this answer your question?