Has anyone successfully run supertokens core on heroku with

Question

Has anyone successfully run supertokens core on heroku with heroku s psql I m getting an issue with drivers The database url begins with `postgresql ` so it seems the `jdbc ` prefix is coming from someplace else ``` Setting up PostgreSQL connection pool 2022 10 07T02 04 20 842175+00 00 app web 1 Stopping SuperTokens 2022 10 07T02 04 20 856938+00 00 app web 1 31mWhat caused the crash Driver org postgresql Driver claims to not accept jdbcUrl jdbc postgres ec2 107 23 76 12 compute 1 amazonaws com 5432 ```

nkshah2 · Answer

< jscyo> Maybe you can check this

jscyo · Answer

Hey taking a look

jscyo · Answer

Hey < ZachEqui> so as mentioned in this post https stackoverflow com questions 34741443 hikaricp postgresql driver claims to not accept jdbc url you will need to change the `postgres` in your connection uri to `postgresql` your updated connection uri should look like `postgresql ec2 107 23 76 12 compute 1 amazonaws com 5432 `

ZachEqui · Answer

Yep Did that Same error

ZachEqui · Answer

`export PSQL URL=$ echo $DATABASE URL | sed s jdbc postgres postgresql `

ZachEqui · Answer

ah maybe it s just `export PSQL URL=$ echo $DATABASE URL | sed s postgres postgresql `

ZachEqui · Answer

Ah that fixed it The error log from supertokens said `jdbc postgres` so that s what I was trying to transform this worked ```export PSQL URL=$ echo $DATABASE URL | sed s postgres postgresql echo e postgresql connection uri $PSQL URL npostgresql table schema supertokens ncore config version 0 > config yaml```