From: Weiping <laser@qmail.zhengmai.net.cn>
To: pgsql-admin list <pgsql-admin@postgresql.org>
Subject: Re: large dumps won't restore
Date: Wed, 20 Oct 2004 23:19:25 +0800
Message-ID: <417681FD.7060402@qmail.zhengmai.net.cn> (raw)
In-Reply-To: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com>
References: <Pine.LNX.4.61.0410181113470.12648@leda.steelsun.com>
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
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: laser@qmail.zhengmai.net.cn
Subject: Re: large dumps won't restore
In-Reply-To: <417681FD.7060402@qmail.zhengmai.net.cn>
* 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