På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < [email protected] <mailto:[email protected]>>: On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: > 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?
nope, because the text data has to be converted to the new encoding, indexes rebuilt since the collation order is different, etc. I was pretty sure there wasn't, but had to ask before imposing downtime on our customers. Thanks. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
