I am trying to use postgres as the database instead of sqlite. While I managed to connect the webserver to the pg db, cli commands for deployments don't seem to reflect on orion. How does the connection between cli commands and the database work, how can I change the link from the old sqlite database to the new pg one?

this setting is what you need - change it from:

prefect config set PREFECT_ORION_DATABASE_CONNECTION_URL='sqlite+aiosqlite:///${PREFECT_HOME}/orion.db'

to:

prefect config set PREFECT_ORION_DATABASE_CONNECTION_URL="<postgresql+asyncpg://postgres:pwd@localhost:5432/orion>"

Got it now, thanks!