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 7585432A084 for ; Wed, 20 Oct 2004 16:45:27 +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 59703-05 for ; Wed, 20 Oct 2004 15:45:25 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 40048329DB3 for ; Wed, 20 Oct 2004 16:45:24 +0100 (BST) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id i9KFjHA8027411; Wed, 20 Oct 2004 11:45:17 -0400 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id i9KFjHni027408; Wed, 20 Oct 2004 11:45:17 -0400 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Wed, 20 Oct 2004 11:45:17 -0400 (EDT) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: Weiping Cc: pgsql-admin list Subject: Re: large dumps won't restore In-Reply-To: <417681FD.7060402@qmail.zhengmai.net.cn> Message-ID: References: <417681FD.7060402@qmail.zhengmai.net.cn> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/259 X-Sequence-Number: 15252 Joshua - well, i ran a --inserts dump as you suggested, and it died upteen millions (and many hours) in at: INSERT 59235383 1 invalid command \033', cannot allocate memory for output buffer Weiping, db=# \encoding UNICODE the last four columns in the table are: full_name_nd | character varying(200) | mod_date | timestamp without time zone | pc_char | character varying(4) | dim_char | character varying(16) | [root@host root]# env |grep LANG LANG=en_US.UTF-8 On Wed, 20 Oct 2004, Weiping wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > [ \ / [ >X< Christian Fowler | spider AT viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org