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

Hi!

>Not sure but:
>1) I was on Windows 7
>2) Using Postgres 11
>3) My Windows skills have atrophied, especially with the Windows command
>line.
>So was this the same for the database you originally posted about, it
>actually restored it just threw warnings?

Looks like it restored. I havent checked restored data.

>If so I misunderstood the situation and thought the database was not
>loading.

I tried

CREATE DATABASE redmine
WITH
ENCODING = 'UTF8'
LC_COLLATE = 'foo'
LC_CTYPE = 'bar' template template0

in Linux and in Windows using Postgres 12.2
In Linux it throws error

ERROR: invalid locale name: "foo"

In Windows it creates database and throws warning only.
Without template template0 clause it throws error in Windows also.

In Linux

CREATE DATABASE redmine WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United
States.1252';

also throws error

ERROR: invalid locale name: "English_United States.1252"

So it looks like pg_dump/pg_restore with --create works only from Linux to
Windows and does not work from Windows to Linux.

I expect that it should work from Windows to Linux also.

Andrus.