[KDE-pim] New Install: AKONADI wit PostgreSQL

[Hessler, Klaus-Michael]

Thanks @ All,

Martin Steigerwald wrote:
> ... system wide PostgreSQL installation, a few other configuration 
> keys are needed. I think there is a documentation somewhere.
I tried hard, but I did not find any full description for a system wide 
PostgreSQL-Installation with AKONADI. I checked these pages:

  * Enrico Zini <https://www.enricozini.org/blog/2015/akonadi-install/>
  * PrKos.hr
    <https://prkos.hr/KOrganizer-and-Akonadi-Ubuntu-with-Postgres>:
    KOrganizer and AKONADI and PostgreSQL
  * Vinzenz Vietzke
    <https://vinzv.de/en/bringing-kmail-and-postgresql-together/>: KMail
    and PostgreSQL

Comparing these pages I found differences esp. with empty definitions in 
No. 7. This is the comparison and my schedule now:

1. Install PostgreSQL
    * OPEN (necessary?): install libQt5Sql5-postgresql [VV]
    * OPEN(necessary?): systemctl enable --now postgresql [VV]
2. Setup myself as PostgrSQL-user[VV] [Enrico Zini]:
    # su - postgres
    $ createuser <username>
    $ psql postgres
    postgres=# alter user <username> createdb;
    postgres=# \q;
    # exit
3. Transfer my actual databases (schemes / tables etc.)
4. Set up an additional database Akonadi using my regular user account 
[VV] [Enrico Zini]:
    $ createdb Akonadi-<username>
5. Install akonadi-server akonadi-backend-postgresql [Enrico Zini] [PrKos]
6. Stop Akonadi and remove settings (if any) [VV]:
    $ akonadictl stop
    $ rm -rf ~/.local/share/akonadi
7. Define connection to PostgreSQL-database "Akonadi", e.g. edit file 
~/.config/akonadi/akonadiserverrc [VV]:
[%General]
    Driver=QPSQL

    [QPSQL]
    Host=/tmp/Akonadi-<username>.hashOPEN: What means hash? Shall I keep 
the word or where to find the value?
    Host= [PrKos] [Enrico Zini] OPEN: This version or the one above?
    InitDbPath=/usr/bin/initdb
InitDbPath= [PrKos] [Enrico Zini] OPEN: This version or the one above?
    Name=Akonadi
    Name=Akonadi-<username> [PrKos] [Enrico Zini] OPEN: This version or 
the one above?
    Options=
    ServerPath=/usr/bin/pg_ctl
InitDbPath= [PrKos] [Enrico Zini] OPEN: This version or the one above?
    StartServer=true
StartServer=false [PrKos] [Enrico Zini] OPEN: This version or the one above?
The differences with the empty definitions (Host, ServerPath, 
InitDbPath) seem to be on purpose, ref. comment [PrKos]
        Also the  Name (add username after akonadi).
        After starting Akonadi service
           $ akonadictl start
        the configuration file reads with values for the empty 
definitions. OPEN: Can anybody confirm this?
8. Restart Akonadi [VV]:
    $ akonadictl start

Any objections or different recommendations? Also I'd appreciate any 
response in regards to my lines marked with OPEN.
And what is the easiest way to check the setup, may I use KAlarm for this?

Thank you!

Regards,
Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20201223/7e721c87/attachment.htm>