I would install 14.7 on your Windows box (multiversioning /is/ supported, at
least on Linux; probably Windows too), making sure that it uses the
en_US.utf_8 locale (or the closest Windows analog). *Then* I'd try the same
migration on the Windows box.
After all development boxes should run the
Thank you for the reply.
The pg version is 14.7 (Azure DB)
Locale :-
LC_COLLATE & LC_CTYPE : en_US.utf_8
Local postgreSQL:- Version:- (15.1-1-windows-x64-binaries)
LC_COLLATE & LC_CTYPE:-
English_United States.1252
Please let me know if any other information is needed.
Thanks & Best Regards,
S
On 8/3/23 21:22, Sai Teja wrote:
Hi team,
I am trying to migrate the data from db2 to postgreSQL in which one of the
table is having XML data.
For one of the file (13MB) I'm facing an error with
ERROR: invalid XML content
Detail: line 418061: internal error: Huge input lookup
nested exception
Hi team,
I am trying to migrate the data from db2 to postgreSQL in which one of the
table is having XML data.
For one of the file (13MB) I'm facing an error with
ERROR: invalid XML content
Detail: line 418061: internal error: Huge input lookup
nested exception is org.postgresql.util.PSQLException