Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving a large DB (> 500GB) to another DB with different locale - Mailing list pgsql-general

From John R Pierce
Subject Re: Moving a large DB (> 500GB) to another DB with different locale
Date
Msg-id 569576A8.5030002@hogranch.com
Whole thread Raw
In response to Moving a large DB (> 500GB) to another DB with different locale  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: Moving a large DB (> 500GB) to another DB with different locale  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: WIP: CoC V5
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Moving a large DB (> 500GB) to another DB with different locale