From: Joshua D. Drake <jd@commandprompt.com>
To: Christian Fowler <spider@viovio.com>
Cc: pgsql-admin list <pgsql-admin@postgresql.org>
Subject: Re: large dumps won't restore
Date: Mon, 18 Oct 2004 08:53:21 -0700
Message-ID: <4173E6F1.8060003@commandprompt.com> (raw)
In-Reply-To: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com>
References: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com>
> 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?
>
Well you aren't going to like this but I see two solutions:
1. Cut out the rows listed and reimport after the copy completes.
2. Perform the pg_dump as inserts which will make the restore very slow
but should complete correctly.
Is the dump and restore happening on the same platform?
Sincerely,
Joshua D. Drake
>
>
> [ \ /
> [ >X< Christian Fowler | spider@viovio.com
> [ / \ http://www.viovio.com | http://www.tikipro.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, spider@viovio.com
Subject: Re: large dumps won't restore
In-Reply-To: <4173E6F1.8060003@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox