Migration from MySql to PostgreSQL

This forum was archived to /woltlab and is now in read-only mode.
  • Hello,


    im currently struggling to migrate a running database from MySQL to PostgreSQL.


    I've searched the forum but theres only one, nearly correlating, post (Umstellung von Postgresql auf MySQL). And in this post they are doing the wrong direction (postgresql -> mysql).


    I've already got my icingaweb+director module to the point where they recognize the existence auf PostgreSQL as DB-Type. Since i dont want to add all the Service-Sets/Templates/etc all over again - i would like to convert/migrate...there's tool's like pgloader which should do the job...im currently struggling to get this one going...


    Has anyone ever done something like this? if yes, any recommendations or hints to be successful?


    best regards,

    wolfgang