Moodle in English: Migrating from mysql to Postgres

Installing and upgrading help

Migrating from mysql to Postgres

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

Migrating from mysql to Postgres

by Ivica Matotek - Thursday, November 30, 2017, 7:36 PM

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

Re: Migrating from mysql to Postgres

by Howard Miller - Thursday, November 30, 2017, 10:11 PM

$ 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:Useful (1)

Re: Migrating from mysql to Postgres

by Ivica Matotek - Friday, December 1, 2017, 3:28 PM

Hi!

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

Ivica

Average of ratings: -

Re: Migrating from mysql to Postgres

by Howard Miller - Friday, December 1, 2017, 5:16 PM

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: -