Home

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>