npx prisma db push not working
Closed this issue · 3 comments
I followed each and every step properly of providing the UTI of the "DIRECT_URL" with the exact port no.(as shown in the tutorial.) Still I'm getting an error on running the CLI npx prisma db push
@ski043 Could you please share any update or any fix of the issue.
Facing the problem at 01:33:87 of the tutorial. Can anyone please help me resolve the issue of this Supabase with postgres??
Thank you in advance.
https://supabase.com/partners/integrations/prisma
Check if you did it correctly
@ski043
Did exactly the same with the correct port no. with reference to the docx. The error still persists.
When pushing the schema to the db, try using the DATABASE_URL & DIRECT_URL without the ":6532/postgress?pgbouncer=true&conection_limit=1"
:
# not this
DATABASE_URL = "postgres://postgres.qzshylushurbreqcebld:<PASSWORD>@aws-0-eu-west-1.pooler.supabase.com:6543/postgres?pgbouncer=true&connection_limit=1"
DIRECT_URL = "postgres://postgres.qzshylushurbreqcebld:<PASSWORD>@aws-0-eu-west-1.pooler.supabase.com:5432/postgres"
# edit this
DATABASE_URL = "postgres://postgres.qzshylushurbreqcebld:<PASSWORD>@aws-0-eu-west-1.pooler.supabase.com"
DIRECT_URL = "postgres://postgres.qzshylushurbreqcebld:<PASSWORD>@aws-0-eu-west-1.pooler.supabase.com"