I'm attempting to connect prisma to a postgres dat...
# orm-help
w
I'm attempting to connect prisma to a postgres database.. on the latest version of prisma, I get no output what so ever. I downgrated to 1.12 and prisma can't connect to my postgres database hosted on heroku.. I'm able to connect to this instance from Adminer from the same laptop.. any idea why prisma can't connect? I've tried with SSL Yes and No, and results are same regardless of what I choose.
r
Hey @Will 👋 Could you share your
docker-compose.yml
file if possible where you have mentioned the DB connection params?
✔️ 1
w
I'm doing this via
prisma init
Copy code
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host ec2-5*****<http://0-8.compute-1.amazonaws.comec2-xxxx-8.compute-1.amazonaws.com|0-8.compute-1.amazonaws.comec2-xxxx-8.compute-1.amazonaws.com>
? Enter database port 5432
? Enter database user xwtXXXXsddz
? Enter database password 9fadXXXXXXX575a86b9cd9758c
? Enter database name dboXXXXX3q8
? Use SSL? Yes
? Enter name of existing schema public


Connecting to database... !
Error: Could not connect to database. Socket is closed
I'm running prisma from the
./node_modules/.bin
folder if it makes a difference