Gentoo ships dev-db/barman up to 2.19, but PostgreSQL 15 requires at least 3.0.0. Barman is designed to be compatible with previous versions. I have successfully upgraded to 3.2.0 by just renaming the ebuild. All basic functionality seems to be working: - documented cronjobs continue to work - command syntax stays the same Upgrading PostgreSQL 15 itself failed because of a bug regarding ACLs on some objects. I'm not sure wether to note those with this ebuild or postgresql upgrade instructions or postgresql ebuild. You'll need to run these commands PRIOR to upgrading to postgresql 15 or pg_restore fails: REVOKE EXECUTE ON FUNCTION pg_start_backup(text, boolean, boolean) from barman; REVOKE EXECUTE ON FUNCTION pg_stop_backup() from barman; REVOKE EXECUTE ON FUNCTION pg_stop_backup(boolean, boolean) from barman; GRANT EXECUTE ON FUNCTION pg_backup_start(text, boolean) to barman; GRANT EXECUTE ON FUNCTION pg_backup_stop(boolean) to barman; Reproducible: Always Steps to Reproduce: 1. Install dev-db/barman 2. Expect barman to work with postgresql 15 3. Actual Results: Barman is too old to work with Postgresql 15 Expected Results: Barman just continues to work (maybe, see SQL statement explanation)
REVOKE needs to be done before upgrade, GRANT after the upgrade
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=18fec8580b363f15a0bd951ec6b170b0d8960eb2 commit 18fec8580b363f15a0bd951ec6b170b0d8960eb2 Author: Patrick Lauer <patrick@gentoo.org> AuthorDate: 2022-12-02 06:56:05 +0000 Commit: Patrick Lauer <patrick@gentoo.org> CommitDate: 2022-12-02 06:56:27 +0000 dev-db/barman: add 3.2.0 Closes: https://bugs.gentoo.org/878921 Signed-off-by: Patrick Lauer <patrick@gentoo.org> dev-db/barman/Manifest | 1 + dev-db/barman/barman-3.2.0.ebuild | 48 +++++++++++++++++++++++++++++++++++++++ 2 files changed, 49 insertions(+)
