[opensuse] switching to postgres96
![](https://seccdn.libravatar.org/avatar/dcb1cafc096989977947ac1b483706a4.jpg?s=120&d=mm&r=g)
I had the following indication from Knurpth: Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql ) Stop akonadi, move ~/.local/share/akonadi so that you can go back Change ~/.config/akonadi/akonadiserverrc like this ============== [Debug] Tracer=null [%General] Driver=QPSQL [QPSQL] Host=/tmp/akonadi-YOURUSERNAME.SOMEHASH InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true ============== Start akonadi and the database will be rebuilt. Took about 20 minutes for 7 IMAP, 1 POP account, total of ~150.000 emails. On Leap you may need some extra KDE Framework lib, but AFAIK that's no longer needed. Now my question was: Referring to:
Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql ) I do not understand this, I do run postgres --config postgresql after having it installed from the terminal?
Postgres96 client or server? I suppose client. Or is it like mythtv that you have to install both on the same machine? I have seen it does draw in forcefully(!) also postgressql10 and and postgresql (version 10 also).
Stop akonadi, move ~/.local/share/akonadi so that you can go back
So is it sufficient to rename it? Or what do you mean with move? BTW why not version 10? Is it known to have problems? _________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postf�cher sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/7491ea623a334fec64fba10b9f1ea62e.jpg?s=120&d=mm&r=g)
On Monday, 16 July 2018 08:27:14 BST stakanov wrote:
I had the following indication from Knurpth: Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql ) Stop akonadi, move ~/.local/share/akonadi so that you can go back Change ~/.config/akonadi/akonadiserverrc like this ============== [Debug] Tracer=null
[%General] Driver=QPSQL
[QPSQL] Host=/tmp/akonadi-YOURUSERNAME.SOMEHASH InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true ============== Start akonadi and the database will be rebuilt. Took about 20 minutes for 7 IMAP, 1 POP account, total of ~150.000 emails. On Leap you may need some extra KDE Framework lib, but AFAIK that's no longer needed.
Now my question was: Referring to:
Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql ) use Yast/Miscellaneous/Alternatives and set the "postgresql" line so it looks like "postgresql /usr/lib/postgresl96 manual" in the window display i.e. highlight it and click edit button - in the "Choice" window i have"/usr/lib/postgresl10 100" "/usr/lib/postgresl96 96"
I do not understand this, I do run postgres --config postgresql after having it installed from the terminal? You can have a look at these sites for assistance, i followed these and got it working. https://www.enricozini.org/blog/2015/akonadi-install/ https://en.opensuse.org/SDB:PostgreSQL Follow "Installation", "Initiating PostgreSQL server" and "Post install configuration" instructions Check .config/akonadi/akonadiserverrc change the line "Driver=QMYSQL" to "Driver=QPSQL"
Postgres96 client or server? I suppose client. Or is it like mythtv that you have to install both on the same machine?
I have seen it does draw in forcefully(!) also postgressql10 and and postgresql (version 10 also).
Stop akonadi, move ~/.local/share/akonadi so that you can go back
So is it sufficient to rename it? Or what do you mean with move? yes, rename is fine
BTW why not version 10? Is it known to have problems? It doesn't seem to work with kmail, not sure why.
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postf�cher sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de
-- opensuse:tumbleweed:20180712 Qt: 5.11.1 KDE Frameworks: 5.47.0 - KDE Plasma: 5.13.2 - kwin 5.13.2 kmail2 5.8.2 - akonadiserver 5.8.2 - Kernel: 4.17.4-1-default - xf86-video-nouveau: 1.0.15 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/dcb1cafc096989977947ac1b483706a4.jpg?s=120&d=mm&r=g)
In data lunedì 16 luglio 2018 11:02:15 CEST, Ianseeks ha scritto:
use Yast/Miscellaneous/Alternatives and set the "postgresql" line so it looks like "postgresql /usr/lib/postgresl96 manual" in the window display i.e. highlight it and click edit button - in the "Choice" window i have"/usr/lib/postgresl10 100" "/usr/lib/postgresl96 96"
Ok, i need more help on this. Where is Yast/miscelanous/Alternative? I have the italian version, so there is: various (is like miscelaneous) inside i have - snapper - systemlog - journal of systemd - cd of the producer. So probably it is not this yast miscelaneous or i have to install some yast package? You speak about yast2 via GUI right? Or are you talking about CLI yast? _________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
On 2018-07-16 13:13, stakanov wrote:
In data lunedì 16 luglio 2018 11:02:15 CEST, Ianseeks ha scritto:
use Yast/Miscellaneous/Alternatives and set the "postgresql" line so it looks like "postgresql /usr/lib/postgresl96 manual" in the window display i.e. highlight it and click edit button - in the "Choice" window i have"/usr/lib/postgresl10 100" "/usr/lib/postgresl96 96"
Ok, i need more help on this. Where is Yast/miscelanous/Alternative? I have the italian version, so there is: various (is like miscelaneous) inside i have - snapper - systemlog - journal of systemd - cd of the producer.
So probably it is not this yast miscelaneous or i have to install some yast package? You speak about yast2 via GUI right? Or are you talking about CLI yast?
It is an addition to yast, you probably need to install it. I'll try on my laptop. I'm accessing remotely over 1 meter away ;-), so using ssh: cer@Telcontar:~> ssh -X root@Legolas.valinor Last login: Sun Jul 15 23:56:22 2018 from 192.168.1.14 Have a lot of fun... Legolas:~ # And then, I'll use zypper to search for the package; I already had a guess at the name. First I tried "yast-*", failed. Then "yast*", too many, but it was already there. So finally: Legolas:~ # zypper se yast2-a* Loading repository data... Reading installed packages... S | Name | Summary | Type --+--------------------+------------------------------------------+-------- i | yast2-add-on | YaST2 - Add-On media installation code | package | yast2-alternatives | YaST2 - Manage Update-alternatives swi-> | package i | yast2-apparmor | YaST2 - Plugins for AppArmor Profile M-> | package | yast2-audit-laf | YaST2 - Configuration of Linux Auditin-> | package i | yast2-auth-client | YaST2 - Centralised System Authenticat-> | package i | yast2-auth-server | A tool for creating identity managemen-> | package Legolas:~ # So, I need "yast2-alternatives". I'll install it with zypper, but can be don just fine with yast. Legolas:~ # zypper install yast2-alternatives Loading repository data... Reading installed packages... Resolving package dependencies... The following NEW package is going to be installed: yast2-alternatives 1 new package to install. Overall download size: 20.4 KiB. Already cached: 0 B. After the operation, additional 36.2 KiB will be used. Continue? [y/n/...? shows all options] (y): y Retrieving package yast2-alternatives-4.0.0-lp150.1.1.x86_64 (1/1), 20.4 KiB ( 36.2 KiB unpacked) Retrieving: yast2-alternatives-4.0.0-lp150.1.1.x86_64.rpm ...........[done] Checking for file conflicts: ........................................[done] (1/1) Installing: yast2-alternatives-4.0.0-lp150.1.1.x86_64 .........[done] Legolas:~ # I fire up yast, in text mode so that I can paste it here: YaST2 - menu @ Legolas.valinor ┌────────────────────────────────────────────────────────────────────┐ │ YaST Control Center │ └────────────────────────────────────────────────────────────────────┘ ┌───────────────────┐ ┌───────────────────────────────────────────────┐ │Software │ │Alternatives │ │System │ │Snapper │ │Hardware │ │System Log │ │Network Services │ │Systemd Journal │ │Security and Users │ │Vendor Driver CD │ │Support │ │ │ │Miscellaneous │ │ │ │ │ │ │ See? "Alternatives" is there. In my case, selecting it I see: YaST2 - alternatives @ Legolas.valinor Search by name ▒▒▒▒▒▒▒▒▒▒▒▒▒▒ [x] Show only alternatives with more than one choice ┌───────────────────────────────────────────────────────────────────────┐ │Name │Current choice │Status │ │dbus-launch │/usr/bin/dbus-launch.x11 │auto │ │default-displaymanager │/usr/lib/X11/displaymanagers/gdm │auto │ │default-xsession.desktop│/usr/share/xsessions/gnome.desktop│auto │ │easy_install │/usr/bin/easy_install-3.6 │auto │ │ftp │/usr/bin/tnftp │auto │ │gtk-update-icon-cache │/usr/bin/gtk-update-icon-cache-3.0│auto │ │ │ -- Cheers / Saludos, Carlos E. R. (from 42.3 x86_64 "Malachite" at Telcontar)
![](https://seccdn.libravatar.org/avatar/7491ea623a334fec64fba10b9f1ea62e.jpg?s=120&d=mm&r=g)
On Monday, 16 July 2018 12:13:24 BST stakanov wrote:
In data lunedì 16 luglio 2018 11:02:15 CEST, Ianseeks ha scritto:
use Yast/Miscellaneous/Alternatives and set the "postgresql" line so it looks like "postgresql /usr/lib/postgresl96 manual" in the window display i.e. highlight it and click edit button - in the "Choice" window i have"/usr/lib/postgresl10 100" "/usr/lib/postgresl96 96"
Ok, i need more help on this. Where is Yast/miscelanous/Alternative? I have the italian version, so there is: various (is like miscelaneous) inside i have - snapper - systemlog - journal of systemd - cd of the producer.
So probably it is not this yast miscelaneous or i have to install some yast package? You speak about yast2 via GUI right? Or are you talking about CLI yast?
Yes, as Carlos pointed out, it looks like you have to install alternatives and then it should appear in Yast. There is also a CLI version.
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de
-- opensuse:tumbleweed:20180712 Qt: 5.11.1 KDE Frameworks: 5.47.0 - KDE Plasma: 5.13.2 - kwin 5.13.2 kmail2 5.8.2 - akonadiserver 5.8.2 - Kernel: 4.17.4-1-default - xf86-video-nouveau: 1.0.15 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/ec2e857562f9e94f420a54d9a7ce8d79.jpg?s=120&d=mm&r=g)
Op maandag 16 juli 2018 09:27:14 CEST schreef stakanov:
I had the following indication from Knurpth: Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql ) Stop akonadi, move ~/.local/share/akonadi so that you can go back Change ~/.config/akonadi/akonadiserverrc like this ============== [Debug] Tracer=null
[%General] Driver=QPSQL
[QPSQL] Host=/tmp/akonadi-YOURUSERNAME.SOMEHASH InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true ============== Start akonadi and the database will be rebuilt. Took about 20 minutes for 7 IMAP, 1 POP account, total of ~150.000 emails. On Leap you may need some extra KDE Framework lib, but AFAIK that's no longer needed.
Now my question was:
Referring to:
Install postgresql 9.6 ( not 10, if that's installed use update-alternatives --config postgresql )
I do not understand this, I do run postgres --config postgresql after having it installed from the terminal?
Postgres96 client or server? I suppose client. Or is it like mythtv that you have to install both on the same machine?
I have seen it does draw in forcefully(!) also postgressql10 and and postgresql (version 10 also).
Stop akonadi, move ~/.local/share/akonadi so that you can go back
So is it sufficient to rename it? Or what do you mean with move?
BTW why not version 10? Is it known to have problems?
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postf�cher sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de Yep, installing 'postgresql' installs both 9.6 and 10. So you need to run
update-alternatives --config postgresql and set it to 96. That's all IIRC -- Gertjan Lettink a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/dcb1cafc096989977947ac1b483706a4.jpg?s=120&d=mm&r=g)
In data lunedì 16 luglio 2018 16:08:22 CEST, Knurpht-openSUSE ha scritto:
Yep, installing 'postgresql' installs both 9.6 and 10. So you need to run
update-alternatives --config postgresql and set it to 96. That's all IIRC
Sorry if I appear tarded, but one speaks about yast...and this looks like a cli command. Is this cli or is this in yast. Then I think I am close to a solution here. I guess I have to run: sudo update-alternatives --config postgresql from the command line. Right? _________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/ec2e857562f9e94f420a54d9a7ce8d79.jpg?s=120&d=mm&r=g)
Op maandag 16 juli 2018 18:32:45 CEST schreef stakanov:
In data lunedì 16 luglio 2018 16:08:22 CEST, Knurpht-openSUSE ha scritto:
Yep, installing 'postgresql' installs both 9.6 and 10. So you need to run
update-alternatives --config postgresql and set it to 96. That's all IIRC
Sorry if I appear tarded, but one speaks about yast...and this looks like a cli command. Is this cli or is this in yast.
Then I think I am close to a solution here. I guess I have to run: sudo update-alternatives --config postgresql from the command line. Right?
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de That's in cli, as root. So, after stopping akonadi, and the backup of the mysql database, local-mail, changing the akonadiserverrc, etc etc.
su zypper in libQt5Sql5-postgresql # or the equivalent for your Leap version zypper in postgresql96-server update-alternatives --config postgresql # choose the option for 96 systemctl enable postgresql.service systemctl start postgresql.service exit As user akonadictl start -- Gertjan Lettink a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/7491ea623a334fec64fba10b9f1ea62e.jpg?s=120&d=mm&r=g)
On Monday, 16 July 2018 17:32:45 BST stakanov wrote:
In data lunedì 16 luglio 2018 16:08:22 CEST, Knurpht-openSUSE ha scritto:
Yep, installing 'postgresql' installs both 9.6 and 10. So you need to run
update-alternatives --config postgresql and set it to 96. That's all IIRC
Sorry if I appear tarded, but one speaks about yast...and this looks like a cli command. Is this cli or is this in yast. There is a GUI version in Yast and there is also a CLI version
Then I think I am close to a solution here. I guess I have to run: sudo update-alternatives --config postgresql from the command line. Right?
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de
-- opensuse:tumbleweed:20180712 Qt: 5.11.1 KDE Frameworks: 5.47.0 - KDE Plasma: 5.13.2 - kwin 5.13.2 kmail2 5.8.2 - akonadiserver 5.8.2 - Kernel: 4.17.4-1-default - xf86-video-nouveau: 1.0.15 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (4)
-
Carlos E. R.
-
Ianseeks
-
Knurpht-openSUSE
-
stakanov