# Prompted to select btwn only Databricks or Spark after installing dbt-postgres

**URL:** <https://discourse.getdbt.com/t/prompted-to-select-btwn-only-databricks-or-spark-after-installing-dbt-postgres/12852>\
**Category:** Help\
**Tags:** postgres, dbt-core\
**Created:** [April 11, 2024, 6:18pm UTC](https://discourse.getdbt.com/t/prompted-to-select-btwn-only-databricks-or-spark-after-installing-dbt-postgres/12852 "2024-04-11T18:18:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![leoebfolsom](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/leoebfolsom/32/867_2.png) [@leoebfolsom](https://discourse.getdbt.com/u/leoebfolsom)\
**Post date:** [April 11, 2024, 6:18pm UTC](https://discourse.getdbt.com/t/prompted-to-select-btwn-only-databricks-or-spark-after-installing-dbt-postgres/12852/1 "2024-04-11T18:18:37Z")

</div>

## The problem I’m having

After `dbt init <my_proj_name>`, I’m prompted to select between only two DBs (databricks, spark). There isn’t an obvious way to enter the db I want to use (postgres, which [seems to be supported](https://docs.getdbt.com/docs/core/connect-data-platform/postgres-setup)) or escape the CLI wizard and just create the profile manually.

## The context of why I’m trying to do this

I’m trying to set up dbt with postgres.

## What I’ve already tried

Entering the string `postgres` in response to the prompt.

## Some example code or error messages

```auto
% pip install dbt-postgres
% dbt init <my_proj_name>
18:11:08 Running with dbt=1.7.9
18:11:08  
Your new dbt project "<my_proj_name>" was created!

For more information on how to configure the profiles.yml file,
please consult the dbt documentation here:

  https://docs.getdbt.com/docs/configure-your-profile

One more thing:

Need help? Don't hesitate to reach out to us via GitHub issues or on Slack:

  https://community.getdbt.com/

Happy modeling!

18:11:08 Setting up your profile.
Which database would you like to use?
[1] databricks
[2] spark

(Don't see the one you want? https://docs.getdbt.com/docs/available-adapters)

Enter a number: postgres
Error: 'postgres' is not a valid integer.
Which database would you like to use?
[1] databricks
[2] spark

(Don't see the one you want? https://docs.getdbt.com/docs/available-adapters)

Enter a number: 

```

---

<div class="post-metadata">

**Author:** ![gwenwindflower](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/gwenwindflower/32/1522_2.png) [@gwenwindflower](https://discourse.getdbt.com/u/gwenwindflower)\
**Post date:** [April 11, 2024, 6:37pm UTC](https://discourse.getdbt.com/t/prompted-to-select-btwn-only-databricks-or-spark-after-installing-dbt-postgres/12852/2 "2024-04-11T18:37:27Z")

</div>

hey @leoebfolsom ! do you have dbt-core installed? i only see you installing dbt-postgres? you’ll want to try `pip install dbt-core dbt-postgres` on the latest version of dbt (which will be installed if a version is not specificed) (per [Postgres setup | dbt Developer Hub](https://docs.getdbt.com/docs/core/connect-data-platform/postgres-setup))

---

<div class="post-metadata">

**Author:** ![leoebfolsom](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/leoebfolsom/32/867_2.png) [@leoebfolsom](https://discourse.getdbt.com/u/leoebfolsom)\
**Post date:** [April 11, 2024, 11:50pm UTC](https://discourse.getdbt.com/t/prompted-to-select-btwn-only-databricks-or-spark-after-installing-dbt-postgres/12852/3 "2024-04-11T23:50:56Z")

</div>

I bet that’s it, thanks! Will confirm when I’m at keyboard. For some reason, I mistakenly thought dbt-core was automatically installed in the env along with the adapter.