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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Date: 2020-03-29 08:02:48
Message-ID: 1046C47572F54F1BA5A726A49BAC6F3C@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2020-03-29 12:35:39 Hot standby from Debian to Windows
Previous Message Andrus 2020-03-29 07:56:24 Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore