Обсуждение:
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
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