So the authorization problem is a result of other bug (https://bugs.launchpad.net/postgresql-charm/+bug/1831865), but it looks like manually setting the 'cluster.initial-check' flag solves the problem.
So the authorization problem is a result of other bug (https:/ /bugs.launchpad .net/postgresql -charm/ +bug/1831865), but it looks like manually setting the 'cluster. initial- check' flag solves the problem.