On Thu, 7 Jul 2016, 9:51 a.m. Patrick B, <patrickbakerbr@xxxxxxxxx> wrote:
On Thu, 7 Jul 2016, 9:20 a.m. Patrick B, <patrickbakerbr@xxxxxxxxx> wrote:Hi guys,I got two slaves using Postgresql 9.2.slave01 - Streaming replication from masterslave02 - nothing.. new serveris it possible to get slave02 replicating from slave01 (Cascade streaming replication) this can be done with streaming ?Yes, a cascaded standby can be setup with Streaming Replication in v9.2 and above.and also slave01 sending the wal_files to that new slave02?What exactly do you mean here by "sending the wal_files"??So it would be on slave01archive_mode = okarchive_command = ....This will have no effect on a standby server. archive_command will be neglectedThis is possible only in v9.5 onward when archive_mode is set to always.wal_level = hot_standbymax_wal_senders = 2wal_keep_segments = 128Is that right?If you want to set up archiving from slave01, checkout pg_receivexlog.It might be helpful as it does something similar to archiving but using streaming protocol (so I think it should work even in cascaded mode). But since it works using streaming protocol, max_wal_senders on slave01 will be 2(what you have set now) + 1 (for pg_reveivexlog)ok.. got a little confused now.
I thought I did my best to explain :)
the only way to archive the wal_files from a slave into another slave on PostgreSQL 9.2, is by using pg_reveivexlog?
Yes. Though I have never tried this myself but going by the theory, it should work.
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
