if we're stopping, resetting and starting this fixture, let's us ourself question, if it's really needed here, since we're getting same behaviour as having a process fixture function scoped.

I'd re-introduce function scope to process fixture, and provide this finalizer to process fixture:
https://github.com/clearcode/pytest-dbfixtures/pull/38/files#diff-e900da3842c5366f04eb3907abfce04dL220