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.steben@xxxxxxxxxxxxxxxxx> 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 | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com
