![]() Now try steps 5 to 9 again, it should work outĮDIT - Some additional notes. Go to "Query Tool"Įxecute this code block: DROP SCHEMA public CASCADE CREATE SCHEMA public Should step 9 fail, try deleting your old public schema on your database. You can navigate over to your tables to see if the data has been restored propery on each table. If all is good, the bottom right should popup an indicator showing a successful restore. You'll see this page again, with the location of the file selected. Now hit the bottomright "Select" button to confirm You might have to change the filter at bottomright to "All files". Because you will run into error permissions. Make sure to select the file location manually, DO NOT drag and drop a file onto the uploader fields in pgadmin. Have said person go to pgadmin and restoreĭo this by rightclicking the database -> "restore" There might come a time your coworker wants to use your restore file on their local machine. Click the "more details" page to see where your backup downloaded toĪssuming you did steps 1 to 4 correctly, you'll have a restore binary file. There should be a popup at the bottomright of your screen. This creates a binary file dump, it's not in a. This will open up a browser tab in chrome.ĭo this by rightclicking the database -> "backup" ![]() If you use macOS you can press CMD+ SPACE and type pgadmin4 to run it. Here's the whole process of creating a copying over a database using only pgadmin4 GUI (via backup and restore)
0 Comments
Leave a Reply. |