From: Christian Fowler <spider@viovio.com>
To: pgsql-admin list <pgsql-admin@postgresql.org>
Subject: large dumps won't restore
Date: Mon, 18 Oct 2004 11:45:13 -0400 (EDT)
Message-ID: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com> (raw)
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
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: spider@viovio.com
Subject: Re: large dumps won't restore
In-Reply-To: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.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