NVDB restore fails - errors while pg_restore with invalid locale (4042225)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

NVDB restore fails - errors while pg_restore with invalid locale
Description

Restore of NVDB fails and reports "errors while pg_restore saying that "Chinese (Simplified)_People's Republic of China.936" is invalid locale"
Cause

In Windows 2008 Chinese locale is named as "Chinese (Simplified)_People's Republic of China.936" and in Windows 2012 it is named as "Chinese (Simplified)_China.936", hence the NVDB backup from Windows 2008 (Chinese Locale) fails to restore in Window 2012, due the mismatch of the Simplified Chinese locale differences in Windows OS.
Resolution
Resolution 1
To restore using the same Windows OS version (Chinese Locale) e.g NVDB backed in Windows 2008 (Chinese Locale) to be restored into another server of Windows 2008 (Chinese Locale)..so on.
Resolution 2
1. Restore NVDB on Windows 7 OS with regular process.
2. After NVDB restore, Stop netvault program mgr service.
3. goto pgadmin3 tool and perform following query below
------
update pg_database
set datcollate = 'Chinese (Simplified)_China.936' ,
datctype = 'Chinese (Simplified)_China.936'
where datname IN ('netvault_auditing','netvault_logs','netvault_scheduling','netvault_machines','netvault_mediamanagement');
Now try the NVDB restoration.
Additional Information

NVDB restore fails - errors while pg_restore with invalid locale

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title