What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?
It gives you a chance to revoke connect from unwanted users before doing alter database ... allow connections

Also in all cases users with superuser permission are allowed to connect, so you can create an unconnectable database, then as superuser populate it and create constraints ans indices before making it publicly available.