Re: 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: Re: Moving a large DB (> 500GB) to another DB with different locale
Date: 2016-01-15 12:02:41
Message-ID: VisenaEmail.8c.5b5120e7a812cf2.1524520528e@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby <
Jim(dot)Nasby(at)BlueTreble(dot)com <mailto:Jim(dot)Nasby(at)BlueTreble(dot)com>>:
On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote:
> Where can I find more info about how to use and configure pg_logical to
> replicate a 9.4 DB to 9.5?

http://2ndquadrant.com/en/resources/pglogical/
 
Thanks, I found detailed instructions in
/usr/share/doc/postgresql-9.5-pglogical/README.md.gz
Any chance of putting in online?
 
I see that wal_level = 'logical', and that is a problem for us as we already
use wal_level = 'hot_standby' on this installation as it replicates to another
server.
 
Is it possible to use pglogical together with hot_standby
streaming-replication?
 
Thank.
 
-- 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>

 

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shulgin, Oleksandr 2016-01-15 13:33:24 Re: Moving a large DB (> 500GB) to another DB with different locale
Previous Message Sylvain MARECHAL 2016-01-15 08:54:47 Re: [BDR] Best practice to automatically abort a DDL operation when one node is down