PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
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. H

Re: PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
GMT+02:00 Michael Paquier : > On Sun, Apr 01, 2018 at 06:26:51PM +0000, Jakub Janeček wrote: > > What did i do wrong? I need stop comulating WAL files and remove old WAL > > files, which are processed and are only "waiting".. > > Perhaps wal_keep_segments is set and yo

Re: PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
Hi everyone, problem is solved. There was a delay between setup (drop replication slot) and execution. Jakub 2018-04-03 4:43 GMT+02:00 Michael Paquier : > On Sun, Apr 01, 2018 at 06:26:51PM +0000, Jakub Janeček wrote: > > What did i do wrong? I need stop comulating WAL files and r