On Tue, Nov 14, 2017 at 8:38 AM, Bossart, Nathan <bossa...@amazon.com> wrote: > Fair points. If we added an option to pg_resetwal, should we bother > trying to handle the WAL filename overlap that Jeremy mentioned? The > -l option gives us the ability to set the WAL starting address > manually, but it might not be terribly clear to end users that this is > something to watch out for.
After running an upgrade the previous WAL segments become useless, and that's the same when changing a segment size. Even if you take care of having the pg_resetwal-ed cluster using a segment name ahead of what the previous cluster is using, you still run after the risk of having other nodes with the previous segment size overwrite the WAL segments of the new size. In short, that's only a matter of being careful with your archive locations. -- Michael