On 7/6/2016 6:52 PM, Sameer Kumar wrote:
Yes. Though I have never tried this myself but going by the theory, it should work.
a slave doesn't generate wal_files at all.
if your master is keeping a wal_archive, slaves, including cascaded streaming slaves, can all use that same archive as their wal source, these are only used for catchup when streaming is interrupted.
But the slave can send wal to a wal_receiver and I think pg_receivexlog will be nothing less than a wal_receiver. I will hold back from any further comments unless I have tried it.
But a good question here is, why do you want to do that? Why Archive from standby to cascaded standby? If it is only to catchup, the archives from master are good enough
--
john r pierce, recycling bits in santa cruz
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.