Your message dated Sun, 11 Dec 2005 15:50:55 +0100
with message-id <[EMAIL PROTECTED]>
and subject line postgresql/settings/encoding says UNICODE, but reality says
JOHAB
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 6 Apr 2004 12:14:40 +0000
>From [EMAIL PROTECTED] Tue Apr 06 05:14:40 2004
Return-path: <[EMAIL PROTECTED]>
Received: from maxwell.derobert.net (Maxwell.local) [207.188.193.82]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1BApTT-00063M-00; Tue, 06 Apr 2004 05:14:40 -0700
Received: from bohr.local ([2001:470:1f00:595:2a0:c9ff:feee:b4cb]
helo=bohr.home)
by Maxwell.local with esmtp (Exim 3.35 #1 (Debian))
id 1BApTT-00088F-00; Tue, 06 Apr 2004 08:14:39 -0400
Received: from anthony by bohr.home with local (Exim 4.30)
id 1BApTS-0008AY-Oa; Tue, 06 Apr 2004 08:14:38 -0400
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Anthony DeRobertis <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: postgresql/settings/encoding says UNICODE, but reality says JOHAB
X-Mailer: reportbug 2.56
Date: Tue, 06 Apr 2004 08:14:38 -0400
Message-Id: <[EMAIL PROTECTED]>
Sender: Anthony DeRobertis <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-7.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
X-CrossAssassin-Scores: 1
Package: postgresql
Version: 7.4.2-1
Severity: important
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
As you can see from the debconf answers below, the default encoding
should be UNICODE. However:
[EMAIL PROTECTED]:anthony$ psql -l
List of databases
Name | Owner | Encoding
- --------------+----------+----------
anthony | anthony | UNICODE
invoicer | anthony | JOHAB
itbc | anthony | JOHAB
packetwretch | anthony | UNICODE
soda | anthony | UNICODE
syslog | anthony | UNICODE
template0 | postgres | JOHAB
template1 | postgres | JOHAB
I think itbc was created with the previous postgres version in testing
(7.3? the version before the latest initdb). invoicer was created with
this version.
(The upgrade from 7.3 to 7.4 might of been done with
'/usr/lib/postgresql/bin/postgresql-dump -t /tmp/db.out3 -dcivlp
/var/lib/postgres/data/../data.save'
not sure. It had to be done by hand... but you already know that bug.)
Anyway, I think I can only fix the default encoding with initdb, right?
UGH.
- -- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (500, 'testing'), (102, 'unstable'), (101, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.4.22-bohr
Locale: LANG=en_US, LC_CTYPE=en_US
Versions of packages postgresql depends on:
ii adduser 3.51 Add and remove users and groups
ii debconf [debconf 1.4.16 Debian configuration management sy
ii debianutils 2.8 Miscellaneous utilities specific t
ii libc6 2.3.2.ds1-11 GNU C Library: Shared libraries an
ii libcomerr2 1.35-4 The Common Error Description libra
ii libkrb53 1.3.2-2 MIT Kerberos runtime libraries
ii libpam0g 0.76-16 Pluggable Authentication Modules l
ii libperl5.8 5.8.3-3 Shared Perl library.
ii libpq3 7.4.2-1 Shared library libpq.so.3 for Post
ii libreadline4 4.3-10 GNU readline and history libraries
ii libssl0.9.7 0.9.7d-1 SSL shared libraries
ii mailx 1:8.1.2-0.20031014cvs-1 A simple mail user agent
ii postgresql-clien 7.4.2-1 Front-end programs for PostgreSQL
ii procps 1:3.2.0-1 The /proc file system utilities
ii python2.3 2.3.3-6 An interactive high-level object-o
ii zlib1g 1:1.2.1-5 compression library - runtime
- -- debconf information:
* postgresql/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: European
postgresql/convert-postmaster.init: true
* postgresql/upgrade/policy: true
postgresql/enable_lang: true
postgresql/contains_POSTGRESHOME: true
postgresql/very_old_version_warning: true
* postgresql/upgrade/dump_location: /var/lib/postgres
* postgresql/convert-pg_hba.conf: true
* postgresql/initdb/location: /var/lib/postgres/data
* postgresql/settings/locale: C
postgresql/peer-to-ident: true
postgresql/missing_conf: true
* postgresql/purge_data_too: false
* postgresql/settings/encoding: UNICODE
* postgresql/settings/date_style: ISO
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAcp8u+z+IwlXqWf4RAl09AJ93hLeGK83/jS5bWSg9dzvlx6TM+ACdHxcs
y2qylam9joGs4XSExlgHxTo=
=rspR
-----END PGP SIGNATURE-----
---------------------------------------
Received: (at 242386-done) by bugs.debian.org; 11 Dec 2005 14:51:28 +0000
>From [EMAIL PROTECTED] Sun Dec 11 06:51:26 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de ([213.9.79.162])
by spohr.debian.org with esmtp (Exim 4.50)
id 1ElSXt-0003Dj-PQ
for [EMAIL PROTECTED]; Sun, 11 Dec 2005 06:51:26 -0800
Received: from localhost.localdomain (unknown [195.227.105.180])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
(Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified
OK))
by box79162.elkhouse.de (Postfix) with ESMTP id 489B285
for <[EMAIL PROTECTED]>; Sun, 11 Dec 2005 15:50:51 +0100 (CET)
Received: by localhost.localdomain (Postfix, from userid 1000)
id DA6CD2ED3; Sun, 11 Dec 2005 15:50:55 +0100 (CET)
Date: Sun, 11 Dec 2005 15:50:55 +0100
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: postgresql/settings/encoding says UNICODE, but reality says JOHAB
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="Q0rSlbzrZN6k9QnT"
Content-Disposition: inline
User-Agent: Mutt/1.5.11
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-4.4 required=4.0 tests=BAYES_00,HAS_PACKAGE,
RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_SBLXBL,RCVD_IN_SBLXBL_CBL,
RCVD_IN_SORBS,RCVD_IN_SORBS_WEB autolearn=no
version=2.60-bugs.debian.org_2005_01_02
--Q0rSlbzrZN6k9QnT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Package: postgresql-common
Version: 1
Hi Anthony!
This bug is open since ages, and it did not happen for anybody else (I
did a fair number of woody->sarge unicode database upgrades myself).
Also, sid has a completely different upgrade system which should avoid
this kind of problems entirely. Therefore I close this bug in
etch/sid.
I'm pretty convinced that it does not affect a woody->sarge upgrade
either, but I just leave the bug open in Sarge. Can you reproduce this
bug somehow? If so, we could try to push something into sarge-updates,
otherwise I'd just close the bug in sarge, too.
Is that fine with you?
Thanks,
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
In a world without walls and fences, who needs Windows and Gates?
--Q0rSlbzrZN6k9QnT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
iD8DBQFDnDzPDecnbV4Fd/IRAlfFAKDFZ2rxMk20YjfMgke+tJmju++NCQCggHng
LTqRgm1t2fT/6NXYQiywKyQ=
=74Zt
-----END PGP SIGNATURE-----
--Q0rSlbzrZN6k9QnT--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
