På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce <pierce@xxxxxxxxxxxx>:
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
