Hey guys, I am trying to connect to supabase postgres db using prisma & I am getting the following error when running prisma migrate. I have looked at a few tutorials on youtube and they all seem to be doing the same thing as me. Any idea why I am getting this issue? I thought it might be to do with PgBouncer but not entirely sure. I have had a look at these docs: https://www.prisma.io/docs/guides/performance-and-optimization/connection-management/configure-pg-bouncer https://www.prisma.io/docs/concepts/components/prisma-migrate/shadow-database#shadow-database-user-permissions The error I am getting is the following: db error: FATAL: unexpected response from login query 0: sql_migration_connector::flavour::postgres::sql_schema_from_migration_history at migration-engine\connectors\sql-migration-connector\src\flavour\postgres.rs:363 1: migration_core::state::DevDiagnostic at migration-engine\core\src\state.rs:178 My env file DATABASE_URL=postgres://postgres:mypassword@my.database.supabase.co:6543/postgres Any ideas? Cheers 🙂

Hello @georgeaffield! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Want to unsubscrie from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! Done using the thread? Click the button below to archive it.

U are missing the schema on Connecticut url

georgeaffield (2022-03-11)

At the end add for example

?schema=public