tests: ensure LC_ALL is set to C.UTF-8 for pytest
so the pytest-postgresql fixture works as expected on non C locale systems.