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 22:48:19
Message-ID: 1057531698.2570.4.camel@saphir
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-07-06 23:35:15 Re: Problem when migrating my BB.DD Postgresql 7.2.3 to
Previous Message aromero 2003-07-06 22:20:35 Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2