Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
wiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:05] – [New procedure] neyronwiki:migration_from_a_mysql_to_a_postgresql_database [2015/09/23 17:06] – [New procedure] neyron
Line 33: Line 33:
  
 Fix the rights of the oar database users (oar and oarreader in this example): Fix the rights of the oar database users (oar and oarreader in this example):
-</code>+<code>
 $ psql oar2 $ psql oar2
   GRANT ALL PRIVILEGES ON schema,accounting,admission_rules,assigned_resources,   GRANT ALL PRIVILEGES ON schema,accounting,admission_rules,assigned_resources,
Line 56: Line 56:
   resources_resource_id_seq,jobs_job_id_seq TO oarreader;   resources_resource_id_seq,jobs_job_id_seq TO oarreader;
 </code> </code>
 +
 +This procedure is based on Grid'5000 documentation: https://www.grid5000.fr/mediawiki/index.php/Migration_Postgres_OAR (access is restricted to Grid'5000 users)
 ==== Old Procedure ==== ==== Old Procedure ====
 The procedure proposed here follows these steps: The procedure proposed here follows these steps:
wiki/migration_from_a_mysql_to_a_postgresql_database.txt · Last modified: 2015/09/23 17:11 by neyron
Recent changes RSS feed GNU Free Documentation License 1.3 Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki