Your message dated Wed, 21 Dec 2016 11:00:11 +0000 with message-id <e1cjed1-000cia...@fasolo.debian.org> and subject line Bug#838812: fixed in postgresql-common 178 has caused the Debian Bug report #838812, regarding pg_upgradecluster fails when datdba is a role without login privilege to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 838812: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=838812 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: postgresql-common Version: 114 Severity: minor Hi, Script /usr/bin/pg_upgradecluster fails (silently drops data) on databases which has datdba set as a role without login access. I can narrow this bug to use of pg_user view in query: "select datname, datallowconn, pg_catalog.pg_encoding_to_char(encoding), usename from pg_database, pg_user where datdba = usesysid" in line 375. Not all roles/groups are shown in this view, I think that on postgresql versions 8.1+ it's better to use query like this: "select datname, datallowconn, pg_catalog.pg_encoding_to_char(encoding), rolname from pg_database, pg_authid where datdba = pg_authid.oid" Spotted on upgrade from 8.4 to 9.0 on debian/lenny (with backports) but this database query is identical to official debian/stable (or sid) package version. Roles and privileges: CREATE ROLE pol_admin; ALTER ROLE pol_admin WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB NOLOGIN; GRANT pol_admin TO <some_login_user>; ALTER DATABASE pol OWNER TO pol_admin; Then pg_upgradecluster omit data (schema is created correctly) on "pol" database. Best regards, Kupson
--- End Message ---
--- Begin Message ---Source: postgresql-common Source-Version: 178 We believe that the bug you reported is fixed in the latest version of postgresql-common, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 838...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg <m...@debian.org> (supplier of updated postgresql-common package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@ftp-master.debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Tue, 20 Dec 2016 17:11:15 +0100 Source: postgresql-common Binary: postgresql-common postgresql-client-common postgresql-server-dev-all postgresql postgresql-client postgresql-doc postgresql-contrib postgresql-all Architecture: source all Version: 178 Distribution: unstable Urgency: medium Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org> Changed-By: Christoph Berg <m...@debian.org> Description: postgresql - object-relational SQL database (supported version) postgresql-all - metapackage depending on all PostgreSQL server packages postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-common - manager for multiple PostgreSQL client versions postgresql-common - PostgreSQL database-cluster manager postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-doc - documentation for the PostgreSQL database management system postgresql-server-dev-all - extension build tool for multiple PostgreSQL versions Closes: 614374 838812 845356 Changes: postgresql-common (178) unstable; urgency=medium . [ Christoph Berg ] * pg_buildext: Don't ask pg_virtualenv for a new network namespace by default. * postgresql-all: New meta package depending on all server packages in all supported versions. Intended to be used for installing test dependencies. * pg_upgradecluster: Properly upgrade databases with non-login role owners. (Closes: #614374, #838812) * pg_upgradecluster, pg_renamecluster: Update cluster_name. * Rebuild upgrades libreadline to 7 in unstable. (Closes: #845356) * Replace most occurrences of "postmaster" by "postgres". Notable leftover is the postmaster.1.gz leader of the manpages alternatives group. * pg_ctlcluster, t/020_create_sql_remove.t: Protect against symlink in /var/log/postgresql/ allowing the creation of arbitrary files elsewhere. Discovered by Dawid Golunski, thanks! . [ Martin Pitt ] * debian/supported-versions: Add Ubuntu 17.04, drop EOLed releases. * t/TestLib.pm, check_clean(): Quiesce stderr of netstat, which shows a "Not all processes could be identified" warning in unprivileged containers. Checksums-Sha1: 80d4ea5c7c7d4deeaff95fe709373a08a5a2ed7c 2344 postgresql-common_178.dsc ff4e7ea891d55e13f9f34dc273a7c9e63d6d759a 200272 postgresql-common_178.tar.xz e0756858cb6fc865b61a3c00d17564249ca5355b 55220 postgresql-all_9.6+178_all.deb 0f0f9f1ce8378dd0da39e4c0163067817f10134a 78280 postgresql-client-common_178_all.deb bdaee3da609424d090bdd8f31a11d1c05cfb55b3 55140 postgresql-client_9.6+178_all.deb 148b7e77914eeb0b0b300987bf7c41af6ddbd54c 214938 postgresql-common_178_all.deb 3b8dce65d089256e601cac419160565a2da4179c 7072 postgresql-common_178_amd64.buildinfo 76a0b7891de3c39ecb19f9bee263b1ffddbc6e32 55136 postgresql-contrib_9.6+178_all.deb 4ab7228606793826c7514f89095bfc3bdba697c4 55124 postgresql-doc_9.6+178_all.deb 3d430593738ecd3d199a501ce67165e454cce125 62986 postgresql-server-dev-all_178_all.deb 7c8ae6035a4d7776317f9423df0f025f0164bf59 55130 postgresql_9.6+178_all.deb Checksums-Sha256: 5052c7ce014defc9dc59dbe0b6f93270599fb0bc1c4809f0b6e72901764b0b20 2344 postgresql-common_178.dsc e17a245bce2b96a76b61c91913239f55afcd61f77a6feb76fa419e5e108ce57b 200272 postgresql-common_178.tar.xz 973ffe7853772fda5bc3ef4f7938f0b0f1d808630266544a3dfb88f1410ffd0c 55220 postgresql-all_9.6+178_all.deb 7034927b821407bd752b3a1a7e55125819377396a2f3b3615fc386c6d7652626 78280 postgresql-client-common_178_all.deb 65452dc2d8360b80f73f6d7c63e9a26a929b268e9426c46da1fa991a21a44803 55140 postgresql-client_9.6+178_all.deb 9a8bde83f58c299a25d5e14df0c2aaafa084b09a83ce3e5bdd7aa145d0280b3d 214938 postgresql-common_178_all.deb 950e94bbc2b79cd206a1d4828bb3f221b6b285d79349eb83bc4d8ab1ac485703 7072 postgresql-common_178_amd64.buildinfo b5e047044f4a7fba62bef4bcaac058b1931f456dd361212ce3890c38e374a868 55136 postgresql-contrib_9.6+178_all.deb 3d5b34af9250762680816942e23e5fcc576d532021c65296e0f6772f27dc1f12 55124 postgresql-doc_9.6+178_all.deb f66556559a653322b66d58a7c4c5223beed69dadc055f9a6f9314a12b1381e3b 62986 postgresql-server-dev-all_178_all.deb fe0ee7f437c5541927ac6002221bbc000b3dc6c7b3b731c36af93772a97aa6ab 55130 postgresql_9.6+178_all.deb Files: 6f98dc3f3e461c668cc7fd6f6fb9b471 2344 database optional postgresql-common_178.dsc a348b0b275d31586c404cf9426004b3c 200272 database optional postgresql-common_178.tar.xz 780c6ca452a4d72bd454484bc86c04a2 55220 database optional postgresql-all_9.6+178_all.deb 37e335e0ae34672d2d4e70b1cb85ec14 78280 database optional postgresql-client-common_178_all.deb 039b3d8cf5324df9caa9e58047b9155f 55140 database optional postgresql-client_9.6+178_all.deb c366f671ac6d19cec0e5a3c99715b601 214938 database optional postgresql-common_178_all.deb 41ac91652c8c524e5f636e9273674635 7072 database optional postgresql-common_178_amd64.buildinfo 66b7afbecfe2dee5a36935e1f072201f 55136 database optional postgresql-contrib_9.6+178_all.deb 78db8920a97a03be31522e6b72abaeaa 55124 doc optional postgresql-doc_9.6+178_all.deb 9c4d91c13a576b19b979e60aae808fd0 62986 database optional postgresql-server-dev-all_178_all.deb 4858fc4b06b7515f2a59d9ee1ce5e098 55130 database optional postgresql_9.6+178_all.deb -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlhZWN4ACgkQTFprqxLS p65zwQ//VoxtGGHmCqm2+LXflpC3mbP9jo2op5lV7vLYhVkLaPjQwLvgka0eEaBA /w9L0G+PstxS3y5BEFKAcybiVogFH2fz/BjNhtfAEVOJ+aqxLxWif2c4h3w1IyBK 53rI0wNe2sZzhaOMC0BJIjuuZTKWb9zdTu1FcS4iOAUGokwM5fGVjg02AFuENG6g sOBsHGX0PbXhGF1WYV87rY3Ee9BKEnOKThCj1OdAxphBSRvqiSsvwIqd/4n0oJAL peFYw42TsbeJRERujXr8Zu2/Uet9SdIJSfniH/1M1aaDCiSVkPHj2rbV80Va/xYD QyF0z0WyUZ4mS49MITX7ULsbTFdZx9X4bdX46bVQTWcSU4CQbJ3LaNPqcBQRgiH7 5ThbUxgKSJuBJfuUqvBqWIO5tsY4GbzycMLXOjIYOnno42HxNUDlRRuEMbV/AowB cnmpcBxsqZyzE5rPmMFqNv/cnso0OPOGvdb4WYk1tDmbCIRWdP9UF8iRgeI4Vt3e JbWxMLIxhllyh5s6PlcwswMPzb75aHFhdi2YR214KYLskqF4k8qccxez313jCw5H z0/BrXT3zJMoQrxcJnlpS9ICSN0orDhxo460hWTtZm1DrqXlPC2eGjND0kNilX4a lZ5hlJpV5DmUU3ZVkeWptWKDb2Rq1v2elNmvgNa2GKL0psMjVNg= =l/xJ -----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
