[Debian-astro-maintainers] Bug#1053552: gavodachs2-server: Error while setting up with postgresql 16

[Ole Streicher]

Package: gavodachs2-server
Version: 2.8+dfsg-3
Severity: serious

Hi Markus,

While running the migration test for astropy 5.3.4-1, the installation
of gavodachs2-server failed. Relevant lines from the log:

103s Setting up gavodachs2-server (2.8+dfsg-3) ...
103s Created symlink /etc/systemd/system/multi-user.target.wants/dachs.service → /lib/systemd/system/dachs.service.
103s info: Selecting GID from range 1000 to 59999 ...
103s info: Adding group `gavo' (GID 1001) ...
103s info: The home dir /nonexistent you specified can't be accessed: No such file or directory
103s
103s info: Selecting UID from range 100 to 999 ...
103s
103s info: Adding system user `gavo' (UID 103) ...
103s info: Adding new user `gavo' (UID 103) with group `gavo' ...
103s info: Not creating `/nonexistent'.
103s info: Adding user `dachsroot' ...
103s info: Selecting UID from range 1000 to 59999 ...
103s
103s info: Adding new user `dachsroot' (1001) with group `gavo (1001)' ...
103s info: Creating home directory `/home/dachsroot' ...
103s info: Copying files from `/etc/skel' ...
103s info: Adding new user `dachsroot' to supplemental / extra groups `users' ...
103s info: Adding user `dachsroot' to group `users' ...
108s *** Error: While executing DB query:
108s
108s   alter role untrusted set extra_float_digits=3
108s
108s The database engine reported:
108s
108s   ERROR:  permission denied to alter role
108s DETAIL:  Only roles with the CREATEROLE attribute and the ADMIN option
108s on role "untrusted" may alter this role.
108s
108s dpkg: error processing package gavodachs2-server (--configure):
108s  installed gavodachs2-server package post-installation script subprocess returned error exit status 1
108s dpkg: dependency problems prevent configuration of autopkgtest-satdep:
108s  autopkgtest-satdep depends on gavodachs2-server; however:
108s   Package gavodachs2-server is not configured yet.
108s
108s dpkg: error processing package autopkgtest-satdep (--configure):
108s  dependency problems - leaving unconfigured
108s Errors were encountered while processing:
108s  gavodachs2-server

Full log here: https://ci.debian.net/data/autopkgtest/testing/amd64/g/gavodachs/38631770/log.gz

I don't think that has anything to do with the astropy update. This
seems to be connected to Postgresql version (16.0-2); a similar install
(with Postgresql 15.4-3) succeeded.