PostgreSQL Plugin Options in Dump Mode

PostgreSQL Plugin Options in Dump Mode

Option	Comment	Default	Example
dump_opt	This string will be passed to the pg_dump command. 1	-c -b -F p	dump_opt=”-c”
user	PostgreSQL user to use for PostgreSQL commands.	postgres	user=rob
unix_user	Unix user to use for PostgreSQL commands. 2	set to user	unix_user=pg1
service	pg_service to use for PostgreSQL commands.		service=main
pgpass	Path to PostgreSQL password file.		pgpass=/etc/pgpass
use_sudo	Use sudo instead to run PostgreSQL commands (when not root).		use_sudo
compress	Use pg_dump compression level. 0-9, 0 is off.	0	compress=5
database	Will backup on databases matching this string.		database=prod*
exclude	Will exclude databases matching this string. 5		exclude=test*
bin_dir	PostgreSQL binaries location.		bin_dir=/opt/pg9.1/bin
tmp_dir	Where the plugin will create files and scripts for the database backup. 3	/tmp	tmp_dir=/othertmp
abort_on_error	Abort the job after a connection error with PostgreSQL. 4	not set	abort_on_error
timeout	Specify a custom timeout (in secs) for commands sent to PostgreSQL.	60 seconds	timeout=120

1 The dump_opt option cannot be used to backup remote servers. Please use PGSERVICE instead

2 Available with Bacula Enterprise 8.4.12 and later.

3 Available with Bacula Enterprise 6.6.6 and later.

4 Available with Bacula Enterprise 8.2.0 and later.

5 Available with Bacula Enterprise 14.0.5 and later.

Note

The database and exclude options support regex.