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

pg_dump and restore problem (7.0.? to 7.2)

From: Paul Warner <pwarner(at)dibinst(dot)mit(dot)edu>
To: pgsql-admin(at)postgresql(dot)org, dtsai(at)mit(dot)edu, ashrafi(at)mit(dot)edu
Subject: pg_dump and restore problem (7.0.? to 7.2)
Date: 2002-06-19 14:58:25
Message-ID: 3D109C11.A073CFB6@dibinst.mit.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Hello again,

I have some additional information that points to an
encoding problem.  I pulled the COPY sql from the dump
file for the table that didn't get inserted properly
and tried to run just that section (with psql -f).  I
got this error:

 psql -f bibent_data.sql HRS
psql:bibent_data.sql:1: ERROR:  copy: line 15, Invalid
UNICODE character sequence found (0xc876)
psql:bibent_data.sql:1: lost synchronization with
server, resetting connection

I'm running on FreeBSD 4.5.  Is there a way I need to
recode the file before running it?

Thanks,
Paul Warner

Paul Warner wrote:

> Hello,
>
> I've looked for this in the books and archives and
> haven't been able to find an answer.
>
> I did a pg_dump on an older postgres database (I
> believe it's 7.0.something), and restored to 7.2.1
> with multibyte capability.  The old db is not
> multibyte.  What's happened is that there are a
> significant number of rows in the dump file that are
> not getting loaded into the new database. The tables
> are getting there, but not the data.
>
> I notice that there are triggers added in 7.2 that
> don't appear in the earlier version (as in: Triggers:
> RI_ConstraintTrigger_1663276).  I don't know if this
> is related, but it is true that all the 952 messages
> related to a certain topic didn't make it into one
> table.
>
> This strikes me as a version issue related to
> integrity constraints, but could it be related to the
> change to multibyte?
>
> I'm working on FreeBSD 4.5, with aolserver and openacs
> 3.2.4.
>
> Thanks very much for your help!
>
> Paul Warner
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org



In response to

pgsql-admin by date

Next:From: Michael P. DobmeierDate: 2002-06-19 15:01:54
Subject: Some questions regarding authentication (via pg_hba.conf password pwfile)
Previous:From: Paul WarnerDate: 2002-06-19 14:55:03
Subject: pg_dump and restore problem (7.0.? to 7.2) more info

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