X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4AA9A11F61E8 for ; Tue, 25 Apr 2006 17:56:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32423-03 for ; Tue, 25 Apr 2006 17:56:45 -0300 (ADT) X-Greylist: delayed 00:38:47.043935 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 616E311F61C2 for ; Tue, 25 Apr 2006 17:56:43 -0300 (ADT) Received: from mail.liquidcore.com (mail.liquidcore.com [70.151.60.104]) by svr4.postgresql.org (Postfix) with ESMTP id 66F145B1578 for ; Tue, 25 Apr 2006 20:17:54 +0000 (GMT) Received: (from root@localhost) by mail.liquidcore.com (8.13.1/8.13.1) id k3PKI3P1009473 for pgsql-admin@postgresql.org; Tue, 25 Apr 2006 15:18:03 -0500 Received: from [192.168.0.81] (ppasalalinux.nqadmin.com [192.168.0.81]) by mail.liquidcore.com (8.13.1/8.13.1) with ESMTP id k3PKI1w2009391 for ; Tue, 25 Apr 2006 15:18:01 -0500 Message-ID: <444E83EA.7030808@nqadmin.com> Date: Tue, 25 Apr 2006 15:17:46 -0500 From: Prasanth Reply-To: dbadmin@nqadmin.com User-Agent: Thunderbird 1.5 (X11/20060313) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Invalid UTF8 & Large Objects Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-scanner: Scanned for malicious content X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/270 X-Sequence-Number: 21439 Hi, We recently migrated from 7.4.7 to 8.1.3. I did a pg_dumpall & then pg_restore and it went fine. Today I realized that the backups I am creating can't be used to reload my database. I use pg_dump -Fc to dump the database as I have Large Objects in the database. (I used to use pg_dump -b -Fc in 7.4.7 seems like the -b option is taken out in 8.1.3 so I assume they are included automatically) I get the error "ERROR: invalid UTF-8 byte sequence detected........." Did research online and fund out that it is because of invalid characters in the database so started trying out the solution mentioned in the posts that is by using iconv. But then my problem is I have to do a text dump to use iconv in which case I will loose the large objects. I tried using the iconv on the dump generated using the -Fc option and then when I try to restore that I am getting the following error pg_restore: [archiver] entry ID 0 out of range -- perhaps a corrupt TOC Any help will be appreciated. Thanks, -Prasanth.