The default for PostgreSQL is that roles are created per cluster not per database. I would like to have per database roles. I could have sworn I once read about a way to set that up but now I can't find any reference to it. I think it was an
initdb option or a
createcluster.conf setting or similar but I've read the
initdb documentation thoroughly and can't find anything on this.
Is there a way to set per database roles in PostgreSQL?