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
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 .done. Again, I personally do not recommend this, so consider this as a la

Re: prevent WAL replication to fill filesystem

2021-08-31 Thread Jehan-Guillaume de Rorthais
On Tue, 31 Aug 2021 10:53:45 +0200 Laurenz Albe wrote: > 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 wa

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 by xlog > files in case