Re: prevent WAL replication to fill filesystem

2021-09-07 Thread Jehan-Guillaume de Rorthais
Le 8 septembre 2021 06:07:15 GMT+02:00, Ninad Shah a écrit : >These suggestions are appropriate. However, if you are ready to lose your >replica to keep production running, there are a couple of methods. > >1) Set archive_command to "/bin/true" >2) rename .ready files in archive_status to .don

Re: prevent WAL replication to fill filesystem

2021-09-07 Thread Ninad Shah
; > have a old PG 9.6 with WAL replication. > > > for some reason the rsync was failed and the filesystem was filled by > > > pg_xlog files. > > > As result PG stops working. > > > > > > Is there a way to prevent WAL replication to fill filesystem by x

Re: prevent WAL replication to fill filesystem

2021-08-31 Thread Jehan-Guillaume de Rorthais
orking. > > > > Is there a way to prevent WAL replication to fill filesystem by xlog > > files in case of failure? No. You have to size your partition big enough to handle few days of normal WAL production, monitor the archiving success and react quickly to fix th

Re: prevent WAL replication to fill filesystem

2021-08-31 Thread Laurenz Albe
On Tue, 2021-08-31 at 10:36 +0200, basti wrote: >  have a old PG 9.6 with WAL replication. > for some reason the rsync was failed and the filesystem was filled by > pg_xlog files. > As result PG stops working. > > Is there a way to prevent WAL replication to fill filesystem

prevent WAL replication to fill filesystem

2021-08-31 Thread basti
Hello, I have a old PG 9.6 with WAL replication. for some reason the rsync was failed and the filesystem was filled by pg_xlog files. As result PG stops working. Is there a way to prevent WAL replication to fill filesystem by xlog files in case of failure? Best regards