PostgreSQL Cascade streaming replication problem

From: Jakub Janeček <jakub(dot)janecek(at)comgate(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL Cascade streaming replication problem
Date: 2018-04-01 18:26:51
Message-ID: CANmq+oYGfY22MVpKH5xi4Ru_mKUkh7prAeKc-ypc6Wg7wSn_Ag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-04-01 20:01:07 Re: [PATCH] Logical decoding of TRUNCATE
Previous Message Adrian Klaver 2018-04-01 16:29:16 Re: unreliable behaviour of track_functions