Re: [ADMIN] large dumps won't restore

[Weiping]

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 [EMAIL PROTECTED])