Re: pglogical cascading replication (chaining replication) - Mailing list pgsql-general

From Nick Babadzhanian
Subject Re: pglogical cascading replication (chaining replication)
Date
Msg-id 127854752.37280.1468921864724.JavaMail.zimbra@cobra.ru
Whole thread Raw
In response to Re: pglogical cascading replication (chaining replication)  (Nick Babadzhanian <nb@cobra.ru>)
List 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.


pgsql-general by date:

Previous
From: Nick Babadzhanian
Date:
Subject: Re: pglogical cascading replication (chaining replication)
Next
From: Achilleas Mantzios
Date:
Subject: Re: MediaWiki + PostgreSQL is not ready for production?