[GENERAL] Moving a large DB (> 500GB) to another DB with different locale

[Andreas Joseph Krogh]

Hi all.
 
I'm moving a > 500GB DB to another server which is initdb'ed with a different 
locale (nb_NO.UTF-8 to get correct collation when ORDER BY).
Is there another option than pg_dump/restore for doing this?
 
Thanks.
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
 <https://www.visena.com>