PostgreSQL Cascade streaming replication problem

Поиск
Список
Период
Сортировка
От Jakub Janeček
Тема PostgreSQL Cascade streaming replication problem
Дата
Msg-id CANmq+oYGfY22MVpKH5xi4Ru_mKUkh7prAeKc-ypc6Wg7wSn_Ag@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL Cascade streaming replication problem  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: unreliable behaviour of track_functions
Следующее
От: Steven Lembark
Дата:
Сообщение: Re: Please suggest the best suited unit test frame work forpostgresql database.