changing wal segsize with pg_resetwal

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема changing wal segsize with pg_resetwal
Дата
Msg-id 20190905141852.GA24717@alvherre.pgsql
обсуждение исходный текст
Ответ на  (Pavel Demidov <zeller56@gmail.com>)
Список pgsql-hackers
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



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Plug-in common/logging.h with vacuumlo and oid2name
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: SegFault on 9.6.14