How to clone/migrate data from prisma postgresql to self hosted pg
I have a dev database on prisma pg which I have been using for production and i have accumulated some user data(23MB).
What is the best way to migrate/clone the database to a (1) prisma production database and (2) self hosted coolify postgresql?
I have tried connecting both(prisma & coolify) of them via pgadmin 4 and tried a simple backup and restore approach which failed(partially), seeing the data on the target database but pgadmin said "failed" with getting error:
My web app is based of nextjs, prisma+postgres which got a huge traffic(150k views) so i am migrating from vercel and prisma to coolify for affordability!
Another thing is, i have pushed 2 dev migration to the prisma postgres.
What is the best way to migrate/clone the database to a (1) prisma production database and (2) self hosted coolify postgresql?
I have tried connecting both(prisma & coolify) of them via pgadmin 4 and tried a simple backup and restore approach which failed(partially), seeing the data on the target database but pgadmin said "failed" with getting error:
My web app is based of nextjs, prisma+postgres which got a huge traffic(150k views) so i am migrating from vercel and prisma to coolify for affordability!
Another thing is, i have pushed 2 dev migration to the prisma postgres.
