Skip to content
Radosław Korzeniewski edited this page Jun 18, 2013 · 24 revisions

Welcome to the pgsql-plugin wiki!

Requirements:

  • Bacula source code. It could be Community or Enterprise version
  • compiler utilities and libraries
  • PostgreSQL development library - libpq-dev

INSTALL:

For successful build you should choose a proper Makefile based on your Operating System. You can choose from: Linux, OSX and Solaris. Next you need to setup a Makefile variables inside selected makefile:

BACULASRC = bacula.enterprise.git

is where your Bacula source code is available relative to '..' directory.

plugindir = /opt/bacula/plugins
sbindir = /opt/bacula/bin
libdir = /opt/bacula/lib64
confdir = /opt/bacula/etc

are where you want to install pgsql plugin and utilities.

Next you need to configure and compile Bacula, because plugin compilation require this. Then finally standard:

$ make clean
$ make all
$ sudo make install 

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>`

Clone this wiki locally