You cannot set database-wise case-insensitive collation. Since case insensitiveness is nondeterministic comparisons.
CREATE DATABASE ma page pg 15 quote
There is currently no option to use a database locale with nondeterministic comparisons (see CREATE COLLATION for an explanation). If this is needed, then per-column collations would need to be used.