Sven Hartge <s...@svenhartge.de> writes: > On 16.03.25 22:49, Carsten Leonhardt wrote:
>> 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. Apparently it needs the conditional: # echo "CREATE EXTENSION pg_trgm;" | sudo -u postgres psql bacula ERROR: extension "pg_trgm" already exists What's strange is that a fresh install works without having to resort to dbadmin privileges and it ends up with the extension installed. Also updates from a freshly installed 9.6.7 work ok and install the extension during the upgrade. Anyway, a fix is arriving in git now.
