Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
howto:pgdump [2019/10/15 12:09]
ibk [BPS Scripts using PostgreSQL Data Tools]
howto:pgdump [2019/10/15 12:10] (current)
ibk [BPS Scripts using PostgreSQL Data Tools]
Line 18: Line 18:
 **bpspgexp.cmd** exports only vital table data and sequences. The perfect time for exporting a production schema is when nobody else is working on it. Nevertheless the export with pulls a consistent copy of the time the export was started. **bpspgexp.cmd** exports only vital table data and sequences. The perfect time for exporting a production schema is when nobody else is working on it. Nevertheless the export with pulls a consistent copy of the time the export was started.
  
-For import with **bpspgimp.cmd**,​ a clean BPS schema needs to be present on the target postgresql server. This may be an existing schema, or one that was just created with the «BPS Datastore Setup» assistant. Only the table data are then imported into that clean schema, and the current sequences are recreated. This way, all other objects, grants etc are left in a clean state and you have a perfect BPS datastore.+For import with **bpspgimp.cmd**,​ a BPS schema needs to be present on the target postgresql server. Only the table data are then imported into that schema, and the current sequences are recreated. This way, all other objects, grants etc are left in a clean state and you have a perfect BPS datastore.
  
 After importing with bpspgimp.cmd,​ the only step left is to recreate the BPS database users in the users app of the BPS GUI. After importing with bpspgimp.cmd,​ the only step left is to recreate the BPS database users in the users app of the BPS GUI.
  
-The scripts must run with the credentials of postgres or other user with postgresql superuser privileges.+The scripts must run with the credentials of postgresor an other user with postgresql superuser privileges.
  
 ===== Instructions ===== ===== Instructions =====