Re: Wals not recycling

2018-12-21 Thread Rijo Roy
Yes Ian, it worked..  Many Thanks,Rijo Roy On Friday, 21 December, 2018, 4:16:09 AM IST, Ian Lawrence Barwick wrote: 2018年12月20日(木) 21:58 Rijo Roy : > > Thanks sk for replying Ian.. I have one inactive replication slot in the > database. I suspected that could be the cause but was not

Re: Wals not recycling

2018-12-20 Thread Ian Lawrence Barwick
2018年12月20日(木) 21:58 Rijo Roy : > > Thanks sk for replying Ian.. I have one inactive replication slot in the > database. I suspected that could be the cause but was not sure of it. Could > you please tell me what I should be doing in this case. Can I drop the > replication slot since it is no mo

Re: Wals not recycling

2018-12-20 Thread Ian Lawrence Barwick
2018年12月20日(木) 21:18 Rijo Roy : > > Hi All, > > I am facing an issue with wal recycling in one of my Postgresql servers > running ina rhel box and the PG version is 10. The issue is that wal files > are not recycling at all. Please note that its a qa server and the load is > quite high on it. It

Wals not recycling

2018-12-20 Thread Rijo Roy
Hi All,  I am facing an issue with wal recycling in one of my Postgresql servers running ina rhel box and the PG version is 10. The issue is that wal files are not recycling at all. Please note that its a qa server and the load is quite high on it. It is running in no archive mode with fsync o