This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
userguide:export_db [2009/12/02 15:13] 132.168.73.9 |
userguide:export_db [2012/03/02 14:58] 132.168.72.131 |
||
---|---|---|---|
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.1 | + | * Postgresql 8.x, 9.x (test done on 8.1, 8.4, 9.1) |
* an existing database | * an existing database | ||
+ | |||
+ | For more information on MSI db, see [[..:msidb|corresponding page]] | ||
+ | |||
+ | ===== Installing a database ===== | ||
==== Installing Postgresql ==== | ==== Installing Postgresql ==== | ||
Line 37: | Line 41: | ||
- | For more information on MSI db, see [[..:msidb|corresponding page]] | + | ===== Connecting to a database ===== |
+ | * Disconnect from the database and quit pgAdmin III | ||
+ | * Go back to IRMa | ||
+ | * In IRMa preferences select the DB export tab | ||
+ | * Under Connection settings, select Edit | ||
+ | {{:userguide:connecting-to-database-1.png?300}} | ||
+ | |||
+ | * Test connexion to make sure you can access the DB | ||
+ | {{:userguide:connecting-to-database-2.png?300}}{{:userguide:connecting-to-database-3.png?250}} | ||
+ | |||
+ | * Make sure that under the tab « Saved elements » you deselect the export of unassigned queries and peptides (this slows down the transfer and tracks quite useless information) | ||
+ | {{:userguide:connecting-to-database-4.png?300}} \\ | ||
+ | |||
+ | |||
+ | * {{:userguide:connecting-to-database-5.png?500}} | ||
+ | |||
+ | * **You’re ready to export** | ||
+ | {{:userguide:connecting-to-database-6.png?500}} | ||