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
> 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
what's it? and what's your PGCLIENCODING setting?
seems like a encoding problem I've ever met, but not sure.
In response to
pgsql-admin by date
|Next:||From: Christian Fowler||Date: 2004-10-20 15:45:17|
|Subject: Re: large dumps won't restore|
|Previous:||From: Joe Maldonado||Date: 2004-10-20 14:17:10|
|Subject: REVOKE not working...|