Package: pdns-backend-pgsql Version: 4.7.3-2 Severity: important Dear Maintainer,
Upon upgrading, manual steps are required to update the schema of the SQL tables as mentioned upstream here: https://doc.powerdns.com/authoritative/upgrading.html#schema-changes Unfortunately I did not find this mentioned in NEWS or changelog leading to errors on upgrade: --- Exiting because communicator thread died with error: virtual void GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&, std::unordered_set<DNSName>&, CatalogHashMap&) unable to retrieve list of master domains: Fatal error during prePQpreparepare: select domains.id, domains.name, domains.type, domains.notified_serial, domains.options, domains.catalog, records.content from records join domains on records.domain_id=domains.id and records.name=domains.name where records.type='SOA' and records.disabled=false and domains.type in ('MASTER', 'PRODUCER'): ERROR: column domains.options does not exist --- I suggest these changes are mentioned in the debian upgrades notes thanks, Dan -- System Information: Debian Release: 12.1 APT prefers stable-security APT policy: (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 6.1.0-12-amd64 (SMP w/2 CPU threads; PREEMPT) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages pdns-backend-pgsql depends on: ii libc6 2.36-9+deb12u1 ii libgcc-s1 12.2.0-14 ii libpq5 15.3-0+deb12u1 ii libstdc++6 12.2.0-14 ii pdns-server 4.7.3-2 pdns-backend-pgsql recommends no packages. Versions of packages pdns-backend-pgsql suggests: pn postgresql <none> -- no debconf information
