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

Поиск

Список

Период

Сортировка

От	Andreas Joseph Krogh
Тема	Re: Moving a large DB (> 500GB) to another DB with different locale
Дата	13 января 2016 г. 01:09:47
Msg-id	VisenaEmail.21.1699c116dc67400b.15237e180d4@tc7-visena обсуждение исходный текст
Ответ на	Re: Moving a large DB (> 500GB) to another DB with different locale (John R Pierce <pierce@hogranch.com>)
Ответы	Re: Moving a large DB (> 500GB) to another DB with different locale (Tom Lane <tgl@sss.pgh.pa.us>) Re: Moving a large DB (> 500GB) to another DB with different locale (John McKown <john.archie.mckown@gmail.com>)
Список	pgsql-general

Дерево обсуждения

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

www.visena.com