Обсуждение:

Поиск
Список
Период
Сортировка

От
Pavel Demidov
Дата:
 Hello,

I hear that not recommended to set pg_resetwal with --wal-segsize for wal increasing. Are any more detailed information exists about it? What an effects could be? Does it possible change it due full offline?

Regards, Paul 

changing wal segsize with pg_resetwal

От
Alvaro Herrera
Дата:
On 2019-Aug-28, Pavel Demidov wrote:

> I hear that not recommended to set pg_resetwal with --wal-segsize for wal
> increasing. Are any more detailed information exists about it? What an
> effects could be? Does it possible change it due full offline?

The manual contains a warning about it:

       While pg_resetwal will set the WAL starting address
       beyond the latest existing WAL segment file, some segment size changes
       can cause previous WAL file names to be reused.  It is recommended to
       use -l together with this option to manually set the
       WAL starting address if WAL file name overlap will cause problems with
       your archiving strategy.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services