From: | "Manoj Agarwal" <ma(at)ockham(dot)be> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem while restoring a database from SQL_ASCII to UTF-8 |
Date: | 2012-06-06 11:30:20 |
Message-ID: | 000001cd43d7$c312c7f0$493857d0$@ockham.be |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a database in SQL_ASCII Encoding format from Postgresql-7.4.19. I
have migrated to Postgresql-8.4.9 and to UTF-8 and want to restore this
database in UTF-8 encoding. I am facing problem in restoring it as UTF-8.
I have 29 tables in the database, out of which it is unable to restore 3
tables. It gives the following error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 83; 0 40257 TABLE DATA
document postgres
pg_restore: [archiver (db)] COPY failed for table "document": ERROR:
invalid byte sequence for encoding "UTF8": 0xe92034
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY document, line 15
pg_restore: [archiver (db)] Error from TOC entry 88; 0 40271 TABLE DATA
attribute postgres
pg_restore: [archiver (db)] COPY failed for table "attribute": ERROR:
invalid byte sequence for encoding "UTF8": 0xe90931
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY attribute, line 909
pg_restore: [archiver (db)] Error from TOC entry 90; 0 40277 TABLE DATA
revision_state postgres
pg_restore: [archiver (db)] COPY failed for table "revision_state": ERROR:
invalid byte sequence for encoding "UTF8": 0xe9e96e
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY revision_state, line 363
I have checked these three tables and I found that these tables contain
special characters as values for some attributes for some records. I tried
to use the procedure mentioned in the following link, which didn't worked
for me:
http://archives.postgresql.org/pgsql-admin/2004-07/msg00206.php
I also have blobs in one table in this database, but I don't think/see any
issues with them. Is there a way to restore the database from SQL_ASCII to
UTF-8? Is there a way to restore the database as SQL_ASCII and then convert
the Encoding to UTF-8? What is the consistency level? Or are there chances
of getting garbage?
Kind Regards,
Manoj Agarwal
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-06-06 11:34:02 | Re: acessibility for tables |
Previous Message | Kraus Philipp | 2012-06-06 11:26:50 | Re: acessibility for tables |