Changing POSTGRES column datatype - should I drop indexes and then re-create?
The ALTER will automatically drop and rebuild the indexes (all indexes, not just on the column being altered).  There is no point in micromanaging the process yourself, unless you want to build the indexes CONCURRENTLY or something like that, so that that part can be done outside the maintenance window.