Does anyone have instruction on how to backup and restore prisma PG database? I could never get it right and prisma always return errors Thx!

Hey Chad 👋 what errors were you facing while restoring a db? Also were you using a cli tool like

pg_dump

or a GUI like

pgAdmin

?

I use pg_dump and psql in datagrip. I know there are 2 schemas that prisma has: management and public (unless you set it to something else). Are we suppose to drop and restore the entire DB and then do prisma deploy?

I have a similar question actually, I'm trying to migrate to the 1.1 datamodel and followed the posted guide, but all the relations between tables seem to be lost when I change the relationships from table => inline. Is this a manual process where I need to add the foreign keys before I

prisma export

or am I missing something?

@Clio Harper where is this guide you mentioned? Thanks!

This may not apply to your case but the guide I was referencing is located here