Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim Nasby
Subject Re: Moving a large DB (> 500GB) to another DB with different locale
Date
Msg-id 569694EC.3070406@BlueTreble.com
Whole thread Raw
In response to Re: 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
List pgsql-general
Tree view 
On 1/13/16 2:03 AM, Andreas Joseph Krogh wrote:
> Seems like pglogical migth be better?
> http://2ndquadrant.com/en/resources/pglogical/
> It's available for 9.4 also.

It would certainly be faster. It's also less tested than Slony is
though, as it's fairly new. If it was me, I'd use pg_logical.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Call postgres PL/Python stored function from another PL/Python block.
Next
From: Jim Nasby
Date:
Subject: Re: Changing varchar length by manipulating pg_attribute