This patch implements a new GUC parameter "permit_unlogged_tables" which allows admins to disable creation of unlogged tables or altering the existing tables to be unlogged.
I dislike the premise of this option. It doesn't seem like something that should be evaluated on a cluster/database scope.