PostgreSQL Cascade streaming replication problem - Mailing list pgsql-general

From Jakub Janeček
Subject PostgreSQL Cascade streaming replication problem
Date
Msg-id CANmq+oYGfY22MVpKH5xi4Ru_mKUkh7prAeKc-ypc6Wg7wSn_Ag@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Cascade streaming replication problem
List pgsql-general
Hi everyone,

i have one master and two slaves - cascading replication. Master -> Slave1 -> Slave2

Slave2 crashed two days ago. Problem is on Slave1, where are comulating WAL files. Archive mode is turn off. There is about 6.000 WAL Files, but in folder archive_status are files with .done name.

How can I remove WAL files, which are "waiting" for Slave2? I changed configration on Slave1 (i commented this options "wal level = hot_standby" and "max_wal_senders = 1"). But without effect. 

What did i do wrong? I need stop comulating WAL files and remove old WAL files, which are processed and are only "waiting"..

Thank you for your tips.
Regards,

Jakub

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: unreliable behaviour of track_functions
Next
From: Steven Lembark
Date:
Subject: Re: Please suggest the best suited unit test frame work forpostgresql database.