Enable profiles for testing on MariaDB and PostgreSQL

Description

To enable these tests on ci.hibernate.org (and locally for those who have a similar setup) it's useful to add two new profiles.
Some tests need fixes too, as we've not run these tests for some months.

Environment

None

Assignee

Sanne Grinovero

Reporter

Sanne Grinovero

Labels

None

Suitable for new contributors

None

Feedback Requested

None

Components

Fix versions

Priority

Major
Configure