Re: initdb --encoding=LATIN1 fails on Windows

From: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: initdb --encoding=LATIN1 fails on Windows
Date: 2009-07-16 20:07:59
Message-ID: 4A5F889F.70805@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Abraham, Danny wrote:

> The same command worked fine on PG 8.2.4.
> Now, using 8.3.7, we are forced into WIN1252.

In 8.2 on Windows code page 28591 has been used. If you use this as
locale initdb should give you LATIN1.

Something like this should work for you as well:
initdb --locale=German_Germany.28591 -W -A md5 -D
"C:\Programme\PostgreSQL\8.3\data"

Good luck,

Peter

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Kempter 2009-07-16 20:14:52 convert an Insert Into... select from... to use COPY ?
Previous Message Joshua Daniel Franklin 2009-07-16 19:18:16 how to REINDEX pg_database on

Browse pgsql-general by date

  From Date Subject
Next Message Relyea, Mike 2009-07-16 20:09:01 Re: Error in insert statement
Previous Message bricklen 2009-07-16 20:05:10 Re: Error in insert statement