Postgres migrations should be covered by a transaction

Currently, a transaction can fail halfway through being applied - and it wouldn't be handled.