Make sure default access is overridden.

I was unable to access my VM from the host without an SSH tunnel. This pull request makes sure the `main` attributes are not overwritten by the `postgresql` attributes by adding them to the role.