Your message dated Fri, 28 Mar 2025 09:19:06 +0000
with message-id <[email protected]>
and subject line Bug#1100649: fixed in bacula 15.0.2-2
has caused the Debian Bug report #1100649,
regarding bacula-director-pgsql: Upgrade wants database extension but doesn't
have permission
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1100649: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1100649
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: bacula-director-pgsql
Version: 15.0.2-1
Severity: important
File: /usr/share/dbconfig-common/data/bacula-director-pgsql/upgrade/pgsql/15.0.0
(See below for a workaround)
The upgrade contains instructions to install the postgres extension
"pg_trgm" if not already installed, but only the database superuser is
allowed to install it. The database upgrade fails and consequently the
packages upgrade fails too.
Some installations seem to already have the extension installed for the
bacula database. Maybe it depends on the age of first installation?
The error message:
ERROR: permission denied to create extension "pg_trgm" HINT: Must have CREATE
privilege on current database to create this extension.
CONTEXT: SQL statement "CREATE EXTENSION pg_trgm" PL/pgSQL function
inline_code_block line 11 at SQL statement
The code in question:
do $$
declare
selected_ext pg_extension%rowtype;
begin
select 1 from pg_extension
into selected_ext
where extname = 'pg_trgm';
if not found then
CREATE EXTENSION pg_trgm;
end if;
end $$;
Workaround:
Execute the following before the upgrade:
echo "CREATE EXTENSION pg_trgm;" | sudo -u postgres psql bacula
--- End Message ---
--- Begin Message ---
Source: bacula
Source-Version: 15.0.2-2
Done: Carsten Leonhardt <[email protected]>
We believe that the bug you reported is fixed in the latest version of
bacula, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Carsten Leonhardt <[email protected]> (supplier of updated bacula package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Fri, 28 Mar 2025 03:04:26 +0100
Source: bacula
Architecture: source
Version: 15.0.2-2
Distribution: unstable
Urgency: high
Maintainer: Debian Bacula Team <[email protected]>
Changed-By: Carsten Leonhardt <[email protected]>
Closes: 1100649
Changes:
bacula (15.0.2-2) unstable; urgency=high
.
* Update Standards-Version to 4.7.2, no changes required.
* Added po-debconf Catalan translation (thanks to Carles Pina i Estany)
* Install postgresql database extension as database
administrator. (Closes: 1100649)
Checksums-Sha1:
a46f602944cdc98622dacd7a69a3035d5a55fda2 3716 bacula_15.0.2-2.dsc
b1a0077c2332d950b631b56f97cf71c759e0c33d 97404 bacula_15.0.2-2.debian.tar.xz
Checksums-Sha256:
6bc5f919319fb434427352c4472a15476e9439286115f693f555d7688920c828 3716
bacula_15.0.2-2.dsc
65f6146508101a920140c18329ee7dba7012a7739e4bd2720d06d0de075b888c 97404
bacula_15.0.2-2.debian.tar.xz
Files:
f3d020c56e2a9f07e1ee7e767844fbc0 3716 admin optional bacula_15.0.2-2.dsc
17d376508d474656ae13c6dc92a4b879 97404 admin optional
bacula_15.0.2-2.debian.tar.xz
-----BEGIN PGP SIGNATURE-----
iQJDBAEBCgAtFiEETxO/995XSygF6EUmKrIctfbulV4FAmfmZ6cPHGxlb0BkZWJp
YW4ub3JnAAoJECqyHLX27pVeMS8P/24unN/OsCF9Tct21Uirj5AjC8uxXaXcGQkA
tnotIlIm4fCEoYOOYyMzt6koM0NyLd9Xv/BBkkubR6m8j3Uy2sFsgCahi8aRggeE
gF9x0ifwpbfc/Kt8zJ8pkLSGoi/080f05/SGsTpfvLJ5LMBS/eeMfdMP4/M6xVS1
FVc4J8BjtyqIXsddhvRk7w6GNaQDVlpgbstMG1RfmaZu5VcKgouuMFPsI7k7ZKy2
yrkV3gsEb22DYCO8mF6wx+Rj5t1nRCaG97NZ/oIRjyaljBHTpmfhJqOjOicwoKy+
zd0AoeWfWmhiF6V7S1396exaXDs9oOi5dT4YGJGqR9cS8RjLQYEeKksk2w9bvMCq
YD0I9z8fIOCHqxoD/rdtsEnB23tjWBS0Uh50oLWxkdUoSAM57jmqLKzgm/1Tic7l
ZGE8NS1tvu2mKG5HdEG/rzmViAcCR/REhFkJCIiaQ0NOUuOfydzbtlA7tLjDR10S
YKeEzIx9gDv7wAKsNk6HF+euoD5pCbjgbD0NAbQyOfq0ixO+mH1d+VgOmo+/1Gcr
nzHmohEPxAFk/kOu0b9LHdb9FJIPDh5FiKgoCSdwD7W7y62OiZrO31cto3gL87Wf
y6b5i/1lb8Ok3lpnjWBd7y5NBgGdSjv29gCoMANDNKibyAGRBzZ/bMOCwqRyu3On
3JqSIJhe
=kML0
-----END PGP SIGNATURE-----
pgpMzqIruqDwa.pgp
Description: PGP signature
--- End Message ---
