Moodle in English: Migrating from mysql to Postgres

Installing and upgrading help

Migrating from mysql to Postgres

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

Permalink | Reply

$ 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)

Permalink | Show parent | Reply

Hi!

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

Ivica

Average of ratings: -

Permalink | Show parent | Reply

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

Permalink | Show parent | Reply