[pkg-bacula-devel] Bug#1100649: bacula-director-pgsql: Upgrade wants database extension but doesn't have permission

[Sven Hartge]

On 16.03.25 22:49, Carsten Leonhardt wrote:

> this doesn't seem to have been forwarded to the list, so FYI.

No, I got it through the list. I also got it from the PTS.

> Probably it would be easiest have dbconfig-common first run that part of
> the upgrade as superuser.

> Workaround:
> 
> Execute the following before the upgrade:
> 
> echo "CREATE EXTENSION pg_trgm;" | sudo -u postgres psql bacula

Does it need to be conditional or will it be a NOOP if the extension 
already exists? I know nearly nothing about PSQL, so I have no idea.

S°