Results 1 to 9 of 9

Thread: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

  1. #1
    Join Date
    Jun 2008
    Location
    Europe
    Posts
    429

    Default Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Many people on the kdepim mailing list complained about mysql and suggested to move to postgres in order to have less bugs.
    Do you share this opinion ?
    Why did opensuse choose mysql ?
    How to configure my new 15.2 with another db manager than the default before i import the mails ?
    Thanks for your answers.

  2. #2
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    265

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by Christophe_deR View Post
    Many people on the kdepim mailing list complained about mysql and suggested to move to postgres in order to have less bugs.
    Do you share this opinion ?
    Why did opensuse choose mysql ?
    Absolutely. KMail feels much more responsive with Postgres than with mysql.
    I think it is not openSUSE, but the KDE Project who has chosen mysql as default DB
    How to configure my new 15.2 with another db manager than the default before i import the mails ?
    There are some tutorials around, e.g. https://www.enricozini.org/blog/2015/akonadi-install/ but I'm sure it was described here in the )old) forum as well

  3. #3
    Join Date
    Jun 2008
    Location
    Europe
    Posts
    429

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Thanks for your answer.
    But the link you gave is about calendar and it doesn't exactly describes which actions and files to edit to migrate from msyql to postgres.
    Anyone has other methods and comments ?

  4. #4
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    3,199

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by Christophe_deR View Post
    Anyone has other methods and comments ?
    You can check the ArchWiki document: <https://wiki.archlinux.org/index.php/KDE#PIM> – it has pointers to other documents describing the migration to PostgreSQL.

  5. #5
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    265

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by dcurtisfra View Post
    You can check the ArchWiki document: <https://wiki.archlinux.org/index.php/KDE#PIM> – it has pointers to other documents describing the migration to PostgreSQL.
    As usually, the Arch wiki is a good resource. But I doubt the sentence:
    Code:
      
    
    • Starting with akonadi 19.08.0-1 the PostgreSQL database cluster in ~/.local/share/akonadi/db_data/ will get automatically upgraded when a major PostgreSQL version upgrade is detected.
    Leap 15.2 comes with akonadi 20.04, and there is *no* automatic migration to a newer postgres version.

  6. #6
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    3,199

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by DocB View Post
    Leap 15.2 comes with akonadi 20.04, and there is *no* automatic migration to a newer postgres version.
    On the other hand, there's this KDE advice on Akonadi and PostgreSQL: <https://userbase.kde.org/Akonadi/Postgres_update>.

  7. #7
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    265

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by dcurtisfra View Post
    On the other hand, there's this KDE advice on Akonadi and PostgreSQL: <https://userbase.kde.org/Akonadi/Postgres_update>.
    Yes, but that does not guarantee it works. I did already a couple of migrations, lately on TW when postgres 12 arrived, that went well, but on Leap 15.2 I was not successful, see: https://forums.opensuse.org/showthre...does-not-start

  8. #8
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    3,199

    Exclamation Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    Quote Originally Posted by DocB View Post
    I did already a couple of migrations, lately on TW when postgres 12 arrived, that went well, but on Leap 15.2 I was not successful, see: https://forums.opensuse.org/showthre...does-not-start
    In other words, for Leap 15.2, the current status is that, PostgreSQL is currently not an option for the Akonadi database – at least until this issue is repaired by the KDE folks …

  9. #9
    Join Date
    Jun 2008
    Location
    Europe
    Posts
    429

    Default Re: Kmail Migration : which db manager ? Mysql ? Postgres ? Else ?

    I would like to express my strong thanks for the people answering to my questions.

    So, now, we wander __when__ will this postgres new version be adapted for akonadi ?
    Any idea of the date/delay ? How to be warned of this date/delay ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •