Hi I am installing prefect on premise unable to set database Prefect Community #ask-community

Hi, I am installing prefect on-premise, unable to ...

Prasanth Kothuri

02/20/2023, 9:10 AM

Hi, I am installing prefect on-premise, unable to set database URL to postgres, any ideas?

Copy code

root@dataeng-prefect:~# prefect version
Version:             2.7.12
API version:         0.8.4
Python version:      3.8.16
Git commit:          524c25cd
Built:               Mon, Feb 6, 2023 4:31 PM
OS/Arch:             linux/x86_64
Profile:             default
Server type:         <client error>
root@dataeng-prefect:~# prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://postgres:yourTopSecretPassword@localhost:5432/prefect>"

Unknown setting name 'PREFECT_API_DATABASE_CONNECTION_URL'.

Prasanth Kothuri

02/20/2023, 9:13 AM

answering my own Q! updated to prefect 2.8.2 and it works !

Copy code

root@dataeng-prefect:~# prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://postgres:yourTopSecretPassword@localhost:5432/prefect>"
Set 'PREFECT_API_DATABASE_CONNECTION_URL' to '<postgresql+asyncpg://postgres:yourTopSecretPassword@localhost:5432/prefect>'.
Updated profile 'default'.

root@dataeng-prefect:~# prefect version
Version:             2.8.2
API version:         0.8.4
Python version:      3.8.16
Git commit:          afbed19d
Built:               Fri, Feb 17, 2023 10:02 AM
OS/Arch:             linux/x86_64
Profile:             default
Server type:         ephemeral
Server:
  Database:          postgresql

🙌 1

5 Views

Open in Slack

Previous Next