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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>, 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-28 22:04:11
Message-ID: 774c7cfe-43ea-03a6-1c88-31f51a39fd4a@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/28/20 2:39 PM, Andrus wrote:
> Hi!
>
> Postgres 12 database dump is created in Debian 10 using pg_dump .
>
> Trying to restore it in Windows 10  using
>
> pg_restore --clean --create --if-exists --dbname=postgres --jobs=8
> --no-password mydb.backup
>
> produces strange message
>
> pg_restore: WARNING:  could not determine encoding for locale
> "et_EE.UTF-8": codeset is "CPUTF-8"

In the Debian Postgres instance in psql what does \l show for the databases?

In the Windows 10 command prompt what does systeminfo show?

>
> How to fix this ?
>
> Debian and Windows computer have same settings:
>
> Latest Postgres 12  is used
> OS and database locales are  Estonian
> Database encoding is UTF-8
>
> Andrus.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2020-03-28 22:31:45 Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Previous Message Andrus 2020-03-28 21:39:49 could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore