Hi Stefan you might have missed Andreas answer in the other thread Andreas Rogge unread, 19 May 2026, 18:44:15 (7 days ago)
Am 19.05.26 um 01:03 schrieb Stefan Harbich: > i started a large backup via pgbouncer. Unfortunately, the backup is > failing. The missing table is a session-local temporary table. If the connection is lost or bgbouncer for some reason puts the Bareos connection onto another backend session this will happen. For pgbouncer that means you will have to run in session pooling mode, neither transaction pooling nor statement pooling will work with Bareos. Could you double-check that? On Tuesday, 19 May 2026 at 20:43:46 UTC+2 stefan.harbich wrote: > 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 > > > Am 19.05.2026 um 19:53, 'Brock Palen' via bareos-users < > [email protected]> schrieb: > > 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 <[email protected]> wrote: > > > 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 > > -- > 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 [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/bareos-users/12f1a2ed-ac65-4e4f-91de-1ac282f56fafn%40googlegroups.com > > <https://groups.google.com/d/msgid/bareos-users/12f1a2ed-ac65-4e4f-91de-1ac282f56fafn%40googlegroups.com?utm_medium=email&utm_source=footer>. > > > > -- > > 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 > [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/bareos-users/C56C5FC6-7E7B-4CC2-BD5D-98D2C61F4845%40mlds-networks.com > > <https://groups.google.com/d/msgid/bareos-users/C56C5FC6-7E7B-4CC2-BD5D-98D2C61F4845%40mlds-networks.com?utm_medium=email&utm_source=footer>. > > > > -- 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/aca0f8ae-e766-4599-af18-dd7476020b19n%40googlegroups.com.
