Channels
announcements
ask-marvin
best-practices-coordination-plane
data-ecosystem
data-tricks-and-tips
events
find-a-prefect-job
geo-bay-area
geo-berlin
geo-boston
geo-chicago
geo-colorado
geo-dc
geo-israel
geo-japan
geo-london
geo-nyc
geo-seattle
geo-texas
gratitude
introductions
marvin-in-the-wild
pacc-clearcover-june-12-2023
pacc-may-31-2023
ppcc-may-16-2023
prefect-ai
prefect-aws
prefect-azure
prefect-cloud
prefect-community
prefect-contributors
prefect-dbt
prefect-docker
prefect-gcp
prefect-getting-started
prefect-integrations
prefect-kubernetes
prefect-recipes
prefect-server
prefect-ui
random
show-us-what-you-got
Title
p
Prasanth Kothuri
02/20/2023, 9:10 AMHi, 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