PostgreSQL pg_dump Options

Using Custom pg_dump Options in PostgreSQL Nodes

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.

Test Your Backup with Custom Options

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.

Restricted pg_dump Options

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	--exclude-table-data=pattern
--exclude-schema=pattern	--exclude-table=pattern

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.

On the node modify page you will see a 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