Create transition's postgres role before using it as owner

We have seen failures on an initial Puppet run if the role isn't
created before the database is created with the role as its owner.
This brings this postgres db setup in line with what we have currently
in GOV.UK puppet.