Bareos Backup: "Encryption between Director and PostgreSQL" Database Not Possible

[Stefan Harbich]

Hello,

i have established an encrypted connection between the Bareos Director and the PostgreSQL database using pgbouncer.

However, the backup consistently fails during larger backup jobs—regardless of the settings I use in pgbouncer.

It always returns the exact same error message:

...

bareos-dir JobId 2: Error: Bareos bareos-dir 25.0.4~pre116.b35277fb6 (30Apr26):
OS Information: Debian GNU/Linux 13 (trixie)
JobId: 2
Job: backup-dsme01-fd.2026-05-19_18.18.57_47
Backup Level: Full (upgraded from Incremental)
Client: "dsme01-fd" 25.0.3~pre96.1f53a5305 (26Mar26) Debian GNU/Linux 11 (bullseye),debian
FileSet: "LinuxServer" 2026-05-19 18:18:57
Pool: "Full" (From Job FullPool override)
Catalog: "MyCatalog" (From Client resource)
Storage: "File" (From Job resource)
Scheduled time: 19-Mai-2026 18:18:57
Start time: 19-Mai-2026 18:18:59
End time: 19-Mai-2026 18:43:11
Elapsed time: 24 mins 12 secs
Priority: 10
Allow Mixed Priority: no
FD Files Written: 450,068
SD Files Written: 450,068
FD Bytes Read: 69,823,568,948 (69.82 GB)
FD Bytes Written: 69,823,570,430 (69.82 GB)
SD Bytes Written: 69,894,049,058 (69.89 GB)
Rate: 48087,9 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s): Full-0001
Volume Session Id: 2
Volume Session Time: 1779205938
Last Volume Bytes: 69,914,108,576 (69.91 GB)
Non-fatal FD errors: 1
SD Errors: 0
FD termination status: OK
SD termination status: OK
Bareos binary info: Bareos community build (UNSUPPORTED): Get professional support from https://www.bareos.com
Job triggered by: User
Termination: *** Backup Error ***

bareos-dir JobId 2: Fatal error: cats/sql_create.cc:803 Fill Path table Query failed: INSERT INTO Path (Path)
SELECT a.Path
FROM (
SELECT DISTINCT Path
FROM batch
) AS a
WHERE NOT EXISTS (
SELECT Path
FROM Path
WHERE Path = a.Path
)
: ERR=ERROR: relation "batch" does not exist
ZEILE 5: FROM batch
^

29
2026-05-19 18:42:31
bareos-dir JobId 2: Insert of attributes batch table with 450067 entries start

28
2026-05-19 18:42:31
bareos-sd JobId 2: Elapsed time=00:23:31, Transfer rate=49.53 M Bytes/second

27
2026-05-19 18:42:29
bareos-sd JobId 2: Releasing device "FileStorage" (/media/backups/storage).

26
2026-05-19 18:19:00
bareos-sd JobId 2: Ready to append to end of Volume "Full-0001" size=590300

25
2026-05-19 18:19:00
bareos-sd JobId 2: Moving to end of data on volume "Full-0001"

...

It is a pity that it does not seem possible to establish a stable, secure connection between the Bareos Director and the PostgreSQL database via pgbouncer.

If there are no further solutions available,

I will unfortunately have to abandon the Bareos project.

The Bareos Director and the PostgreSQL database are not located within the same network segment; we would only be able to utilize this solution if a stable, secure connection were possible.

Regards Stefan Harbich

[Brock Palen]

Have you looked at a vpn between the sites? 

Sent from my iPhone

Brock Palen

On May 19, 2026, at 1:18 PM, Stefan Harbich <stefan....@harnet.de> wrote:



--
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 visit https://groups.google.com/d/msgid/bareos-users/12f1a2ed-ac65-4e4f-91de-1ac282f56fafn%40googlegroups.com.

[stefan.harbich]

Hello,

our locations are connected via VPN. Additionally, all critical communication connections should be encrypted using TLS. This also applies to backup connections within the VPN. Man-in-the-middle attack.

Regards, Stefan Harbich

You received this message because you are subscribed to a topic in the Google Groups "bareos-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/bareos-users/F1uPV-IYY8s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to bareos-users...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/bareos-users/C56C5FC6-7E7B-4CC2-BD5D-98D2C61F4845%40mlds-networks.com.