The DBA just has to execute the ALTER SEQUENCE command on all relevant sequences.
Additional, if we do not implement the forced matching of persistence mode, we should consider adding an "ALTER TABLE SET ALL SEQUENCES TO UNLOGGED" command for convenience. Or maybe make it a function - which would allow for SQL execution against a catalog lookup.