Home > mailing lists

Does pglogical support cascade replication? - Mailing list pgsql-general

From	xujian
Subject	Does pglogical support cascade replication?
Date	February 23, 2016 16:29:37
Msg-id	BAY181-W418E9491E964FC04460C69A1A40@phx.gbl Whole thread Raw
List	pgsql-general

Hello,

I want to use pglogical to setup cascade replication, however, by researching it, I find different answer.

Q. Does pglogical support cascaded replication?

Subscribers can be configured as publishers as well thus cascaded replication can be achieved by forwarding/chaining (again no failover though).

Where will pglogical go next?

cascading logical replication, complex replication topologies

cascading is something that's still WIP.

I also tested 3 nodes cascade replication, node1->node2-node3

I got error on node3:

ERROR: cache lookup failed for replication origin 'xxxxxxxxxxx'

'xxxxxxxxxxx' is the replication slot name of node1

who knows if pglogical support cascade replication? thanks

James

From: Adrian Klaver
Date: 23 February 2016, 16:21:41
Subject: Re: sha256 certificate "unknown message digest algorithm"

From: Frazer McLean
Date: 23 February 2016, 16:53:51
Subject: Re: sha256 certificate "unknown message digest algorithm"