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 E36A532A084 for ; Mon, 18 Oct 2004 16:45:28 +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 18158-10 for ; Mon, 18 Oct 2004 15:45:24 +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 CBA0B32A0DD for ; Mon, 18 Oct 2004 16:45:20 +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 i9IFjDV4014839 for ; Mon, 18 Oct 2004 11:45:13 -0400 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id i9IFjDoN014836 for ; Mon, 18 Oct 2004 11:45:13 -0400 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Mon, 18 Oct 2004 11:45:13 -0400 (EDT) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: pgsql-admin list Subject: large dumps won't restore Message-ID: 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/214 X-Sequence-Number: 15207 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 When using pg_dump + psql: I get a similar error. In one table that has about 5.4 million rows, the dump has several incomplete rows in the large block of copy data. It seems to attempt to fill the copy with data from the *next* line. ERROR: invalid input syntax for type timestamp: "4" CONTEXT: COPY foo_data, line 169371, column mod_date: "4" going to 169371 lines after the start of the copy, indeed there is a short row (by two), and two fields in on the *next* line is indeed a "4" Both seem to have the same problem - incomplete COPY row data. any ideas? [ \ / [ >X< Christian Fowler | spider@viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org