Prisma•2y ago

backup in prisma

hey, i quickly want to know how we handle backup in prisma

4 Replies

Hi @broooo 👋 Prisma is primarily an ORM tool for interacting with databases, and it does not have built-in features specifically for managing backups. You would need to use the backup tools provided by your DBMS. Most modern database systems like PostgreSQL, MySQL, and MongoDB offer utilities or methods for creating backups. These can include commands like pg_dump for PostgreSQL, mysqldump for MySQL, or mongodump for MongoDB.

nicolae2•2mo ago

It's not working! They've created only the "create back-up file", but not the "applying back-up file". When I try to apply the back-up file it says: "pg_restore: error: input file does not appear to be a valid archive". Probably they've never tried to back-up a database, but they say it's possible........ DID YOU EVER TEST THAT FUNCTIONALITY @RaphaelEtim ????

Ankur Datta•2mo ago

Hi @nicolae2 could you confirm whether your local PostgreSQL tooling version matches the Prisma Postgres version? It should be version 17. Both versions need to match for the pg_restore tool to restore the data successfully. Once confirmed, you can connect directly to your Prisma Postgres database and run the following command:

PGSSLMODE=disable \
pg_restore \
  --verbose \
  --clean \
  --no-acl \
  --no-owner \
  -h HOST \
  -p PORT \
  -U USERNAME \
  -d my_database \
  ./db_dump.bak

PGSSLMODE=disable \
pg_restore \
  --verbose \
  --clean \
  --no-acl \
  --no-owner \
  -h HOST \
  -p PORT \
  -U USERNAME \
  -d my_database \
  ./db_dump.bak

nicolae2•2mo ago

Hi! I remember that I downloaded PostgreSQL tooling version 18. I thought that if I get the latest version it will work with the lower versions. However, do you know if in Prisma documentation it writes that I have to use the same version for Prisma and PostgreSQL version? Or that different versions of Prisma Postgres and PostgreSQL could not be compatible?

Gaming

Programming

backup in prisma

Did you find this page helpful?