Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

<@ULVA73B9P> what value should I set `PREFECT_SERVER_DATABASE_DRIVER` to when using postgres, but not setting `PREFECT_SERVER_DATABASE_CONNECTION_URL` or `PREFECT_API_DATABASE_CONNECTION_URL`

:white_check_mark: thought for 20.2 seconds

When using PostgreSQL with Prefect, you should set `PREFECT_SERVER_DATABASE_DRIVER` to either:

- `postgresql` (standard choice)
- `postgresql+psycopg2` (if you specifically want to use the psycopg2 driver)

The first option (`postgresql`) is the most common and recommended choice. When you set just the driver, Prefect will use it along with other database-related environment variables (like `PREFECT_SERVER_DATABASE_USERNAME`, `PREFECT_SERVER_DATABASE_PASSWORD`, etc.) to construct the full connection URL internally.

For example, you might set it like this:
```bash
export PREFECT_SERVER_DATABASE_DRIVER="postgresql"
```

You can find more details about database configuration settings in the <https://docs-3.prefect.io/v3/api-ref/settings-ref|Prefect settings reference documentation>.

Well that was wrong.
```Input should be 'postgresql+asyncpg' or 'sqlite+aiosqlite' ```