X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 471FB329ECA for ; Wed, 20 Oct 2004 16:21:29 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09768-10 for ; Wed, 20 Oct 2004 15:21:27 +0000 (GMT) Received: from nat2.zhengmai.net.cn (unknown [202.99.6.61]) by svr1.postgresql.org (Postfix) with SMTP id 61385329E77 for ; Wed, 20 Oct 2004 16:21:24 +0100 (BST) Received: (qmail 79447 invoked by uid 89); 20 Oct 2004 15:45:57 -0000 Received: from unknown (HELO ?192.168.1.161?) (laser@qmail.zhengmai.net.cn@221.218.42.154) by 0 with SMTP; 20 Oct 2004 15:45:57 -0000 Message-ID: <417681FD.7060402@qmail.zhengmai.net.cn> Date: Wed, 20 Oct 2004 23:19:25 +0800 From: Weiping User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin list Subject: Re: large dumps won't restore References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL, RCVD_IN_RFCI X-Spam-Level: * X-Archive-Number: 200410/257 X-Sequence-Number: 15250 Christian Fowler wrote: > > I'm running a large database ( data dir is ~9gigs ) on Fedora Core 2 > with 7.4.5-PGDG rpm's > > When using the -Fc dump method + pg_restore, I get: > > -bash-2.05b$ pg_restore -Fc -d foo -L backup.list > /tmp/02\:43-postgresql_database-foo-backup > pg_restore: ERROR: invalid input syntax for type timestamp: "52.233334" > CONTEXT: COPY foo_data, line 42529, column mod_date: "52.233334" > pg_restore: [archiver (db)] error returned by PQendcopy > what's the column type before the column "mod_date"? is it's a text type? if so, then have you used any kind of encoding for your database? what's it? and what's your PGCLIENCODING setting? seems like a encoding problem I've ever met, but not sure. regards Laser