Re: Sv: WAL-dir filling up with wal_level = logical

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Sv: WAL-dir filling up with wal_level = logical
Дата
Msg-id 17147CD3-7FFC-40A0-B225-CD7BB83C7BC3@a-kretschmer.de
обсуждение исходный текст
Ответ на Sv: WAL-dir filling up with wal_level = logical  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: Sv: WAL-dir filling up with wal_level = logical  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general
On 3 August 2018 12:33:26 CEST, Andreas Joseph Krogh <andreas@visena.com> wrote:
>På fredag 03. august 2018 kl. 12:12:33, skrev Andreas Joseph Krogh <
>andreas@visena.com <mailto:andreas@visena.com>>:
>Version: PG-10.4
> 
>I don't (yet) have any replication-slots configured, and hence no
>standbys are
>subscribed, but I have wal_level = logical configured to be able to add
>
>subscribers later. I'm seeing that WAL-dir is filling up with WAL-files
>(now
>17GB and not declining), is this expected behaviour?
> 
>Thanks.
> 
>Hm, a co-worker noticed that we have max_wal_size = 16GB, that might be
>the
>reason:-)
> 

Yes ;-)


Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company


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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: WAL-dir filling up with wal_level = logical
Следующее
От: Dmitry Igrishin
Дата:
Сообщение: SQL Programming Assistant for PostgreSQL