Adapter specific versions of Postgres, Redshift, and Bigquery

Follows from Move to adapter-specific installations of dbt (... (#3105 - closed)

This issue is planned as a follow-up to the initial dbt-snowflake release.

To have parity, we likely need these three:

• dbt-postgres
• dbt-redshift
• dbt-bigquery

Possible:

• `dbt-spark[PyHive]
• dbt-presto

Full list of dbt Labs supported adapters https://docs.getdbt.com/docs/available-adapters