[tests] Isolate postgres test actions

Isolate postgres tests to be runnable tasks like the other test types.