Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)

From: Gordon Luk <gordon(at)gforce(dot)ods(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)
Date: 2002-05-15 08:27:06
Message-ID: 3CE21BDA.1090308@gforce.ods.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

Hi all,

Problem as my letter subject, my upgrade procedure also just follow the
simple.

1. compile 7.2.1 with multi-byte...with encode..
2. install ...
3. createdb -E EUC_TW mydatabase
4. psql mydatabase < dump_backup_from_my_old_database.txt

it return following error...

------------------------>8---------------------------
.
.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'student_pk' for table 'student'
CREATE
ERROR: copy: line 2, Invalid EUC_TW character sequence found (0xae65)
lost synchronization with server, resetting connection
ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xb27a)
lost synchronization with server, resetting connection
ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xaa4d)
lost synchronization with server, resetting connection
ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xb371)
lost synchronization with server, resetting connection
ERROR: copy: line 2, Invalid EUC_TW character sequence found (0xbc42)
lost synchronization with server, resetting connection
ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xa470)
lost synchronization with server, resetting connection
ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xa656)
lost synchronization with server, resetting connection
ERROR: copy: line 3, Invalid EUC_TW character sequence found (0xad50)
lost synchronization with server, resetting connection
CREATE
CREATE
.
.
------------------------>8---------------------------

Please help.

Gordon

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message BELLIARD Francois - FT.BD/FTRD/DRHG/RSCL 2002-05-15 09:05:40 Re: problem in module Pg with Apache, Perl and SSL
Previous Message David Stanaway 2002-05-15 06:50:31 Re: ALTER TABLE for field modify... [Fwd: Re: [SQL] CHECK

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-05-15 09:51:01 Re: insert blocking?
Previous Message Haug Bürger 2002-05-15 06:39:54 Re: insert blocking?