opsi with Postgresql as backend?
opsi with Postgresql as backend?
Is there a way to use Postgresql as backend instead of Mysql?
Thanks!
Thanks!
Re: opsi with Postgresql as backend?
At the moment not.
regards,
bardo wolf
regards,
bardo wolf
Vielen Dank für die Nutzung von opsi. Im Forum ist unser Support begrenzt.
Für den professionellen Einsatz und individuelle Beratung empfehlen wir einen Support-Vertrag und eine Schulung.
Gerne informieren wir Sie zu unserem Angebot.
uib GmbH
Telefon: +49 6131 27561 0
E-Mail: sales@uib.de
- SisterOfMercy
- Beiträge: 1556
- Registriert: 22 Jun 2012, 19:18
Re: opsi with Postgresql as backend?
You can use MariaDB instead of MySQL, if you're not very happy with MySQL at the moment (with obstacle molesting it, etc.)ruch hat geschrieben:Is there a way to use Postgresql as backend instead of Mysql?
Of course this hasn't been tested thoroughly, and is not supported. But it works for me.

Bitte schreiben Sie Deutsch, when I'm responding in the German-speaking part of the forum!
Re: opsi with Postgresql as backend?
Thanks for the reply, has anyone tired it with sqllite?
- n.wenselowski
- Ex-uib-Team
- Beiträge: 3194
- Registriert: 04 Apr 2013, 12:15
Re: opsi with Postgresql as backend?
Hello ruch,
the SQLite-Backend does not support all the actions supported by the "normal" SQL backend. This probably won't work.
Are you just looking for alternative backend databases or do you want to avoid using MySQL?
King regards
Niko
the SQLite-Backend does not support all the actions supported by the "normal" SQL backend. This probably won't work.
Are you just looking for alternative backend databases or do you want to avoid using MySQL?
King regards
Niko
Code: Alles auswählen
import OPSI
Re: opsi with Postgresql as backend?
Thanks for the reply. We typically use postgres and sqllite that's the reason I was asking. I guess for now I can use MySql and may be later if it works with other databases I can switch.
Thanks, I appreciate your help!
Thanks, I appreciate your help!
- n.wenselowski
- Ex-uib-Team
- Beiträge: 3194
- Registriert: 04 Apr 2013, 12:15
Re: opsi with Postgresql as backend?
Hello ruch,
I just did a quick search and saw that Posgres seems to work pretty well with JSON. JSON is what we use to communicate between our services.
In some days you should find the new source under svn.opsi.org and this will bring some unittests that are made for developing different OPSI backends. If you want to spend some time you could try to implement your own Postgres backend.
Kind regards
Niko
I just did a quick search and saw that Posgres seems to work pretty well with JSON. JSON is what we use to communicate between our services.
In some days you should find the new source under svn.opsi.org and this will bring some unittests that are made for developing different OPSI backends. If you want to spend some time you could try to implement your own Postgres backend.
Kind regards
Niko
Code: Alles auswählen
import OPSI
- n.wenselowski
- Ex-uib-Team
- Beiträge: 3194
- Registriert: 04 Apr 2013, 12:15
Re: opsi with Postgresql as backend?
Hello ruch,
if you are still looking for alternatives, you can find a backend that uses MongoDB on Github: https://github.com/dheid/opsi_mongodb/
This is not officially supported by uib.
With kind regards
Niko
if you are still looking for alternatives, you can find a backend that uses MongoDB on Github: https://github.com/dheid/opsi_mongodb/
This is not officially supported by uib.
With kind regards
Niko
Code: Alles auswählen
import OPSI
-
- Beiträge: 34
- Registriert: 16 Mai 2014, 21:45
Re: opsi with Postgresql as backend?
can I convert back to file-based if I convert to postgres? just a back-out plan. thank you.