#1113777 Bacula update script /usr/share/bacula-director/update_postgresql_tables is broken

Package:
bacula-director-pgsql
Source:
bacula-director-pgsql
Submitter:
Joop Boonen
Date:
2025-09-02 16:05:03 UTC
Severity:
normal
#1113777#5
Date:
2025-09-02 13:20:45 UTC
From:
To:
 Version: 15.0.3-3

When I invoke

 sudo -u postgres /usr/share/bacula-director/update_postgresql_tables -d <bacula_database>
The Baculadatabase isnt' upgraded due to a few "errors" in the script.



The First error the psql dump is created without a -q, this causes that header data ends up in the file. Because of this the restore fails.



Secondly the postgresql do $$ is not correctly escaped. Therefore bash replaces the $$ to the current process id.








  I suggest the following patch:
#1113777#10
Date:
2025-09-02 15:45:55 UTC
From:
To:
Hi Joop,

thanks for your report. We have already addressed this in version
15.0.3-4, which unfortunately is not in the current Debian stable
release (c.f. bug #1108272).

We highly recommend letting dbconfig-common handle the databases.

Regards

Carsten


Joop Boonen <joop.boonen@credativ.de> writes:
#1113777#25
Date:
2025-09-02 16:03:07 UTC
From:
To:
Hi Joop,

actually, we fixed the escaping, but this is the first time we hear
about the "-q" parameter problem.

We'll need to investigate that.

Regards

Carsten


Carsten Leonhardt <leo@debian.org> writes: