Re: pglogical cascading replication (chaining replication)

From: Nick Babadzhanian <nb(at)cobra(dot)ru>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: pglogical cascading replication (chaining replication)
Date: 2016-07-19 09:51:04
Message-ID: 127854752.37280.1468921864724.JavaMail.zimbra@cobra.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The solution was found thanks to Petr Jelinek from 2ndQ.

> Cascading wasn't much of a priority so far.
> Currently you have to create the origin manually using pg_replication_origin_create().
> I plan to make this work seamlessly in the future release.

So whats needed to be done is:

on p2:

select * from pg_replication_origin;

will show all origins on p2, find the origin for p1;

on p3:

select pg_replication_origin_create('[origin name]');

Discussed here:

https://github.com/2ndQuadrant/pglogical/issues/23

Please ignore previous message;

Regards,
Nick.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2016-07-19 09:55:09 Re: MediaWiki + PostgreSQL is not ready for production?
Previous Message Nick Babadzhanian 2016-07-19 09:46:48 Re: pglogical cascading replication (chaining replication)