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 |
