Search Postgresql Archives

PostgreSQL Cascade streaming replication problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux