connection url for prisma using cloud run and cloud sql on google cloud | Remix | Page 1

abstract kraken Feb 19, 2023, 9:10 AM

#

I have deployed a dockerized node app to google cloud run and connected to it cloud sql and I can see it in cloud sql connections tab
I added an env DATABASE_URL in this format

DATABASE_URL= "postgresql://{{username}}:{{password}}@{{connection name given by cloud sql}}:5432/{{database name}}}}"``
however its telling me cannot reach

#

no ssl no nothing I made it public ip

supple grail Apr 20, 2023, 1:37 AM

#

did you ever solve this? the connection string postgresql://user:pass@localhost/db_name?host=/cloudsql/project:region:instance-name seems to be the right format from my searching, but it doesn't work

supple grail Apr 24, 2023, 5:24 AM

#

ultimately i got it working, but there seemed to be a 10-20 minute lag between deploying the new service with a cloud sql connection and being able to connect over the socket.

#connection url for prisma using cloud run and cloud sql on google cloud