[Pkg-postgresql-public] Bug#848869: Error: could not create default cluster. Please create it manually with
On 2016-12-21 11:38, Christoph Berg wrote: > Control: tags -1 moreinfo > > Re: Darshaka Pathirana 2016-12-20 > <20161220110151.19348.48480.reportbug@invincible> >> Error: The locale requested by the environment is invalid. > >> Locale looks like this: >> >> % locale >> LANG=en_US.UTF-8 >> LANGUAGE=en_US:en > > on package installation (only), the locale used for pg_createcluster > (= initdb) is not determined by your environment (which "locale" looks > at), but by the system configuration in /etc/environment and > /etc/default/locale. > > Could you check what you have configured in these files? Hmm. The files look like this: % cat /etc/environment % cat /etc/default/locale # File generated by update-locale LANG=en_US.UTF-8 LANGUAGE=en_US:en Regards, - Darsha signature.asc Description: OpenPGP digital signature ___ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
[Pkg-postgresql-public] Bug#838812: marked as done (pg_upgradecluster skips databases owned by a role who is not a user)
Your message dated Wed, 21 Dec 2016 11:00:11 + with message-idand subject line Bug#614374: fixed in postgresql-common 178 has caused the Debian Bug report #614374, regarding pg_upgradecluster skips databases owned by a role who is not a user 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.) -- 614374: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=614374 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems --- Begin Message --- Package: postgresql-common Version: 173 Severity: critical When doing pg_upgradecluster, all databases owned by a role (a group of users) and not a user are silently skipped. Even worse, these databases are recreated EMPTY ! If you don't take a close look before dropping the old cluster, you'd better have a good backup. Problem probably comes from the query on line 438 : SELECT datname, datallowconn, pg_catalog.pg_encoding_to_char(encoding), usename FROM pg_database, pg_user WHERE datdba = usesysid This should rather be written : SELECT d.datname, datallowconn,pg_catalog.pg_encoding_to_char(encoding),pg_catalog.pg_get_userbyid(d.datdba) as usename FROM pg_catalog.pg_database d; I haven't used this fix to solve my problem. I was in a hurry so I gave all databases to postgres, did the pg_upgradecluster and gave back the databases to their respective owners afterwards. What makes me think this query is the good one is that the only correctly converted databases were the ones shown by this query (maybe there's another similar query in the script). --- 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 614...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg (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 Changed-By: Christoph Berg 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
[Pkg-postgresql-public] Bug#614374: marked as done (pg_upgradecluster fails when datdba is a role without login privilege)
Your message dated Wed, 21 Dec 2016 11:00:11 + with message-idand subject line Bug#614374: fixed in postgresql-common 178 has caused the Debian Bug report #614374, 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.) -- 614374: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=614374 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 ; 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 614...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg (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 Changed-By: Christoph Berg 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
[Pkg-postgresql-public] Bug#614374: marked as done (pg_upgradecluster fails when datdba is a role without login privilege)
Your message dated Wed, 21 Dec 2016 11:00:11 + with message-idand 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 ; 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 (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 Changed-By: Christoph Berg 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
[Pkg-postgresql-public] postgresql-common_178_amd64.changes ACCEPTED into unstable, unstable
Accepted: -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 MaintainersChanged-By: Christoph Berg 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
[Pkg-postgresql-public] Processed: Re: Bug#848869: Error: could not create default cluster. Please create it manually with
Processing control commands: > tags -1 moreinfo Bug #848869 [postgresql] Error: could not create default cluster. Please create it manually with Added tag(s) moreinfo. -- 848869: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=848869 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems ___ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
[Pkg-postgresql-public] Bug#848869: Error: could not create default cluster. Please create it manually with
Control: tags -1 moreinfo Re: Darshaka Pathirana 2016-12-20 <20161220110151.19348.48480.reportbug@invincible> > Error: The locale requested by the environment is invalid. > Locale looks like this: > > % locale > LANG=en_US.UTF-8 > LANGUAGE=en_US:en Hi, on package installation (only), the locale used for pg_createcluster (= initdb) is not determined by your environment (which "locale" looks at), but by the system configuration in /etc/environment and /etc/default/locale. Could you check what you have configured in these files? Christoph ___ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public