Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Re: Moving a large DB (> 500GB) to another DB with different locale
Date
Msg-id VisenaEmail.6c.b1846f5003c1a3d1.1523cb69554@tc7-visena
Whole thread Raw
In response to Re: Moving a large DB (> 500GB) to another DB with different locale  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Moving a large DB (> 500GB) to another DB with different locale  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view
På onsdag 13. januar 2016 kl. 19:18:20, skrev Jim Nasby <Jim.Nasby@BlueTreble.com>:
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
 
Where can I find more info about how to use and configure pg_logical to replicate a 9.4 DB to 9.5?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Synchronous replication
Next
From: Thomas Munro
Date:
Subject: Re: Synchronous replication