Re: prevent WAL replication to fill filesystem

Поиск
Список
Период
Сортировка
От Jehan-Guillaume de Rorthais
Тема Re: prevent WAL replication to fill filesystem
Дата
Msg-id 20210831113752.2be1ed44@firost
обсуждение исходный текст
Ответ на Re: prevent WAL replication to fill filesystem  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: prevent WAL replication to fill filesystem  (Ninad Shah <nshah.postgres@gmail.com>)
Список pgsql-general
On Tue, 31 Aug 2021 10:53:45 +0200
Laurenz Albe <laurenz.albe@cybertec.at> 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 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 things
when it fails.

> Upgrade to v13 and set "max_slot_wal_keep_size".

How this would prevent the failure if $OP doesn't (want to) use slots ? He
speaks about rsync, so it might be purely archiving error, not streaming.

Regards,



В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: prevent WAL replication to fill filesystem
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Can't locate Ora2Pg.pm while executing export_schema.sh