Re: prevent WAL replication to fill filesystem - Mailing list pgsql-general

From Jehan-Guillaume de Rorthais
Subject Re: prevent WAL replication to fill filesystem
Date
Msg-id 80F8268C-59FD-4C83-8DFD-36281AD912B6@dalibo.com
Whole thread Raw
In response to Re: prevent WAL replication to fill filesystem  (Ninad Shah <nshah.postgres@gmail.com>)
List pgsql-general

Le 8 septembre 2021 06:07:15 GMT+02:00, Ninad Shah <nshah.postgres@gmail.com> 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 .done.

You do not need to rename files in archive_status, especially after setting /bin/true. The normal production, if
running,will soon enough clean everything, quickly. 

A good advice is to never do writes in pg_wal yoursef (mv, rm, edit, etc).



pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Is there any technical reason why "alter table .. set not null" can't use index?
Next
From: Alexander Kass
Date:
Subject: Re: No xmin in pg_database