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

["Andrus" <kobruleht2@xxxxxx>]

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.