Your message dated Tue, 25 Oct 2005 18:03:48 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Bug#335676: postgresql: locale problems (guc.c)
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; 25 Oct 2005 11:27:04 +0000
>From [EMAIL PROTECTED] Tue Oct 25 04:27:04 2005
Return-path: <[EMAIL PROTECTED]>
Received: from host-76-193.teleware.fi (localhost.localdomain) [193.65.76.193]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1EUMxM-0008E1-00; Tue, 25 Oct 2005 04:27:04 -0700
Received: by localhost.localdomain (Postfix, from userid 1000)
id 3A9DDCB3E0; Tue, 25 Oct 2005 14:26:32 +0300 (EEST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Toni Heinonen <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: postgresql: locale problems (guc.c)
X-Mailer: reportbug 3.8
Date: Tue, 25 Oct 2005 14:26:32 +0300
Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
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=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Package: postgresql
Version: 7.4.7-6sarge1
Severity: grave
Justification: renders package unusable
I've tried switching locales, ISO-8859-1/-15/UTF-8 in both en_US and fi_FI.
Suddenly, postgresql won't start anymore. Logs say:
FATAL: XX000: failed to initialize lc_messages to ""
LOCATION: InitializeGUCOptions, guc.c:1867
I've used dpkg-reconfigure locales to reinstall/regenerate locales.
I've also used dpkg-reconfigure postgresql to try basic C locale,
fi_FI, etc. Nothing works. Can't get postgresql to start.
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-386
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages postgresql depends on:
ii adduser 3.63 Add and remove users and groups
ii debconf [debconf 1.4.30.13 Debian configuration management sy
ii debianutils 2.8.4 Miscellaneous utilities specific t
ii dpkg 1.10.28 Package maintenance system for Deb
ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an
ii libcomerr2 1.37-2sarge1 common error description library
ii libkrb53 1.3.6-2sarge2 MIT Kerberos runtime libraries
ii libpam0g 0.76-22 Pluggable Authentication Modules l
ii libperl5.8 5.8.4-8 Shared Perl library
ii libpq3 7.4.7-6sarge1 PostgreSQL C client library
ii libreadline4 4.3-11 GNU readline and history libraries
ii libssl0.9.7 0.9.7e-3 SSL shared libraries
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii postgresql-clien 7.4.7-6sarge1 front-end programs for PostgreSQL
ii procps 1:3.2.1-2 The /proc file system utilities
ii python2.3 2.3.5-3sarge1 An interactive high-level object-o
ii ucf 1.17 Update Configuration File: preserv
ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime
-- debconf information:
* postgresql/initdb/location: /var/lib/postgres/data
* postgresql/purge_data_too: true
postgresql/upgrade/preserve_location: $PGDATA/..
* postgresql/settings/day_month_order: European
postgresql/very_old_version_warning: true
postgresql/upgrade/policy: true
postgresql/upgrade/dump_location: $PGDATA/..
* postgresql/settings/locale: C
postgresql/convert-pg_hba.conf: true
postgresql/enable_lang: true
---------------------------------------
Received: (at 335676-done) by bugs.debian.org; 25 Oct 2005 16:04:19 +0000
>From [EMAIL PROTECTED] Tue Oct 25 09:04:19 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de [213.9.79.162]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1EURHe-0001FZ-00; Tue, 25 Oct 2005 09:04:19 -0700
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 0882525FD1D
for <[EMAIL PROTECTED]>; Tue, 25 Oct 2005 18:03:48 +0200 (CEST)
Received: by localhost.localdomain (Postfix, from userid 1000)
id F27321F4F1; Tue, 25 Oct 2005 18:03:48 +0200 (CEST)
Date: Tue, 25 Oct 2005 18:03:48 +0200
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#335676: postgresql: locale problems (guc.c)
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="ZoaI/ZTpAVc4A5k6"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.5.9i
Delivered-To: [EMAIL PROTECTED]
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=-5.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER,
RCVD_IN_BL_SPAMCOP_NET autolearn=no
version=2.60-bugs.debian.org_2005_01_02
--ZoaI/ZTpAVc4A5k6
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi Toni!
Toni Heinonen [2005-10-25 17:37 +0300]:
> Sorry, but I already removed (with purge and rm -rf /var/lib/postgres)
> the packages postgresql and postgresql-contrib, added a bunch of
> locales, regenerated them, reinstalled and chose a UTF-8 locale this
> time. It started working.
OK, that's what I expected.
> However, I do believe dpkg-reconfigure postgresql gave me the option
> to choose a locale (and it showed the correct choices), yet didn't
> change the option in postgresql itself.
The problem is that you can't change the locale of a cluster, so the
debconf question should not be asked if a cluster already exists.
Silly bug, but too late to change for Sarge, and the new packages in
Sid/Etch do not have that problem in the first place.
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?
--ZoaI/ZTpAVc4A5k6
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFDXldkDecnbV4Fd/IRAlwCAKD+ObvfzHi5+rUAa8hQLCWm/byLjgCgtIK3
3QeuTPHb8R3Kp/tY4LzX+UI=
=5nxY
-----END PGP SIGNATURE-----
--ZoaI/ZTpAVc4A5k6--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
