Switch to pgsql-only

Created by: njoyard

This PR switches the project to PostgreSQL only. This is necessary for future updates. Some views and tests have been fixed to not rely on default database ordering (hence the fixture changes).