make docs_snippets_tests runnable locally

Summary: Use TestPostgresInstance, was referencing an old docker-compose folder location

Test Plan: BK, run tox suite locally

Reviewers: sashank, nate

Reviewed By: nate

Differential Revision: https://dagster.phacility.com/D5869