Differences

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

--- wiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:06] – [New procedure] neyron
+++ wiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:11] (current) – [New procedure] neyron
@@ Line 27: / Line 27: @@
 Run the migration
 <code>
-oar-database-migrate --current-db-url mysql://oarreader:PASSWORD@.../oar --new-db-url postgresql://oar:PASSWORD@/...
+oar-database-migrate --current-db-url mysql://oar_ro:PASSWORD@mysql_server/oar --new-db-url postgresql://oar:PASSWORD@/pgsql_server
 </code>
-Fix the rights of the oar database users (oar and oarreader in this example):
+Fix the rights of the oar database users (oar and oar_ro in this example):
 <code>
 $ psql oar2
@@ Line 52: / Line 52: @@
   job_state_logs_job_state_log_id_seq,job_types_job_type_id_seq,
   moldable_job_descriptions_moldable_id_seq,resource_logs_resource_log_id_seq,
-  resources_resource_id_seq,jobs_job_id_seq TO oarreader;
+  resources_resource_id_seq,jobs_job_id_seq TO oar_ro;
 </code>