PostreSQL Plugin Options in PITR Mode

PostgreSQL Plugin Options in PITR Mode

Option	Comment	Default	Example
mode=pitr	Needed to enable PITR backup.	custom
abort_on_error	Abort the job after a connection error with PostgreSQL (available with Bacula Enterprise 8.2.0 and later).	not set	abort_on_error
archive_dir	Should point to where you are archiving WAL with the archive_command.	pg_wal
bin_dir	PostgreSQL binaries location.		bin_dir=/opt/pg9.1/bin
fast_backup	Use fast backup option in pg_backup_start() procedure. It will create a peak of IO if used.	false	fast_backup
pgpass	Path to PostgreSQL password file.		pgpass=/etc/pgpass
user	PostgreSQL Unix super user. A standard user cannot be used here.	postgres	user=dba
service	PostgreSQL connection information.		service=main
timeout	Specify a custom timeout (in secs) for commands sent to PostgreSQL.	300	timeout=600
tmp_dir	Where the plugin will create files and scripts for the database backup (available with Bacula Enterprise 6.6.6 and later).	/tmp	tmp_dir=/othertmp
use_sudo	Use sudo to execute Postgresql commands.		use_sudo
unix_user	Use specific unix user to execute Postgresql commands. The unix user owning the cluster is required.	postgres	unix_user=bob

See also

Go back to:

• PostgreSQL Configuration for PITR

• PostgreSQL Plugin Configuration for PITR

Go to:

• Backup Level in PITR

• Schedule Consideration for PITR

Go back to the PITR Configuration page.

Go back to the main PostgreSQL Configuration page page.

Go back to the Dedicated Backup Solutions page page.