Re: Replication of Replication

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Edilmar Alves <edilmaralves(at)intersite(dot)com(dot)br>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Replication of Replication
Date: 2019-10-19 11:49:04
Message-ID: 20191019114904.e5tqkl4ta4x3x4yt@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 18, 2019 at 05:54:34PM -0400, Edilmar Alves wrote:
>I have 3 servers running CentOS+PG 11
>(postgresql11-server-11.5-1PGDG.rhel7.x86_64):
>- s1: main db + publication
>- s2: subscription of the main db
>all works fine until here...
>Now, I tried to config this:
>- s2: publication of the same db that was replicated from s1
>- s3: subscription of the db from s2
>When I did this, replication s1=>s2 stopped, and replication s2=>s3
>never worked.
>Is this not possible?

You'll have to share more details - error messages from the server log,
how you check that the replication stopped, etc.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2019-10-19 12:44:29 Re: releasing space
Previous Message Peter J. Holzer 2019-10-19 11:32:54 Re: Securing records using linux grou permissions