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:05] – [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 33: | Line 31: | ||
| 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> | + | < |
| $ psql oar2 | $ psql oar2 | ||
| GRANT ALL PRIVILEGES ON schema, | GRANT ALL PRIVILEGES ON schema, | ||
| Line 56: | Line 54: | ||
| resources_resource_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: | ||