Re: Changing locale to 1250

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: *ukasz Brodziak <lukasz(dot)brodziak(at)hotmail(dot)com>, "PostgreSQL" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Changing locale to 1250
Date: 2010-08-31 20:35:49
Message-ID: 4C7D21550200002500034EFA@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

*ukasz Brodziak<lukasz(dot)brodziak(at)hotmail(dot)com> wrote:

> The version in 8.4. I'm trying to copy the database from Windows
> to Linux. If it is of any importance the version of "Windows
> Postgres" is 8.2

Use pg_dump from your 8.4 machine. I would use the --encoding
switch when I ran pg_dump to get UTF-8 encoding in the dump file.
Make sure you initialize your new database with a character set
which supports all the characters from the old database.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Willy-Bas Loos 2010-09-01 10:35:58 Re: Confused by 'timing' results
Previous Message Scott Marlowe 2010-08-31 20:02:33 Re: Confused by 'timing' results