https://prefect.io logo
Title
p

Prasanth Kothuri

02/20/2023, 9:10 AM
Hi, I am installing prefect on-premise, unable to set database URL to postgres, any ideas?
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'.
answering my own Q! updated to prefect 2.8.2 and it works !
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