Your message dated Fri, 23 Sep 2016 11:24:51 +0000
with message-id <[email protected]>
and subject line Bug#790507: fixed in postgresql-common 176
has caused the Debian Bug report #790507,
regarding pg_createcluster should default to UTF8 clusters, not SQL_ASCII
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 [email protected]
immediately.)
--
790507: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=790507
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-common
Version: 165
Summary: pg_createcluster defaults to creating databases in SQL_ASCII.
It should use UTF-8, C locale instead.
What currently happens:
If locale is not configured before installation of PostgreSQL (i.e.
/etc/default/locale is missing), pg_createcluster creates a new database
cluster in SQL_ASCII encoding. This includes the initial creation of
the "main" cluster on installation.
What should happen instead:
The cluster should be created in encoding UTF8 with "C" locale.
SQL_ASCII clusters should only be created if the user creates them
manually using -e SQL_ASCII. This means that if installation can't
sort out the locale issues, a data directory should not be created.
Why this is a problem:
SQL_ASCII is not a real encoding; it just stores whatever string bytes
are handed to it, including completely invalid character codes. This
means that, if a user gets a SQL_ASCII database which they don't expect,
not only can the database store garbage which will cause application
issues, but it also becomes very hard for the user to move the data to a
real encoding because manual cleanup of all strings is required.
SQL_ASCII is only still supported by PostgreSQL for legacy reasons.
To be completely clear: SQL_ASCII "encoding" in a database is a trap,
and causes data corruption and other issues for users down the line. We
should not be creating SQL_ASCII databases by default; they should only
happen if users specifically request them (using -e).
Ubuntu 12.04, 14.04 and Debian Jessie do not create /etc/default/locale
by default on headless server installs (or container-based installs) in
my testing. This results in all users defaulting to SQL_ASCII.
Technical details:
AFAIK, this issue exists on all versions of pg_createcluster. I tested
Ubuntu 14.04 and 12.04 and Debian Jessie. Ubuntu was tested with the
PGDG packages; Jessie, with the official Debian packages.
"initdb --encoding UTF8 --locale C" works as expected on a system with
no /etc/default/locale, because locale=C always works. pg_createcluster
-e UTF8 also does the right thing.
I've looked over the code for pg_createcluster and for
maintscripts-functions, and I can't figure out where encoding is getting
set to SQL_ASCII.
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 176
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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <[email protected]> (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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 23 Sep 2016 12:32:16 +0200
Source: postgresql-common
Binary: postgresql-common postgresql-client-common postgresql-server-dev-all
postgresql postgresql-client postgresql-doc postgresql-contrib
Architecture: source all
Version: 176
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers
<[email protected]>
Changed-By: Christoph Berg <[email protected]>
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: 790507 791556 808353 823209 830228
Changes:
postgresql-common (176) unstable; urgency=medium
.
* Team upload.
* Bump default PostgreSQL server version to 9.6.
* Use C.UTF-8 instead of C when the initial main cluster is created and no
locale is configured explicitly as system default. (Closes: #790507)
* Support "NN" major version numbers, next version will be PostgreSQL 10.
* debian/postgresql-common.templates: Properly mark not-to-be-translated
shell code-only chunk as such using flag:translate. Thanks to Rhonda for
the pointer! (See: #820756, #832282)
* testsuite: Run with umask 077 only by default.
* t/025_logging.t: Fix tests when grep thinks syslog is a binary file.
* t/031_errors_disk_full.t: Raise tmpfs size to account for larger cluster
footprint observed on ppc64el.
* t/032_ssl_key_permissions.t: Skip tests on 9.0 and earlier.
* pg_createcluster, t/025_logging.t: Skip logging_collector for 8.2.
* Ship /etc/postgresql-common/supported_versions even in non-backport
packages. (Closes: #808353)
* pg_createcluster: Error out if provided log file is a directory.
(Closes: #791556)
* pg_upgradecluster: Set dynamic_shared_memory_type from the new
postgresql.conf instead of defaulting to mmap. (Closes: #823209)
* pg_upgradecluster: Use data checksums in the new cluster if the old uses
them. (Closes: #830228)
Checksums-Sha1:
5183b5c47a36a89aed272e516d90376e7ad67f89 2232 postgresql-common_176.dsc
7ecb4bbca21e3609353fdcbd250d6fd9328277e3 200216 postgresql-common_176.tar.xz
142ed85cfd9c215c6e0b89d7cdbb75e74e9c70a7 77868
postgresql-client-common_176_all.deb
14c77c5dd17fd9ba6a1ea0d00b9065d8d711b00e 54666
postgresql-client_9.6+176_all.deb
a1dcc949a90672d2d0d6dc0226841055bb0b4bb1 214336 postgresql-common_176_all.deb
2d3f845356d39dfef301891f57b83d92606c2c62 54662
postgresql-contrib_9.6+176_all.deb
85dfced4426e1c80c8a49398dbba7ca8620f0045 54654 postgresql-doc_9.6+176_all.deb
ec0b32a7e1fa199fec6718a5f9ec6ffc48bf0801 62608
postgresql-server-dev-all_176_all.deb
b923cb15cac162abcc46435f23d0b6556417f387 54656 postgresql_9.6+176_all.deb
Checksums-Sha256:
a66c3933bca909f22a147ccb71d11865990d44155c028322b302e2395a3f9279 2232
postgresql-common_176.dsc
dadb0dd68029a4e6d276ae9ff281779f973430eb53bc6a14b3749ec24ccb6547 200216
postgresql-common_176.tar.xz
bc2168b46efeb3f59407eec1083a32e73d28ee0dbb55101dfe3cc87ff3fe945b 77868
postgresql-client-common_176_all.deb
76bc116ededa7fdb4b9531b1a0005c11a873362c07d1c58b2f1faa2b196d9e44 54666
postgresql-client_9.6+176_all.deb
c829bb6de1e84761f87fa3c170a2a81053dab03c8fee19bf6c5fa1c510d8235d 214336
postgresql-common_176_all.deb
fce733ed38ed71e1a434ca4a97207813a58d12c3081f61e81dbf1bb26c4bceee 54662
postgresql-contrib_9.6+176_all.deb
2c780d46f9f951cbb12be3af3442e2bac0a7a117c53d117a02bc5ebee3bc8673 54654
postgresql-doc_9.6+176_all.deb
9fa61f8aa7d3446aff9e7bfd0d72a113af08fc99c534e31a52a7d100487decb8 62608
postgresql-server-dev-all_176_all.deb
053e3fd23c31e0428b9ad53652b184fc9c54255493baa9b91d7c9a1733fc3b2b 54656
postgresql_9.6+176_all.deb
Files:
d8ab3b4d353dbebad3528c0625a82bf2 2232 database optional
postgresql-common_176.dsc
9cc58233c372516839887727556d715d 200216 database optional
postgresql-common_176.tar.xz
46eae73f6ae24e89fea1246a2b164c21 77868 database optional
postgresql-client-common_176_all.deb
be09da069a7e91a268e92c7d5e73de3b 54666 database optional
postgresql-client_9.6+176_all.deb
a5eb968e65aec5e999d3e84d2f0ccc61 214336 database optional
postgresql-common_176_all.deb
c8c0bb3895394617bf679aba6e75353e 54662 database optional
postgresql-contrib_9.6+176_all.deb
9b1a943a303badf694dde9a8475efb6a 54654 doc optional
postgresql-doc_9.6+176_all.deb
a1dd9532c797fc222417192e6ae87e18 62608 database optional
postgresql-server-dev-all_176_all.deb
9e88f102038aaab2e4140b7690a9817a 54656 database optional
postgresql_9.6+176_all.deb
-----BEGIN PGP SIGNATURE-----
iQIcBAEBCAAGBQJX5QdOAAoJEExaa6sS0qeuGFMP/jOP330dSw98YDOYgRLCF1eY
PHirK/W2MmonfXBKPVlhQ7rcXXTrSAeTIgHUpVmXD4rKlPBktWIIOEDj5VMvjasw
Ymn2xSNvvVGxdoGEuLwiIifAwNNg6L7e2OFfuB/bk14l06qpoCdF4u6DNX1cm3++
M/Mk3beIgL8Ijn8c5Utp8EMvrw5NbJFodLj782iOLl89/LlsQaU7pTTVQufTib22
W+IJywdygscuxAnAoQlvGBaoElsVZWw9XFpKXiotF3Pnqy1svp6bF78r6XygfnKE
aMkyAyo3OZi0YWoCThAKXmDOHCfsVy1xIQfORHtLxRQbTRLY1QuwOytheJAYwBF3
r5Z7cKltJ4eLjHXGAuc/vp2j6Om/gpr7T1lq95wiAL7YyqqlNRKxwRsjBaycbQ5O
578mlMVlj/AJEBFBH2I+bkcnzIq04C4HC1B+84V/NlT8xZLBTlioTuINiMgbZrd0
YXblIdJYS7sUkjjbRRzFBtiMFhlGoCNGXFv1HLajKFWV0xiBdajDgpttlPTSXNCZ
n4ViNc++roPYOo7Ensv5ze9f/bKniTQq2pclyJJvKXwcyA4fGquZTJIppx0Gkqip
nGpXyyu1AzNuK9Tc8SNAMvJGYLkrrwq/dZJBFAs1YYGrurCs790SQXljoB4oOaoB
adT6AjAFscSCo2fsDriC
=ATp8
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
