Package Details: bareos-database-postgresql 19.2.6-1

Git Clone URL: (read-only, click to copy)
Package Base: bareos
Description: Bareos - Backup Archiving REcovery Open Sourced - Libs and tools for postgresql catalog
Upstream URL:
Keywords: Backup bacula bareos
Licenses: AGPL3
Groups: bareos
Provides: bareos-database=19.2.6
Submitter: AlD
Maintainer: None
Last Packager: mfulz
Votes: 17
Popularity: 0.87
First Submitted: 2014-07-23 09:45
Last Updated: 2020-02-19 22:31

Latest Comments

1 2 3 4 5 6 ... Next › Last »

bsdice commented on 2022-01-21 02:54

There's a new test version up at and I zipped up all files for easier download. Single file access is still possible at I also changed the mime-type on the web server to text/plain so if you click on a file, it will show in the browser as a preview and not annoyingly download right away.

My example configs and example scripts are now part of the package, instead of being bystanders. Can be found in /etc/bareos/examples. Dito for the NGINX config, which is now a single file. I made a README also in this directory to explain more concepts of the examples. Cleaned up tape-helper, with settings now at start of the file. Bunch more PKGBUILD bugfixes.

If you populate /etc/bareos with working


files things should start to work pretty fast.

Well let me know what you think and if you could get it to work.

bsdice commented on 2022-01-20 03:29

OK I spent the evening fixing things...

Download is again available at

  • All changes are now fully AGPL3 compatible.
  • The default is now a non-debug build, resulting in a 5 MB .zst-archive for everything (neat!).
  • CAP_SYS_PTRACE capability is removed for security reasons in non-debug builds.
  • Explained and extended optional deps more.
  • PKGBUILD will now include all AUR files in the package (/etc/bareos/pkgbuild). This may seem weird but it will allow you to copy the single directory /etc/bareos off to some other place, and you will have everything necessary to bootstrap your server back into life. This is especially helpful when you need to stay at the installed Bareos version during disaster recovery.
  • I included a few nginx snippets in nginx/ to help people understand how to get the web UI going quickly.
  • Also included are now sanitized configuration files which I personally use, see etc_bareos/. bareos-dir.conf contains some more lenghty explanations.

LTO is a solid and safe backup technology. I'd hope with a bit of mentoring and polishing of this package people will appreciate this too and spin up a trial in their own computer landscape.

#Arch #LTOultras ;-)

bsdice commented on 2022-01-18 21:13

@wcasanova I know, and I am sorry. I had to take it down because after reading the AGPL3 license text I realized some patches might be in violation. Other things taking precedence I can't work on this right now. Some patches may be substitutable with deletion sequences in PKGBUILD which have no origin in the source code unlike patch files, so could possibly be distributed. But if you run this at your university or CERN or something, with others accessing it, you would again be in violation. On the other hand I really can't have my browser phone home to the Bareos guys every time I open the web UI. This being Germany which has overtaken litigious USA on the right, I need to find a precedence-proofed solution.

wcasanova commented on 2022-01-18 20:45

@bsdice, the new changes you mention are no longer available.

bsdice commented on 2022-01-17 01:54

You're welcome. I updated the systemd files to include SuccessExitStatus for error-message-less stopping of services. New PKGBUILD I just uploaded also includes a better cleanup of the entire web GUI tree, which I audited manually to really get rid of 99% of useless files.

Currently using this at home with an LTO-5 and an LTO-6 drive. System runs quarterly fulls to LTO-6 and daily incrementals to LTO-4. Tape drives are turned on/off on demand via the USB box, ZFS snapshot create/delete before/after backup run, second run after main backup run saves database+PKGBUILD+files+configuration to tape for disaster recovery purposes. Operator command is a script which beeps to alert me, should I happen to be around, unmounts tape in Bareos and ejects the tape, because it will want another one anyway, and also sends me an e-mail.

I included a bunch more files:

1) parses binary MAM data into human-readable output. Should probably be rewritten in C. I made it work with recent Perl versions from older versions found on the web.

2) tape-label: Needs configuration in the file. Argument will be tape name. Loads tape, writes EOF to start to delete any records, rewinds, labels in Bareos, ejects tape again.

3) tape-operator: Beep, unmount, eject tape when Bareos wants a new tape. Used in bareos-dir.conf Messages resource as "operatorcommand". Needs correct storage name as first argument to know what to eject and then the usual bstmp command following.

4) tape-helper: Needs in-script configuration. As such probably only useful in my system, but just to give anyone interested an idea what can be done feature-wise. Like ZFS snapshots, USB-control, send e-mail in case drive wants a cleaning tape, read MAM chip of cartridge and send to etc.

Only thing missing is now my six config files bareos-sd|dir|fd.conf bconsole.conf and the two .ini files for the web UI. No time to sanitize right now.

