From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Moving a large DB (> 500GB) to another DB with different locale |
Date: | 2016-01-12 22:09:40 |
Message-ID: | VisenaEmail.21.1699c116dc67400b.15237e180d4@tc7-visena |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce <
pierce(at)hogranch(dot)com <mailto:pierce(at)hogranch(dot)com>>:
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
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
From | Date | Subject | |
---|---|---|---|
Next Message | Dorian Hoxha | 2016-01-12 22:14:19 | Re: Blocked updates and background writer performance |
Previous Message | John R Pierce | 2016-01-12 21:56:56 | Re: Moving a large DB (> 500GB) to another DB with different locale |