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

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving a large DB (> 500GB) to another DB with different locale
Date: 2016-01-12 21:20:18
Message-ID: VisenaEmail.1d.e65b634233c316f0.15237b45704@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Saulo Merlo 2016-01-12 21:28:33 Re: Slow Query - PostgreSQL 9.2
Previous Message Adrian Klaver 2016-01-12 20:57:07 Re: plv8 binaries for PostgreSQL 9.5 on Windows