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

Hi!

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

#psql namm postgres
psql (12.2 (Debian 12.2-2.pgdg100+1))
Type "help" for help.

namm=# \l namm
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
------+------------+----------+-------------+-------------+---------------------------
namm | namm_owner | UTF8 | et_EE.UTF-8 | et_EE.UTF-8 | =Tc/namm_owner
+
| | | | |
namm_owner=CTc/namm_owner
(1 row)

>In the Windows 10 command prompt what does systeminfo show?

Host Name: SERVER2
OS Name: Microsoft Windows 10 Pro
OS Version: 10.0.18363 N/A Build 18363
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: Windows User
Registered Organization:
Product ID: 00330-70008-16217-AAOEM
Original Install Date: 05.09.2019, 9:16:41
System Boot Time: 28.03.2020, 11:05:23
System Manufacturer: Gigabyte Technology Co., Ltd.
System Model: Q270M-D3H
System Type: x64-based PC
Processor(s): 1 Processor(s) Installed.
[01]: Intel64 Family 6 Model 158 Stepping 9
GenuineIntel ~3601 Mhz
BIOS Version: American Megatrends Inc. F1, 09.01.2017
Windows Directory: C:\WINDOWS
System Directory: C:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume3
System Locale: et;Eesti
Input Locale: et;Eesti
Time Zone: (UTC+02:00) Helsingi, Kiiev, Riia, Sofia,
Tallinn, Vilnius
Total Physical Memory: 16 286 MB
Available Physical Memory: 12 032 MB
Virtual Memory: Max Size: 18 718 MB
Virtual Memory: Available: 14 867 MB
Virtual Memory: In Use: 3 851 MB
Page File Location(s): C:\pagefile.sys
Domain: WORKGROUP
Logon Server: \\SERVER2
Hotfix(s): 18 Hotfix(s) Installed.
[01]: KB4534132
[02]: KB4497165
[03]: KB4498523
[04]: KB4503308
[05]: KB4515383
[06]: KB4515530
[07]: KB4516115
[08]: KB4517245
[09]: KB4520390
[10]: KB4521863
[11]: KB4524244
[12]: KB4524569
[13]: KB4528759
[14]: KB4532441
[15]: KB4537759
[16]: KB4538674
[17]: KB4541338
[18]: KB4551762
Network Card(s): 2 NIC(s) Installed.
[01]: TAP-Windows Adapter V9
Connection Name: Ethernet 4
Status: Media disconnected
[02]: Intel(R) Ethernet Connection (2) I219-LM
Connection Name: Ethernet 3
DHCP Enabled: Yes
DHCP Server: 192.168.91.1
IP address(es)
[01]: 192.168.91.154
[02]: fe80::94d:b1c:3945:bc8a
[03]:
2001:7d0:4c83:4c80:257f:b077:e1f7:21e1
[04]: 2001:7d0:4c83:4c80:94d:b1c:3945:bc8a
Hyper-V Requirements: VM Monitor Mode Extensions: Yes
Virtualization Enabled In Firmware: Yes
Second Level Address Translation: Yes
Data Execution Prevention Available: Yes

Andrus.