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

For prefect server, I am trying to provide the postgres username and password via environment variables, instead of providing the full postgres URL as a single environment variable.

That is failing with `AttributeError: 'str' object has no attribute 'get_secret_value'`. Am I missing something?
See repro in the thread.

Dockerfile:
```FROM python:3.10.15-bookworm

RUN pip install prefect==3.1.11
RUN pip install asyncpg==0.30.0

ENV PREFECT_SERVER_DATABASE_DRIVER=postgresql+asyncpg
ENV PREFECT_SERVER_DATABASE_HOST=localhost
ENV PREFECT_SERVER_DATABASE_NAME=prefect
ENV PREFECT_SERVER_DATABASE_PORT=4200
ENV PREFECT_SERVER_DATABASE_USER=prefect
ENV PREFECT_SERVER_DATABASE_PASSWORD=mypassword

ENTRYPOINT ["prefect", "server", "start", "--host", "0.0.0.0"]```
Commands:

```docker build -t prefect-db .
docker run --rm -it prefect-db```
Output:
```Traceback (most recent call last):
  File "/usr/local/bin/prefect", line 5, in &lt;module&gt;
    from prefect.cli import app
  File "/usr/local/lib/python3.10/site-packages/prefect/cli/__init__.py", line 12, in &lt;module&gt;
    import prefect.cli.shell
  File "/usr/local/lib/python3.10/site-packages/prefect/cli/shell.py", line 16, in &lt;module&gt;
    from prefect import flow
  File "&lt;frozen importlib._bootstrap&gt;", line 1075, in _handle_fromlist
  File "/usr/local/lib/python3.10/site-packages/prefect/__init__.py", line 113, in __getattr__
    module = importlib.import_module(mname, package=package)
  File "/usr/local/lib/python3.10/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "/usr/local/lib/python3.10/site-packages/prefect/main.py", line 44, in &lt;module&gt;
    prefect.logging.configuration.setup_logging()
  File "/usr/local/lib/python3.10/site-packages/prefect/logging/configuration.py", line 71, in setup_logging
    config = load_logging_config(
  File "/usr/local/lib/python3.10/site-packages/prefect/logging/configuration.py", line 41, in load_logging_config
    template.substitute(current_settings.to_environment_variables())
  File "/usr/local/lib/python3.10/site-packages/prefect/settings/base.py", line 92, in to_environment_variables
    env: Dict[str, Any] = self.model_dump(
  File "/usr/local/lib/python3.10/site-packages/pydantic/main.py", line 426, in model_dump
    return self.__pydantic_serializer__.to_python(
pydantic_core._pydantic_core.PydanticSerializationError: Error calling function `_serialize_secret_field`: AttributeError: 'str' object has no attribute 'get_secret_value'```

<https://prefect-community.slack.com/archives/CL09KU1K7/p1736450577988349?thread_ts=1736406560.460759&amp;cid=CL09KU1K7|x-posting for visibility> :wave: