Re: Moving a large DB (> 500GB) to another DB with different locale

From: John R Pierce <pierce(at)hogranch(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 21:56:56
Message-ID: 569576A8.5030002@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-01-12 22:09:40 Re: Moving a large DB (> 500GB) to another DB with different locale
Previous Message Joshua D. Drake 2016-01-12 21:37:51 Re: WIP: CoC V5