Backing up data with Prisma Postgres
What is the recommended approach for backing up data with Prisma Postgres? Historically I've used
pg_dump but after migrating to a Prisma Postgres db, the database url uses an api key instead of a user/pass combo and pg_dump is saying I have an invalid param (api_key)3 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Update: I ended up solving this using a similar approach to the guide of restoring prisma postgres with another postgres db: https://www.prisma.io/docs/getting-started/prisma-postgres/import-from-existing-database-postgresql. I just used
pg_dump once the TCP tunnel was startedGlad to hear that everything worked as expected 🙏