tests: Simply testing of temporary scheduler backend

The temporary scheduler backend creates a disposable PostgreSQL database that is dropped when Python session ends. As we already executed tests for a PostgreSQL backend in test_scheduler.py, we only need to check that the backend can be successfully instantiated.

This greatly speedup overall scheduler tests execution.