Dump Configuration

With the Dump option, Bacula cannot perform Incremental or Differential backup.

Job {
 Name = "Postgresql-dump"
 Client = laptop1-fd
 FileSet = FS_postgresql_dump
 ...
}

FileSet {
 Name = FS_postgresql_dump
 Include {
   Options {
     Signature = MD5
     Compression = GZIP
   }
   Plugin = postgresql
 }
}

With the above example, the Plugin will detect and backup all databases of the Cluster.

FileSet {
 Name = FS_postgresql
 Include {
   Options {
     Signature = MD5
     Compression = GZIP
   }
   Plugin = "postgresql: database=bacula"
   Plugin = "postgresql: database=master"
 }
}

In this example, the Plugin will backup only the databases bacula and master.

In Dump mode, the PostgreSQL Plugin also accepts the parameters listed here.

FileSet {
 Name = FS_postgresql_dump
 Include {
   Options {
     Signature = MD5
   }
   Plugin = "postgresql: use_sudo user=rob dump_opt=\"-T temp\""
 }
}

In this example, the PostgreSQL Plugin will use the Unix account “rob” to perform a Custom Dump backup with the PostgreSQL “rob” account excluding tables named “temp”.

In order to use the sudo wrapper, it is needed to comment out the following option in /etc/sudoers.

Defaults requiretty