Aging Users

select
	'ALTER ROLE ' || u.usename || ' VALID UNTIL ''<new valid date>''; -- last valid until ' || u.valuntil 
from
	pg_user u
where
	u.valuntil <> 'infinity'
	and u.valuntil >= '<old valid date>'