Installing and upgrading help

Migrating from mysql to Postgres

 
Picture of Ivica Matotek
Migrating from mysql to Postgres
Testers

Hi!

I'm using Moodle 3.3 and interested to migrate from MySQL db to postgres, but there is no Postgres option in Administration -> Experimental -> Migration database, there are only Maria, MySQL, MSSQL but there are no postgres. Does anybody know it there are possibility to migrate to postgres with this tool? Server is hosted Linux, debian.

Thank you.


Ivica

 
Average of ratings: -
Picture of Howard Miller
Re: Migrating from mysql to Postgres
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers
$ php migrate.php
Database migration - make sure nobody is accessing the server during migration!
== Choose database driver (mysqli, pgsql, mariadb) ==
type value
:


pgsql is postgres. 

 
Average of ratings: -
Picture of Ivica Matotek
Re: Migrating from mysql to Postgres
Testers

Hi!

Thank you, I didn't have psql but when I added php5-pgsql package to my server it appears.


Ivica

 
Average of ratings: -
Picture of Howard Miller
Re: Migrating from mysql to Postgres
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers

Ahh.... I didn't realise that it only showed modules you have installed. I'm not sure if that's terribly helpful...

 
Average of ratings: -