Hey All How to set database as cloud sql instead of sqlite i

Question

Hey All How to set database as cloud sql instead of sqlite in Prefect Kubernetes Setup

Kevin Kho · Answer

Have you seen <https orion docs prefect io concepts database configuring a postgresql database|this>

Amit Gupta · Answer

Yes it specify setting up database on same host and for docker mode only It doesn t specify how to use remote Postgres CloudSql when using Prefect in Kubrenetes

Kevin Kho · Answer

Did you use the helm chart or are you deploying Orion in one pod

Amit Gupta · Answer

Used this to deploy

Amit Gupta · Answer

prefect orion kubernetes manifest | kubectl apply f

Kevin Kho · Answer

Then I think in the manifest you just need to add the extra environment variable to point to postgres

Amit Gupta · Answer

Can t find anything related to same in the manifest file

Kevin Kho · Answer

There is this section which has the container You can try putting the env variable in the `api` container so that orion starts pointing to the database you want ```spec selector matchLabels app orion replicas 1 We re using SQLite so we should only run 1 pod template metadata labels app orion spec containers name api image prefecthq prefect 2 0b7 python3 8 command prefect orion start host 0 0 0 0 log level WARNING imagePullPolicy IfNotPresent ports containerPort 4200 name agent image prefecthq prefect 2 0b7 python3 8 command prefect agent start kubernetes imagePullPolicy IfNotPresent env name PREFECT API URL value <http orion 4200 api>```

Kevin Kho · Answer

Actually the agent might need it too

Amit Gupta · Answer

ok Thanks Let me try

Amit Gupta · Answer

< Pretush Gupta>

Amit Gupta · Answer

Hi Kevin We tried but could not connect to our existing Postgres Instance Could you please help us where to specify the Postgres connection in the Manifest or could you point us to config file where can we specify the same

Pretush Gupta · Answer

any update on this

Kevin Kho · Answer

What did you try

Pretush Gupta · Answer

I tried deploying yaml on kubernetes in cluster but it doesn t connect with my postres server So I need help with connecting postgres server using helm chart to kubernetes

Pretush Gupta · Answer

< Aishwarya Vaibhav>

Kevin Kho · Answer

I get that but how did you try connecting ```spec selector matchLabels app orion replicas 1 We re using SQLite so we should only run 1 pod template metadata labels app orion spec containers name api image prefecthq prefect 2 0b7 python3 8 command prefect orion start host 0 0 0 0 log level WARNING imagePullPolicy IfNotPresent ports containerPort 4200 env name PREFECT ORION DATABASE CONNECTION URL value <postgresql+asyncpg postgres yourTopSecretPassword localhost 5432 orion>``` like that

Pretush Gupta · Answer

yess