This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
wiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:01] – [New procedure] neyron | wiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:06] – [New procedure] neyron | ||
---|---|---|---|
Line 6: | Line 6: | ||
See: https:// | See: https:// | ||
- | |||
- | Once the postgresql database engine is setup, oar database created with the oar user (using the oar-database tool), one can use the oar-database-migrate tools, as follows: | ||
Installation of oar-cli which provides oar-database-migrate: | Installation of oar-cli which provides oar-database-migrate: | ||
Line 18: | Line 16: | ||
</ | </ | ||
- | Creation of the new OAR database (in postgresql) + oar database | + | Create |
< | < | ||
$ sudo oar-database --create --db-is-localuser | $ sudo oar-database --create --db-is-localuser | ||
Line 24: | Line 22: | ||
$ dropdb oar | $ dropdb oar | ||
$createdb oar -O oar | $createdb oar -O oar | ||
- | $exit | + | $ exit |
</ | </ | ||
+ | Run the migration | ||
< | < | ||
oar-database-migrate --current-db-url mysql:// | oar-database-migrate --current-db-url mysql:// | ||
</ | </ | ||
+ | Fix the rights of the oar database users (oar and oarreader in this example): | ||
+ | < | ||
+ | $ psql oar2 | ||
+ | GRANT ALL PRIVILEGES ON schema, | ||
+ | challenges, | ||
+ | gantt_jobs_predictions_visu, | ||
+ | job_dependencies, | ||
+ | job_state_logs, | ||
+ | resource_logs, | ||
+ | files_file_id_seq, | ||
+ | job_state_logs_job_state_log_id_seq, | ||
+ | moldable_job_descriptions_moldable_id_seq, | ||
+ | resources_resource_id_seq, | ||
+ | |||
+ | GRANT SELECT ON schema, | ||
+ | event_logs, | ||
+ | gantt_jobs_resources, | ||
+ | job_resource_descriptions, | ||
+ | jobs, | ||
+ | event_logs_event_id_seq, | ||
+ | job_state_logs_job_state_log_id_seq, | ||
+ | moldable_job_descriptions_moldable_id_seq, | ||
+ | resources_resource_id_seq, | ||
+ | </ | ||
+ | |||
+ | This procedure is based on Grid' | ||
==== Old Procedure ==== | ==== Old Procedure ==== | ||
The procedure proposed here follows these steps: | The procedure proposed here follows these steps: |