From: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
---|---|
To: | mark(dot)steben(at)drivedominion(dot)com |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: hot standby cascading replication |
Date: | 2018-11-06 04:41:42 |
Message-ID: | CAFpL5Vxp_dVmADT+2X5_x0UWOj97EpxTg4JDM+nQk5yCHy=Esw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
Yes, you will have to setup streaming replication from first hot standby to
the second and for cascading replication make sure that primary connection
info is properly set in second hot standby i.e. it should point to the
first standby.
Thanks and Regards,
Nikhil
On Mon, Oct 29, 2018 at 11:24 PM Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:
> Good morning,
> I am attempting to set up cascading replication on a hot standby setup.
> We are running postgres 9.4 on all servers. I can ship logs from the
> master to the first standby but cannot get logs to ship from the first
> standby to the second standby. I see the cascading replication in the
> streaming replication documentation. Do I need to set up streaming
> replication in order for this to work? I have sent my postgresql.conf file
> for the first standby as reference as well as the copy statement.
>
> Thank you
>
>
> --
> *Mark Steben*
> Database Administrator
> @utoRevenue <http://www.autorevenue.com/> | Autobase
> <http://www.autobase.net/>
> CRM division of Dominion Dealer Solutions
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
> www.drivedominion.com <http://www.autorevenue.com/>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>
>
>
>
> <https://www.drivedominion.com/transform-your-vision/>
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2018-11-06 07:28:49 | Re: hot standby cascading replication |
Previous Message | Rui DeSousa | 2018-11-05 16:59:58 | Re: |