User Tools

Site Tools


userguide:export_db

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
userguide:export_db [2012/03/02 14:58]
132.168.72.131
userguide:export_db [2016/07/25 10:54] (current)
132.168.72.225
Line 1: Line 1:
 ====== Database Export ====== ====== Database Export ======
 Many validated identification results can be exported within a relational database. ​ Many validated identification results can be exported within a relational database. ​
-This feature requires ​ +This feature requires  
-  * Postgresql ​8.x, 9.x (test done on 8.1, 8.4, 9.1)+  * Postgresql ​
   * an existing database   * an existing database
  
 For more information on MSI db, see [[..:​msidb|corresponding page]] For more information on MSI db, see [[..:​msidb|corresponding page]]
- 
-===== Installing a database ===== 
- 
-==== Installing Postgresql ==== 
-{{:​userguide:​postgres-install-msi.png?​400}} 
-  * Execute PostgreSQL 8.1.msi 
-  * Follow instructions 
-  * Note : master password needs to be set at this stage 
- 
- 
-=== Setting up a database === 
-{{:​userguide:​setting-up-database.png?​600}} 
- 
-{{:​userguide:​setting-up-database-2.png?​600}} 
- 
-Under user « postgres » : 
-  * Connect to database (dble_click) 
-  * Create new user « example » with permission to login and create a database 
-  * Disconnect from database (R-click) 
-  * Reconnect under « example » username (cf. above) 
-{{:​userguide:​setting-up-database-3.png?​500}} 
- 
-{{:​userguide:​setting-up-database-4.png?​600}} 
-  * Select database Uppsala and click the button « execute arbitraty sql queries » 
-  * In query window select file/​open ​ 
-  * Select the file MSIDBModel (previously named ExportDBModel) included in the IRMa installation folder 
-  * All the queries necessary to create the MSidb are now open 
- 
-{{:​userguide:​setting-up-database-5.png?​500}} \\ 
-{{:​userguide:​setting-up-database-6.png?​400}} \\  
-{{:​userguide:​setting-up-database-7.png?​400}} \\ 
-  * Execute the queries 
-  * The database gets populated with all the tables IRMa needs to store identifications data 
- 
  
 ===== Connecting to a database ===== ===== Connecting to a database =====
userguide/export_db.txt · Last modified: 2016/07/25 10:54 by 132.168.72.225