Configuration files

pgsql.conf file for backup:

#
# Config file for pgsql plugin
#
PGDATA = <pg.data.cluster.path>
PGHOST = <path.to.sockets.directory>
PGPORT = <socket.'port'>
PGVERSION = "8.x" | "9.x"
CATDB = <catalog.db.name>
CATDBHOST = <catalog.db.host>
CATDBPORT = <catalog.db.port>
CATUSER = <catalog.db.user>
CATPASSWD = <catalog.db.password>
ARCHDEST = <destination.of.archived.wal's.path>
ARCHCLIENT = <name.of.archived.client>

pgsql.conf file for restore:

#
# Config file for pgsql plugin
#
PGDATA = <pg.data.cluster.path>
PGHOST = <path.to.sockets.directory>
PGPORT = <socket.'port'>
PGSTART = <pg_ctl.command.location.and.options>
PGSTOP = <pg_ctl.command.location.and.options>
CATDB = <catalog.db.name>
CATDBHOST = <catalog.db.host>
CATDBPORT = <catalog.db.port>
CATUSER = <catalog.db.user>
CATPASSWD = <catalog.db.password>
ARCHDEST = <destination.of.archived.wal's.path>
ARCHCLIENT = <name.of.archived.client>
DIRNAME = <director.name>
DIRHOST = <director.address>
DIRPORT = <director.service.port>
DIRPASSWD = <director.connection.password>

and valid bacula console resource in bacula-dir.conf:

#
# Restricted console used for client initiated restore
#
Console {
   Name = <name.of.bacula.client>
   Password = <console.password>
   CommandACL = restore,.filesets,wait
   ClientACL = <name.of.bacula.client>
   CatalogACL = <bacula.catalog>       # it is not pgsql catalog database
   WhereACL = "*all*"
   JobACL = <job.names.for.pgsql.backup.and.pgsql.archbackup>
   PoolACL = <pool.names.of.pgsql.backup.and.pgsql.archbackup>
   StorageACL = <bacula.sd.name>
   FileSetACL = <fileset.name.of.pgsql.db.backup>,<and.pgsql.archbackup>
}