Skip site navigation (1) Skip section navigation (2)

large dumps won't restore

From: Christian Fowler <spider(at)viovio(dot)com>
To: pgsql-admin list <pgsql-admin(at)postgresql(dot)org>
Subject: large dumps won't restore
Date: 2004-10-18 15:45:13
Message-ID: Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)viovio(dot)com
[ / \   http://www.viovio.com | http://www.tikipro.org

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2004-10-18 15:53:21
Subject: Re: large dumps won't restore
Previous:From: Bruce MomjianDate: 2004-10-18 04:08:21
Subject: Re: Longest name for table/column/key/index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group