Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore - Mailing list pgsql-general

From Andrus
Subject Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Date
Msg-id 1046C47572F54F1BA5A726A49BAC6F3C@dell2
Whole thread Raw
In response to Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: could not determine encoding for locale "et_EE.UTF-8": codeset is"CPUTF-8" in pg_restore
List pgsql-general
Hi!

>Generally speaking, locale names from Unix systems won't work at all on
>Windows.  You need to create the database manually with whatever seems
>to be the closest Windows locale match, and then restore its contents
>without using --create.

This is unattended script running in every night from .bat file.

How to replace pg_restore --create  option with   psql and/or createdb calls
and specify proper locale for them ?

Currently everthing has "Estonian_Estonia.1257"  locale in windows.
Which locale name should be specified in Windows instead of this?
Or maybe creating new template with proper encoding or changing template0 
encoding helps?

Andrus. 




pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Next
From: "Andrus"
Date:
Subject: Hot standby from Debian to Windows