wcasanova commented on 2022-01-16 23:28

@bsdice thanks

spradlim commented on 2021-12-24 01:04

Obviously, I am not really maintaining this. (I moved to borg) I don't think mfulz is either. Let me know if anyone would like to be a maintainer or would like to own the package.

bsdice commented on 2021-12-23 16:29

Hey guys, I ported this AUR to Bareos version 22 i.e. latest git as of yesterday for my own personal use.

You can find the PKGBUILD and necessary files at

Some notes:

  • Single AUR package only, because deciding what packages you need is hard.
  • PostgreSQL only from 21 on, check official release notes. You have to migrate to this database before updating.
  • Disabled phone home and prettified some areas; a matter of taste.
  • Various compile fixes, PHP warning fixes, measures to cut back on log spam.
  • For the web-GUI nginx is recommended, I deprecated Apache.
  • Binaries are unstripped and daemons run among others with CAP_SYS_PTRACE privileges so I can debug segfaults.
  • New systemd-service files. All daemons run as user "bareos". File daemon gets CAP_DAC_READ_SEARCH to read everything without root.
  • Meticulous cleaning of useless files before packaging.
  • I am using a USB relais box to switch on two LTO drives before jobs, that's what 99-bareos-usb.rules is for, to fix up device permissions.
  • Tested with a LTO-5 and LTO-6 drive.

I also have a couple of unpublished scripts and .conf files to tie everything together. Mostly to turn tape drives on/off using the USB box, read the cartridge MAM chip, send mail warnings on tape alerts (e.g. when cleaning is necessary), to queue backup jobs from a systemd timer depending on time of day and day of week (rare fulls to LTO-6, daily incrementals to LTO-4 but on different drive), or to unmount and eject the tape and play an audible beep in Backup Exec style if operator intervention is required.

Personally I like handcrafted single bareos-(dir|sd|fd).conf and bconsole.conf files more than the spread out directories with many partial config files. After 2-3 years of using the software, I think I got the hang of it.

All my contributions are licensed CC0 i.e. in the public domain, or as governed by the original license if more restrictive.

hirnschmalz commented on 2021-01-17 12:16

I tried to install bareos on one of my machines. During the build I go the following error

/home/XXXXX/.cache/rua/build/bareos/src/bareos/core/src/plugins/filed/ error: cannot convert 'stat*' to 'ceph_statx*'

I had samba installed which requires ceph-libs. After removing those two packages the build did finish successfully.

deep_thought commented on 2021-01-09 21:48

This makes version 20.0.0 compile for me - not sure, if this is the right thing to do, though.

--- a/core/src/droplet/libdroplet/src/utils.c   2020-12-16 08:46:16.000000000 +0100
+++ b/core/src/droplet/libdroplet/src/utils.c   2021-01-09 21:28:43.099999815 +0100
@@ -33,7 +33,7 @@
 #include <dropletp.h>
 #include <linux/xattr.h>
-#include <attr/xattr.h>
+#include <sys/xattr.h>
 #include <errno.h>

 /** @file */
--- a/core/src/droplet/libdroplet/include/droplet/cdmi/crcmodel.h   2020-12-16 08:46:16.000000000 +0100
+++ b/core/src/droplet/libdroplet/include/droplet/cdmi/crcmodel.h   2021-01-09 21:50:10.506666487 +0100
@@ -78,7 +78,6 @@
 #ifndef DONE_STYLE

 typedef unsigned long   ulong;
-typedef unsigned        bool;
 typedef unsigned char * p_ubyte_;

 #ifndef TRUE
@@ -106,8 +106,8 @@
    int   cm_width;   /* Parameter: Width in bits [8,32].       */
    ulong cm_poly;    /* Parameter: The algorithm's polynomial. */
    ulong cm_init;    /* Parameter: Initial register value.     */
-   bool  cm_refin;   /* Parameter: Reflect input bytes?        */
-   bool  cm_refot;   /* Parameter: Reflect output CRC?         */
+   _Bool cm_refin;   /* Parameter: Reflect input bytes?        */
+   _Bool cm_refot;   /* Parameter: Reflect output CRC?         */
    ulong cm_xorot;   /* Parameter: XOR this to output CRC.     */

    ulong cm_reg;     /* Context: Context during execution.     */
--- a/core/src/droplet/libdroplet/src/backend/posix/reqbuilder.c    2020-12-16 08:46:16.000000000 +0100
+++ b/core/src/droplet/libdroplet/src/backend/posix/reqbuilder.c    2021-01-09 22:27:57.346666239 +0100
@@ -39,7 +39,7 @@
 #include <dirent.h>
 #include <sys/types.h>
 #include <linux/xattr.h>
-#include <attr/xattr.h>
+#include <sys/xattr.h>
 #include <utime.h>
 #include <pwd.h>
 #include <grp.h>