PostgreSQL install failure
Hello.
I upgraded a good old Potato server to Woody. Before that I have
made backups of important data, especially PostgreSQL ones, using
pg_dumpall, of course.
During the upgrade (`apt-get dist-upgrade'), the postgresql package
installation fails, with an error concerning pg_encoding. The log file
(script) is attached below.
May anyone help ?
Thanks in advance.
Script started on Thu Aug 8 17:30:41 2002
olan:~# apt-get install postgresql
Reading Package Lists... Done
Building Dependency Tree... Done
Sorry, postgresql is already the newest version.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 packages not fully installed or removed.
Need to get 0B of archives. After unpacking 0B will be used.
Setting up postgresql (7.2.1-2) ...
PostgreSQL databases can be created with any one of a number of
different character encodings. Please choose the default encoding, which
will be used for all newly-created databases in the absence of a specific
encoding specification. The choices are:
SQL_ASCII ASCII
EUC_JP Japanese EUC
EUC_CN Chinese EUC
EUC_KR Korean EUC
EUC_TW Taiwan EUC
UNICODE Unicode(UTF-8)
MULE_INTERNAL Mule internal
LATIN1 ISO 8859-1 English and some European languages
LATIN2 ISO 8859-2 English and some European languages
LATIN3 ISO 8859-3 English and some European languages
LATIN4 ISO 8859-4 English and some European languages
LATIN5 ISO 8859-5 English and some European languages
LATIN6 ISO 8859-10 ECMA-144 Latin Alphabet No.6
LATIN7 ISO 8859-13 Latin Alphabet No.7
LATIN8 ISO 8859-14 Latin Alphabet No.8
LATIN9 ISO 8859-15 Latin Alphabet No.9
LATIN10 ISO 8859-16 ASRO SR 14111 Latin Alphabet No.10
ISO-8859-5 ECMA-113 Latin/Cyrillic
ISO-8859-6 ECMA-114 Latin/Arabic
ISO-8859-7 ECMA-118 Latin/Greek
ISO-8859-8 ECMA-121 Latin/Hebrew
KOI8 KOI8-R
WIN Windows CP1251
ALT Windows CP866
Enter default encoding (SQL_ASCII):
You need to specify the locale under which the postmaster will run.
(This mainly affects the sorting of text. Use of any locale but C
will reduce the efficiency of index access; however, it will also
force sorting by ASCII code rather than by national collating order.)
You have the following locales enabled in your system:
fr_FR fr_FR.utf8 fr_FR@euro
Select locale [C]:
Now installing the PostgreSQL database files in /var/lib/postgres/data
su - postgres -c cd /var/lib/postgres; . ./.profile; LANG=C initdb --encoding SQL_ASCII --pgdata /var/lib/postgres/data
/usr/lib/postgresql/bin/pg_encoding: relocation error: /usr/lib/postgresql/bin/pg_encoding: undefined symbol: pg_valid_server_encoding
initdb: pg_encoding failed
Perhaps you did not configure PostgreSQL for multibyte support or
the program was not successfully installed.
dpkg: error processing postgresql (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)
olan:~#
Script done on Thu Aug 8 17:31:07 2002
--
Nicolas
Reply to: