From nobody Mon Sep 16 18:27:30 2024 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4X6tgR2h2Zz5Wf3Y for ; Mon, 16 Sep 2024 18:27:31 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4X6tgQ6HMbz4csT for ; Mon, 16 Sep 2024 18:27:30 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1726511250; a=rsa-sha256; cv=none; b=aUpMGEqHgB/TQFNNILSHoXIfOcMsY9VSioB9Qh62qHLgn53nPt+K13xUE8WnLjqpFTCIPf 7lKw6UdnrXP1jmPGAXWiMzLSImwdGn/ySHjJtaU7/86UdLI4snn+R98v+QOMuwdg4sLBsS ZNQuyVMx6UmSucD9bExkV411hHFQAJZcMuDClSSwOR6VFx/MrlEsu+bDA+PlSBFAbkoGX4 sUFSrMiAfCkzm29IiHYkXd994fojKVoQFUXRq1jOa4JwN7ZjLXzOvgQzautzT/CDBsnGkP 9PnmsD//I7bHz374Xq4Dx7SaKbj12iZWXKQFpqRu3JSaKUpVhr1Z/gzWXVBrOQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1726511250; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=EYkNWbkglc2hKCdENOqZa6dU9R4E+u5sLgNPx5eJu0I=; b=qbc41HWkrOAUvmDBKAFY9yoTklqkNIClDQgvcgm5TbkHEyM3vL8UIB98vti6TB3goc9wFZ Yvw+q0kb8Wrfh939MPky6/qzT1xBtyLw7kVmkXlaCpD8n2j0GUwEEFcrTkkG1/TeZP123Z lnUn+kXy+lseKN7PZNwCbEa0fv/rkxkH1JTePhmQMsgpb7CrWA2UHKhObAssUOhDUfJKRI f9ZowsyBT2HYTD8fOanM5fdyg2NrIpuhUwZGhUbrijLmRdM731UFoXFGkTTTjSPfi/IIpo OCN3sSIig2/j9p0hNhlayRg0tJAqjfsBzG0GSWWbPH/XGr4yno1LjaIllfj1IA== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4X6tgQ5v4Pz15Bj for ; Mon, 16 Sep 2024 18:27:30 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 48GIRUje079207 for ; Mon, 16 Sep 2024 18:27:30 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 48GIRUVD079206 for ports-bugs@FreeBSD.org; Mon, 16 Sep 2024 18:27:30 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 281542] sysutils/bacula15-server: update_postgresql_tables fails to upgrade database Date: Mon, 16 Sep 2024 18:27:30 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: danmcgrath.ca@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: dvl@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-ports-bugs@freebsd.org Sender: owner-freebsd-ports-bugs@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D281542 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, b= ut I am noticing that Dan Langille's patches[1] to the upgrade scripts don't app= ear 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 instal= led the pg_trgm extension in the system via the postgres-contrib package, so th= ere 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 s= ure 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-upgr= ading-the-postgresql-database/ [2]: https://github.com/dlangille/bacula-community/commit/0200b1461310b4f5d4cdb8= 9aedaa2ca9c1e1ad77 [3]: https://github.com/dlangille/bacula-community/commit/716952b15b71be44f152bf= b522666514422acc95 [4]: https://dba.stackexchange.com/questions/165300/how-to-install-the-additiona= l-module-pg-trgm [5]: https://sourceforge.net/p/bacula/mailman/bacula-users/thread/bc615327-20eb-= 4084-9bd9-e66bb85c04a7%40app.fastmail.com/#msg54707411 --=20 You are receiving this mail because: You are the assignee for the bug.=