[Bug 281542] sysutils/bacula15-server: update_postgresql_tables fails to upgrade database
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Mon, 16 Sep 2024 18:27:30 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=281542
Bug ID: 281542
Summary: sysutils/bacula15-server: update_postgresql_tables
fails to upgrade database
Product: Ports & Packages
Version: Latest
Hardware: Any
OS: Any
Status: New
Severity: Affects Many People
Priority: ---
Component: Individual Port(s)
Assignee: dvl@FreeBSD.org
Reporter: danmcgrath.ca@gmail.com
Flags: maintainer-feedback?(dvl@FreeBSD.org)
Assignee: dvl@FreeBSD.org
It would appear that Bacula 9 is due to be EOL'd at the end of the month, but I
am noticing that Dan Langille's patches[1] to the upgrade scripts don't appear
to be applied. I have tested his provided patches[2][3], and found them to
work.
It is worth noting that the upgrade did appear to fail on me until I installed
the pg_trgm extension in the system via the postgres-contrib package, so there
may be some extra steps for people coming from 9.x to 15.x that find this
during searches. Just be sure to also run[4]:
CREATE EXTENSION pg_trgm;
The Bacula ML thread[5] had a discussion on it a while back, but I am not sure
why it was never included.
Anyway, hopefully it helps future travellers and upgradees! :)
---
[1]:
https://dan.langille.org/2023/11/23/bacula-moving-from-9-x-to-13-x-and-upgrading-the-postgresql-database/
[2]:
https://github.com/dlangille/bacula-community/commit/0200b1461310b4f5d4cdb89aedaa2ca9c1e1ad77
[3]:
https://github.com/dlangille/bacula-community/commit/716952b15b71be44f152bfb522666514422acc95
[4]:
https://dba.stackexchange.com/questions/165300/how-to-install-the-additional-module-pg-trgm
[5]:
https://sourceforge.net/p/bacula/mailman/bacula-users/thread/bc615327-20eb-4084-9bd9-e66bb85c04a7%40app.fastmail.com/#msg54707411
--
You are receiving this mail because:
You are the assignee for the bug.