Because win10 supported character set name change, if direct upgrade will lead to postgresql database startup errors, suggest using the wrong character set,
The solution is:
Modifying the character set parameters before upgrade Win10
1. Log in all columns in the database manually modify pg_database 'Chinese (Simplified) _People "' s Republic of China. 936 "to" Chinese (Simplified) _People "' s Republic of China. 936
'2. Modify the postgresql. Conf file all lines' Chinese (Simplified) _People "' s Republic of China. 936" to "Chinese (Simplified) _People" 's Republic of China. 936
'
The modified database in Windows 7 and Windows (including Windows 2008 R2) under 10 can be normal use,
If you have already upgraded Windows 10 after installing Windows 7 virtual machine to mount the original database to modify

CodePudding user response:

Thank you for the original poster to share

CodePudding user response:

Should be changed to "Chinese (Simplified) _China. 936
'The patch is equivalent to delete PRO