Run pg_dump and save dump to a temporary file