changing wal segsize with pg_resetwal

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