Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore - Mailing list pgsql-admin

From Markus Bertheau
Subject Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore
Date
Msg-id 1057531698.2570.4.camel@saphir
Whole thread Raw
In response to Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error  ("Soeren Laursen" <sl@scrooge.dk>)
Responses Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error  ("Soeren Laursen" <sl@scrooge.dk>)
List pgsql-admin
В Пнд, 07.07.2003, в 00:01, Soeren Laursen пишет:
> Hi,
>
> I am not sure how and where I should use the \encoding latin1
>
> Something like,
>
> psql test01
> \encodinng latin1
> \q
>
> pg_restore .....

Ah. Load the backup in a non-unicode database, dump it using the text
format (i.e. not the custom format), put the encoding thing in front of
the file and load it into your unicode database.

--
Markus Bertheau.
Berlin, Berlin.
Germany.

pgsql-admin by date:

Previous
From: aromero@dia.uned.es
Date:
Subject: Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2
Next
From: Stephan Szabo
Date:
Subject: Re: Problem when migrating my BB.DD Postgresql 7.2.3 to