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

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Moving a large DB (> 500GB) to another DB with different locale
Дата
Msg-id VisenaEmail.1d.e65b634233c316f0.15237b45704@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  (Vick Khera <vivek@khera.org>)
Список pgsql-general
Hi all.
 
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?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: plv8 binaries for PostgreSQL 9.5 on Windows
Следующее
От: Saulo Merlo
Дата:
Сообщение: Re: Slow Query - PostgreSQL 9.2