changing wal segsize with pg_resetwal - Mailing list pgsql-hackers

From Alvaro Herrera
Subject changing wal segsize with pg_resetwal
Date
Msg-id 20190905141852.GA24717@alvherre.pgsql
Whole thread Raw
In response to  (Pavel Demidov <zeller56@gmail.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Plug-in common/logging.h with vacuumlo and oid2name
Next
From: Amit Kapila
Date:
Subject: Re: SegFault on 9.6.14