[BUG] Error Installing with uv: UserWarning: Unknown distribution option: 'test_suite' | Error: pg_config executable not found

[jim256]

Describe the bug
When I try to install dbt-coves using uv, it fails due to an issue with dlt[redshift]:

To Reproduce
Steps to reproduce the behaviour:

uv init
uv add dbt-coves

Expected behaviour
Successful installation

Console Log/Tracebacks
Please avoid screenshots if possible, instead copy and paste the console and wrap it in

Using CPython 3.12.9 interpreter at: /usr/local/bin/python3.12
Creating virtual environment at: .venv
  × Failed to build `psycopg2cffi==2.9.0`
  ├─▶ The build backend returned an error
  ╰─▶ Call to `setuptools.build_meta:__legacy__.prepare_metadata_for_build_wheel` failed (exit status: 1)

      [stderr]
      /Users/<user name>/.cache/uv/builds-v0/.tmpSNqw4u/lib/python3.12/site-packages/setuptools/_distutils/dist.py:289:
      UserWarning: Unknown distribution option: 'test_suite'
        warnings.warn(msg)
      Error: pg_config executable not found.
      Please add the directory containing pg_config to the PATH.

      hint: This usually indicates a problem with the package or the build environment.
  help: If you want to add the package regardless of the failed resolution, provide the `--frozen` flag to skip locking and
        syncing.

Desktop (please complete the following information):

• OS: macOS 15.3.2
• Version: 1.9.0
• Python 3.12.9

Additional context

Mirror of issue in dlt repo:
dlt-hub/dlt#2475

If I do try uv's option of providing the --frozen flag, it installs ok, but then fails to find / use the Snowflake adapter:

23:36:06  Error importing adapter: No module named 'dbt.adapters.snowflake'
❌ Runtime Error
  Credentials in profile "dpdm_analytics_dbt_profile", target "dev" invalid: Runtime Error
    Could not find adapter type snowflake!

This occurs even though I do have dbt-snowflake installed in my environment and am able to execute dbt run,