pgsql-plugin

Oskars Ribulis

unread,

May 13, 2021, 2:41:32 PM5/13/21

to bareos-users

Hi to everyboady!

Unfortunately I'm stucked with pgsql plugin implementation.

On the Client#1 I have Debian 8 (jessie) with Bareos 19,2.7. version. Tried to install pgsql-plugin from https://github.com/bareos/contrib-pgsql-plugin, but no success, I'm confused, what is the correct path 'BAREOS_SRC =' ' in the Makefile. Without the correct bareos source path, Makefile is dropping errors.

On the Client#2 I have Debian 9 (stretch) with Bareos 20.0.1. but there is another problem. The database backup goes successfully only once, on the second and following attempts there is always an error.

Yavor Marinov

unread,

May 14, 2021, 2:51:27 AM5/14/21

to Oskars Ribulis, bareos-users

Why not using repos? I’m sure that the plugin is already provided there 😉

Also if you are not backing up huge databases, you can use RunWhen = Before for a script in order to dump (full or incremental) desired dbs. Otherwise, using piping works flawlessly

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/ddd451ea-49df-4408-9b54-7ff262eb28dbn%40googlegroups.com.

Message has been deleted

Oskars Ribulis

unread,

May 14, 2021, 7:43:39 AM5/14/21

to bareos-users

On the Client machine, I have 13 databases, and the total size of these DB are ~200GB.

As far as I see, Bareos 19,2.7. version is not providing a genuine Bareos pgsql-plugin, that's why I tried to install Bacula adapted plugin.

Yavor Marinov

unread,

May 14, 2021, 11:51:22 AM5/14/21

to Oskars Ribulis, bareos-users

strongly suggesting you not use Bacula's scripts, they most probably have different deps.

as of now, i have more than 20 instances of different backups (many of them are 19.X clients, others are 20.X) pgsql,mariadb and the repo plugins works just fine.

here is the working config

Plugin = "bpipe:file=/opt/scripts/db/dump.sql:reader=/opt/scripts/bin/pipein_sql.sh:writer=/opt/scripts/bin/pipeout_sql.sh"

all scripts are based on Bareos's documentation for piping database without using the local storage

To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/85665734-a280-43f2-88c0-a140971a9d0dn%40googlegroups.com.

Reply all

Reply to author

Forward