Home > mailing lists

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

From	Andreas Joseph Krogh
Subject	Moving a large DB (> 500GB) to another DB with different locale
Date	January 13, 2016 00:20:25
Msg-id	VisenaEmail.1d.e65b634233c316f0.15237b45704@tc7-visena Whole thread Raw
Responses	Re: Moving a large DB (> 500GB) to another DB with different locale Re: Moving a large DB (> 500GB) to another DB with different locale
List	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

From: Adrian Klaver
Date: 12 January 2016, 23:58:06
Subject: Re: plv8 binaries for PostgreSQL 9.5 on Windows

From: Saulo Merlo
Date: 13 January 2016, 00:28:42
Subject: Re: Slow Query - PostgreSQL 9.2