Package: postgresql-8.3
Version: 8.3.0-1
Severity: normal
Hi,
pg_upgradecluster from 8.1 to 8.3 failed with:
Upgrading database sgwebtest...
pg_restore: [archiver (db)] Error while INITIALIZING:
pg_restore: [archiver (db)] could not execute query: ERROR: conversion
between MULE_INTERNAL and UTF8 is not supported
Command was: --
-- PostgreSQL database dump
--
SET client_encoding = 'MULE_INTERNAL';
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1754; 1262 9509435 DATABASE
sgwebtest postgres
pg_restore: [archiver (db)] could not execute query: ERROR: encoding
MULE_INTERNAL does not match server's locale nb_NO.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
Command was:
CREATE DATABASE sgwebtest WITH TEMPLATE = template0 ENCODING =
'MULE_INTERNAL';
pg_restore: [archiver (db)] could not execute query: ERROR: database
"sgwebtest" does not exist
Command was: ALTER DATABASE sgwebtest OWNER TO postgres;
pg_restore: [archiver (db)] could not reconnect to database: FATAL: database
"sgwebtest" does not exist
Error during cluster dumping, removing new cluster
I don't really know how or why this happened (or what MULE_INTERNAL is),
but I couldn't find a good way of resolving it short of dropping the
database. Is this a regression from 8.1 somehow?
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.20.4
Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]