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

Re: large dumps won't restore

From: Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn>
To: pgsql-admin list <pgsql-admin(at)postgresql(dot)org>
Subject: Re: large dumps won't restore
Date: 2004-10-20 15:19:25
Message-ID: 417681FD.7060402@qmail.zhengmai.net.cn (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Christian FowlerDate: 2004-10-20 15:45:17
Subject: Re: large dumps won't restore
Previous:From: Joe MaldonadoDate: 2004-10-20 14:17:10
Subject: REVOKE not working...

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