Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: soeren(dot)laursen(at)scrooge(dot)dk
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore
Date: 2003-07-06 21:13:33
Message-ID: 1057526012.2570.1.camel@saphir
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

В Вск, 06.07.2003, в 19:57, Soeren Laursen пишет:

> pg_restore: ERROR: copy: line 1, Invalid UNICODE character sequence
> found (0xf87665)

> No need to say that the new database is created with UNICODE
> encoding?!

use

\encoding latin1

once when you import the data. That'll convert the data from latin1 to
utf-8 encoded unicode on the fly. Then again I don't know what charset
denmark uses usually, probably some other latin variant.

--
Markus Bertheau.
Berlin, Berlin.
Germany.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Soeren Laursen 2003-07-06 22:01:04 Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error
Previous Message Soeren Laursen 2003-07-06 17:57:12 Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error