<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<tt> </tt>
<div class="moz-cite-prefix"><tt>Thanks @ All,</tt><tt><br>
</tt><tt><br>
</tt><tt>Martin Steigerwald wrote:</tt><tt><br>
</tt> </div>
<tt> </tt>
<blockquote type="cite" cite="mid:3097560.aeNJFYEL58@merkaba"><tt>...
system wide PostgreSQL installation, a few other configuration
keys are needed. I think there is a documentation somewhere.</tt></blockquote>
<tt> </tt><tt>I tried hard, but I did not find any full description
for a system wide PostgreSQL-Installation with AKONADI. I checked
these pages: </tt><tt><br>
</tt><tt> </tt><tt> </tt>
<ul>
<li><tt><a moz-do-not-send="true"
href="https://www.enricozini.org/blog/2015/akonadi-install/">Enrico
Zini</a></tt></li>
<li><tt><a
href="https://prkos.hr/KOrganizer-and-Akonadi-Ubuntu-with-Postgres">PrKos.hr</a></tt><tt>:
KOrganizer and AKONADI and PostgreSQL</tt></li>
<li><tt><a moz-do-not-send="true"
href="https://vinzv.de/en/bringing-kmail-and-postgresql-together/">Vinzenz
Vietzke</a></tt><tt>: KMail and PostgreSQL</tt></li>
</ul>
<tt> </tt><tt>Comparing these pages I found differences esp. with
empty definitions in No. 7. This is the comparison and my schedule
now:</tt><tt><br>
</tt><tt> </tt><tt><br>
</tt><tt> 1. Install PostgreSQL</tt><tt><br>
</tt><tt> * OPEN (necessary?): install libQt5Sql5-postgresql [VV]</tt><tt><br>
</tt><tt> * OPEN</tt><tt> (necessary?)</tt><tt>: systemctl enable
--now postgresql [VV]</tt><tt><br>
</tt><tt> 2. Setup myself as PostgrSQL-user</tt><tt> [VV] </tt><tt><tt>[Enrico
Zini]</tt>:<br>
</tt><tt> # su - postgres</tt><tt><br>
</tt><tt> $ createuser <username></tt><tt><br>
</tt><tt> $ psql postgres</tt><tt><br>
</tt><tt> postgres=# alter user <username> createdb;</tt><tt><br>
</tt><tt> postgres=# \q;</tt><tt><br>
# exit<br>
</tt><tt> 3. Transfer my actual databases (schemes / tables etc.)</tt><tt><br>
</tt><tt> 4. Set up an additional database Akonadi using my regular
user account [VV] </tt><tt><tt>[Enrico Zini]</tt>:</tt><tt><br>
</tt><tt> $ createdb Akonadi-<username></tt><tt><br>
</tt><tt> 5. Install akonadi-server akonadi-backend-postgresql
[Enrico Zini] [PrKos]</tt><tt><br>
</tt><tt>6. Stop Akonadi and remove settings (if any) [VV]:</tt><tt><br>
</tt><tt> $ akonadictl stop</tt><tt><br>
</tt><tt> $ rm -rf ~/.local/share/akonadi</tt><tt><br>
</tt><tt>7. Define connection to PostgreSQL-database "Akonadi", e.g.
edit file ~/.config/akonadi/akonadiserverrc [VV]:</tt><tt><br>
</tt><tt> </tt><tt>[%General]</tt><tt><br>
</tt><tt> Driver=QPSQL</tt><tt><br>
<br>
</tt><tt></tt><tt> [QPSQL]</tt><tt><br>
</tt><tt> Host=/tmp/Akonadi-<username>.hash</tt><tt>
OPEN: What means hash? Shall I keep the word or where to find the
value?<br>
Host= </tt><tt><tt>[PrKos]</tt> </tt><tt><tt>[Enrico
Zini]</tt> OPEN: This version or the one above?<br>
</tt><tt> InitDbPath=/usr/bin/initdb</tt><tt><br>
</tt><tt><tt> </tt></tt><tt><tt><tt>InitDbPath=</tt>
</tt><tt><tt>[PrKos]</tt> </tt></tt><tt><tt><tt>[Enrico
Zini]</tt> OPEN: This version or the one above?<br>
</tt> Name=Akonadi<br>
</tt><tt> Name=Akonadi-<username> </tt><tt><tt><tt>
</tt><tt><tt>[PrKos]</tt> </tt></tt></tt><tt><tt><tt><tt>[Enrico
Zini]</tt> OPEN: This version or the one above?</tt></tt></tt><tt><br>
Options=</tt><tt><br>
</tt><tt> ServerPath=/usr/bin/pg_ctl</tt><tt><br>
</tt><tt><tt><tt> </tt></tt><tt><tt><tt>InitDbPath=</tt>
</tt><tt><tt>[PrKos]</tt> </tt></tt></tt><tt><tt><tt><tt>[Enrico
Zini]</tt> OPEN: This version or the one above?<br>
</tt></tt> StartServer=true</tt><tt><br>
</tt><tt><tt><tt><tt> </tt></tt></tt></tt><tt><tt><tt><tt><tt>StartServer</tt></tt></tt><tt><tt><tt>=</tt>false
</tt><tt><tt>[PrKos]</tt> </tt></tt></tt></tt><tt><tt><tt><tt><tt>[Enrico
Zini] </tt>OPEN: This version or the one above?<br>
</tt></tt></tt>The differences with the empty
definitions (</tt><tt><tt>Host, ServerPath, InitDbPath) </tt>seem
to be on purpose, ref. comment </tt><tt><tt><tt><tt><tt>[PrKos]<br>
</tt></tt></tt></tt> Also the Name (add username
after akonadi).<br>
After starting Akonadi service<br>
$ akonadictl start<br>
the configuration file reads with values for the empty
definitions. OPEN: Can anybody confirm this?<br>
8. Restart Akonadi [VV]:<br>
$ akonadictl start<br>
<br>
Any objections or different recommendations? Also I'd appreciate
any response in regards to my lines marked with OPEN.<br>
And what is the easiest way to check the setup, may I use KAlarm
for this?<br>
<br>
Thank you!<br>
<br>
Regards, <br>
Michael<br>
</tt><tt> </tt>
</body>
</html>