Package: postgresql-common Version: 83 Severity: normal Hi,
I tried to run pg_upgradecluster, but I get locale-related errors:
------------------------------------------------------------
# pg_upgradecluster 8.2 main
Creating new cluster (configuration: /etc/postgresql/8.3/main, data:
/var/lib/postgresql/8.3/main)...
Moving configuration file /var/lib/postgresql/8.3/main/postgresql.conf to
/etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_hba.conf to
/etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_ident.conf to
/etc/postgresql/8.3/main...
Configuring postgresql.conf to use port 5433...
Disabling connections to the old cluster during upgrade...
Disabling connections to the new cluster during upgrade...
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Creating globals...
Fixing hardcoded library paths for stored procedures...
Upgrading database bibled...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1785; 1262 16945 DATABASE
bibled postgres
pg_restore: [archiver (db)] could not execute query: ERROR: encoding UTF8 does
not match server's locale [EMAIL PROTECTED]
DETAIL: The server's LC_CTYPE setting requires encoding LATIN9.
Command was:
CREATE DATABASE bibled WITH TEMPLATE = template0 ENCODING = 'UTF8';
pg_restore: [archiver (db)] could not execute query: ERROR: database "bibled"
does not exist
Command was: ALTER DATABASE bibled OWNER TO postgres;
pg_restore: [archiver (db)] could not reconnect to database: FATAL: database
"bibled" does not exist
Error during cluster dumping, removing new cluster
------------------------------------------------------------
It's not clear to me where the locale "[EMAIL PROTECTED]" comes from. The
locale settings in the shell where I run pg_updatedb are:
------------------------------------------------------------
# locale
LANG=
LC_CTYPE=fi_FI.UTF-8
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=
------------------------------------------------------------
In any case the data in the database requires UTF-8, and the old
database is in UTF-8 encoding. I also tried to set LANG=fi_FI.UTF-8
before running pg_upgradecluster, with no visible difference in the
result. I also tried restarting the old (8.2) server with
LANG=fi_FI.UTF-8 to no avail. The file
/etc/postgresql/8.2/main/environment has only comment lines.
Sami
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.23.12-sli (SMP w/4 CPU cores; PREEMPT)
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)
Shell: /bin/sh linked to /bin/bash
Versions of packages postgresql-common depends on:
ii adduser 3.105 add and remove users and groups
ii debconf [debconf-2.0] 1.5.18 Debian configuration management sy
ii lsb-base 3.1-24 Linux Standard Base 3.1 init scrip
ii postgresql-client-common 83 manager for multiple PostgreSQL cl
ii procps 1:3.2.7-5 /proc file system utilities
ii ssl-cert 1.0.14 Simple debconf wrapper for openssl
postgresql-common recommends no packages.
-- debconf information:
* postgresql-common/obsolete-major:
postgresql-common/untransitioned:
signature.asc
Description: Digital signature
