Facing issue on shopify remix app hosting with postgres db in fly.io

Questions / Help
1

I am developing a Shopify app using the Remix template and Prisma with an SQLite database. Currently, I am working on hosting the app on Fly.io and want to set up a PostgreSQL database instead of SQLite.

I successfully deployed my app on Fly.io, but I am facing issues during the database setup. When I run the command:
npx prisma migrate dev

I get the following error:

Datasource “db”: PostgreSQL database “…”, schema “public” at “…:5432”

Error: P1001: Can’t reach database server at …:5432

I need a step-by-step guide to host the app with a properly configured PostgreSQL database on Fly.io. Any help would be greatly appreciated. Thank you in advance!

2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.