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.