Many validated identification results can be exported within a relational database. This feature requires :

• Postgresql 8.x, 9.x (test done on 8.1, 8.4, 9.1)
• an existing database

For more information on MSI db, see corresponding page

• Execute PostgreSQL 8.1.msi
• Follow instructions
• Note : master password needs to be set at this stage

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)

• 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

• Execute the queries
• The database gets populated with all the tables IRMa needs to store identifications data

• 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

• Test connexion to make sure you can access the DB

• 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)

• You’re ready to export