Postgres: backup restore schema and / or table
On the GENERAL tab, In the pop up window, choose
(1) a path and file name
(2) DIRECTORY as the format
On the DATA OPTIONS tab, make the choices as above
Click BACKUP button
Track the backup on the PROCESSES tab.
Click on the notepad to see the log:
Run the backup of the same schema for a second time, but this time to capture the POST data.
Name the file an appropriate name. But this time in the DATA OPTIONS tab, choose POST-DATA:
In the DATA OPTIONS tab, choose POST-DATA plus the other options as the screenshot above.
Then click on the BACKUP button.
Again, you can track the backup in the PROCESSES tab. (see pages 3 and 4)
On the target database, the schema should not exist.
So if exist, please ‘DELETE CASCADE . . .’ the schema.
Right click on RESTORE of the target database:
Then Click on RESTORE
On the pop up window, in the GENERAL tab, choose
(1) FORMAT as directory
(2) Filename of the first backup taken
Click on RESTORE.
Again, you can track the restore by viewing the log on the notepad (see pages 3 and 4)
Please also restore the file with the POST-DATA.
2023 October 9th
Thanks
G!
Comments
Post a Comment