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