Re: prevent WAL replication to fill filesystem

Поиск
Список
Период
Сортировка
От Jehan-Guillaume de Rorthais
Тема Re: prevent WAL replication to fill filesystem
Дата
Msg-id 80F8268C-59FD-4C83-8DFD-36281AD912B6@dalibo.com
обсуждение исходный текст
Ответ на Re: prevent WAL replication to fill filesystem  (Ninad Shah <nshah.postgres@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Is there any technical reason why "alter table .. set not null" can't use index?
Следующее
От: Alexander Kass
Дата:
Сообщение: Re: No xmin in pg_database