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

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.