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-9567