Your message dated Fri, 06 Jan 2017 23:32:12 +0000 with message-id <e1cpdzy-000248...@fasolo.debian.org> and subject line Bug#838812: fixed in postgresql-common 165+deb8u2 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: 165+deb8u2 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: Sun, 01 Jan 2017 18:48:30 +0100 Source: postgresql-common Binary: postgresql-common postgresql-client-common postgresql-server-dev-all postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: source all Version: 165+deb8u2 Distribution: jessie 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-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 Changes: postgresql-common (165+deb8u2) jessie; urgency=medium . * pg_upgradecluster: Properly upgrade databases with non-login role owners. (Closes: #614374, #838812) * 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! (CVE-2016-1255) * t/TestLib.pm: Cherry-pick program_ok() from master for use in t/020_create_sql_remove.t. Checksums-Sha1: cfb6627d1ebb48ee981d8e9f1b34fcd85d9aaf86 2304 postgresql-common_165+deb8u2.dsc 63faab67581dd0652b8ff6ca7c90c6555730b1ca 187112 postgresql-common_165+deb8u2.tar.xz ddd49fa31ddf33ae6618281f882c35865743fde3 73664 postgresql-client-common_165+deb8u2_all.deb 00501ffc0df08dbe62b85d03b70c376de63193ea 52232 postgresql-client_9.4+165+deb8u2_all.deb 0d7702f71fb32027616b18cd76a025bfdf4471d1 199814 postgresql-common_165+deb8u2_all.deb 2bb0c515ee3cdfecfa948ccf8a1a9ffc0d43b059 6940 postgresql-common_165+deb8u2_amd64.buildinfo ea72f5b1c1ca6604e41cb4d5a16f797fe2fb93f0 52228 postgresql-contrib_9.4+165+deb8u2_all.deb 8b6fcc65152665126cf7a266d431ce1c556b603b 52226 postgresql-doc_9.4+165+deb8u2_all.deb 5db35c81fdb570a7680339c7c9af47ab46e40771 59302 postgresql-server-dev-all_165+deb8u2_all.deb b3281356703772b8860c5b4d1c1e9fc78d500227 52224 postgresql_9.4+165+deb8u2_all.deb Checksums-Sha256: 4914d035a4404d12283cbfc5fb16660a63d056f26b82103aa1206b2aabf23ffd 2304 postgresql-common_165+deb8u2.dsc 5381c7da23c6a2473bbeb252bbf9100d146316cffe4631684294128273acce2a 187112 postgresql-common_165+deb8u2.tar.xz 0968584a7a1bb0a1346bb16598a485333a80ff5a6a653b2ef9de4b762b245e2e 73664 postgresql-client-common_165+deb8u2_all.deb c10a2f58cc8eb904fd04a5ddad714223ea658a80e732e42c7cf1771592e6007a 52232 postgresql-client_9.4+165+deb8u2_all.deb 600c76e69e6fe2fda6cd066dcbe80e93b8b08bf033054995f164c388cdce8479 199814 postgresql-common_165+deb8u2_all.deb b2667fd04b49037660fd250ea41a9f78430cfc1ba29d1dc93f58788926e93bb4 6940 postgresql-common_165+deb8u2_amd64.buildinfo 1ec87cced57994665113ceb97fd8a7a73c01dc4f650fc29bbc5cd4431dda8276 52228 postgresql-contrib_9.4+165+deb8u2_all.deb 8af4770a0db281c76ffefb876bc9c9291467c18fa321b59dbbbb5cc876d3c022 52226 postgresql-doc_9.4+165+deb8u2_all.deb b41c1a586e98741221e25f2fcba77a01d8076e07a7965677ff266f5989a74958 59302 postgresql-server-dev-all_165+deb8u2_all.deb 63145e1c8afddd223e90394be68196179944ff5e0fbe070ff5d4e85b1b256247 52224 postgresql_9.4+165+deb8u2_all.deb Files: 7cacf60d44d1e129dbec5b0eb36112a3 2304 database optional postgresql-common_165+deb8u2.dsc 3169a5274be285449701500e4d21f989 187112 database optional postgresql-common_165+deb8u2.tar.xz 104f77d60719a1bfc835cdcf9b7664f4 73664 database optional postgresql-client-common_165+deb8u2_all.deb dabdf1c7a5fbf3a474eaeb0c6ff50e2b 52232 database optional postgresql-client_9.4+165+deb8u2_all.deb 2def07998a7a86d94de21cbef5b0e2ac 199814 database optional postgresql-common_165+deb8u2_all.deb caf285096127dc9a2c819ed0f895fc22 6940 database optional postgresql-common_165+deb8u2_amd64.buildinfo 63c28b9111b6c1ed651f5caef314182f 52228 database optional postgresql-contrib_9.4+165+deb8u2_all.deb 9e8f65f6b7050a1ef869862967ccbb1d 52226 doc optional postgresql-doc_9.4+165+deb8u2_all.deb ccff6c12d65b8b1d1e72ae4f23ff6926 59302 database optional postgresql-server-dev-all_165+deb8u2_all.deb 0354a20411674a5dd8be87551dd117a1 52224 database optional postgresql_9.4+165+deb8u2_all.deb -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlhuzBoACgkQTFprqxLS p656/RAArMYEF/+KtJ+7WX87YimRAVeKdmx3Jmcj7Qg6pcCM+LhAgBjyCpx2kvBO pzaQpau/mzgUC+69n78OKOoeaTS5OAyVcC+/9PoUNt9hSPy+nmdx+tVFk3F2bdLx pRt+vu6Ig+NYwfjkBKnHVgpCRrqpNPU/B47qTDDt/o2/Rrvk/fIMTDJZBWSYO7SR 4oxAJdpXC2Z6HcoYScv4nIcqSKiIYbPZTXQRhd13NdqIRdTgvn2j/NDKb0/SQ9YF wiJlxTsJrGrCzceLNxejtp/PBwFe++cKckVOSGlSJigtUTeLq774tes0hv/hdCcC JLtnBiwaX9RcJ18cwQ5Te1um6N/xNh+7H1oM55lffjitqpoRoglfleW8RIm99xHr 1WKryzNzVvzQ78694paAuTqq2Gn2qgbe0JtIqkg5e3xxn4Hp2e9q3yvas+O/mcWZ Qy+XOh9dxq1gegzwolcrgXxLe6ZfFxsC0VxaseDpNuLMELsaYWgCAM/sUtSTM1Fs LenK4i2f5j2MYWHCRyFp0fsy/nud/4V+OI/98N9X/4wWWfVx7IlEYnPYeUGt/AQ/ fUYpcYErP2AJsJE+XQljO0SchmMvYNpuDeT4gKeOZEQsHQ6syy9j7AdMsJLjBqdm DFyzr3SFfsaB6WmtrJbyhagyIT/F3r899YGr80t20lbAUTD1Zwk= =DXdk -----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
