From: | Matthew Tice <mjtice(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Logical Replication - Rep Manager |
Date: | 2020-08-27 16:57:54 |
Message-ID: | CA+taBv_06K5=7PDqk3qsvkHsc4UfyvWf=W7X26qAgLu8=HA+ZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Are you using a replication_slot?
If so, as I understand, replication_slots are not replicated to the standby
database. They would need to be re-created upon standby promotion.
On Wed, Aug 26, 2020 at 6:23 AM Anjul Tyagi <anjul(at)ibosstech-us(dot)com> wrote:
> Samed,
>
> i tied the same, unfortunate it did not work. after promoting we have seen
> error log, replication slot is not exist. I tried to start the slot but did
> not work.
>
>
>
>
>
> Regards,
>
> Anjul *TYAGI*
>
>
>
> *ü* *Go Green*
>
> ------ Original Message ------
> From: "Samed YILDIRIM" <samed(at)reddoc(dot)net>
> To: "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com>; "pgsql-admin" <
> pgsql-admin(at)postgresql(dot)org>
> Sent: 8/26/2020 12:20:29 PM
> Subject: Re: Logical Replication - Rep Manager
>
> Hi Anjul,
>
> I haven't tested, but specifying multiple host in connection string may
> solve your issue.
>
> For example;
> create subscription sub1
> connection 'host=192.168.100.25,192.168.100.50,192.168.56.20
> dbname=prod_db user=logical_rep password=123'
> publication pub_for_report;
>
> https://www.postgresql.org/docs/12/libpq-connect.html#LIBPQ-MULTIPLE-HOSTS
>
> Best regards.
> Samed YILDIRIM
>
> 25.08.2020, 20:34, "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com>:
>
> Hi Team,
>
> We are planning to implement the Rep Manager in our environment to manage
> the replication. While reading the documentation we found out that if
> primary goes down. We can promote one of the standby server and make it
> primary. However we have one reporting server that we are replicating
> specific table data via logical replication. While doing testing in lower
> environment, we noticed when we primary goes down and we promote the
> standby server, our replication also breaks. Do we have any option and
> suggestion to handle the logical replication in case of failure.
>
> Thanks in advance.
>
>
>
>
>
> Regards,
>
> Anjul *TYAGI*
>
>
>
> *ü Go Green*
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Naveen Kumar | 2020-08-28 02:58:33 | Re: Logical Replication - Rep Manager |
Previous Message | Schlaffer, Sharon | 2020-08-27 16:07:16 | insert vs. copy in pgAdmin |