I can't find a way to force a WAL to switch other than just generating a lot of changes in the database. I'd like to be able to switch to the next WAL before a hot backup, and then switch out one after the hot backup. The docs indicate this is not possible.
Does anyone have a way to do this (other than creating a lot of data changes)?
Thanks
Jed.