Bug 878921

Summary:	dev-db/barman bump to 3.2.0
Product:	Gentoo Linux	Reporter:	satmd <satmd>
Component:	Current packages	Assignee:	Patrick Lauer <patrick>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description satmd 2022-10-31 20:31:23 UTC

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)

Comment 1 satmd 2022-10-31 20:34:47 UTC

REVOKE needs to be done before upgrade, GRANT after the upgrade

Comment 2 Larry the Git Cow gentoo-dev

2022-12-02 06:56:31 UTC

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(+)