P
Prisma2mo ago
mata3932

stuck with prisma and supabase using nextjs14 when i want to npx prisma db push/ migrate / reset etc

Environment variables loaded from .env It is almost 24h since i have been stuck in it using nextjs14 I tried to reset supabase server multiple times and recreater the server and clone the repo still i am stuck in the new repo as well Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-eu-central-1.pooler.supabase.com:xxxx" prisma: 4.16, supabase: 1.165 At first i tho since i am in SEA maybe supabase banned i am trying using a VPN without luck as well i am not sure what is going on. Thats all i could get from GPT as well is something weird going on or is just myself? Seek Community Support
4 Replies
mata3932
mata39322mo ago
ok weird enought i did a bunch of thins so i am not really sure which one fixed it 5432/postgres?pgbouncer=true" i added this to the DIRECT_URL and DATABASE_URL
jonfanz
jonfanz2mo ago
We're hearing this a lot recently. I'm going to update our docs to clarify: - the URL with port 6543 and with the query param ?pgbouncer=true should be your DATABASE_URL - the URL with port 5432 and without query params should be your DIRECT_URL
mata3932
mata39322mo ago
ok thanks!