opsi with Postgresql as backend?

ruch
Beiträge: 9
Registriert: 21 Feb 2014, 01:09

opsi with Postgresql as backend?

Beitrag von ruch »

Is there a way to use Postgresql as backend instead of Mysql?

Thanks!
Benutzeravatar
wolfbardo
uib-Team
Beiträge: 1412
Registriert: 01 Jul 2008, 12:10

Re: opsi with Postgresql as backend?

Beitrag von wolfbardo »

At the moment not.

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


Benutzeravatar
SisterOfMercy
Beiträge: 1556
Registriert: 22 Jun 2012, 19:18

Re: opsi with Postgresql as backend?

Beitrag von SisterOfMercy »

ruch hat geschrieben:Is there a way to use Postgresql as backend instead of Mysql?
You can use MariaDB instead of MySQL, if you're not very happy with MySQL at the moment (with obstacle molesting it, etc.)
Of course this hasn't been tested thoroughly, and is not supported. But it works for me. :D
Bitte schreiben Sie Deutsch, when I'm responding in the German-speaking part of the forum!
ruch
Beiträge: 9
Registriert: 21 Feb 2014, 01:09

Re: opsi with Postgresql as backend?

Beitrag von ruch »

Thanks for the reply, has anyone tired it with sqllite?
Benutzeravatar
n.wenselowski
Ex-uib-Team
Beiträge: 3194
Registriert: 04 Apr 2013, 12:15

Re: opsi with Postgresql as backend?

Beitrag von n.wenselowski »

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

Code: Alles auswählen

import OPSI
ruch
Beiträge: 9
Registriert: 21 Feb 2014, 01:09

Re: opsi with Postgresql as backend?

Beitrag von ruch »

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!
Benutzeravatar
n.wenselowski
Ex-uib-Team
Beiträge: 3194
Registriert: 04 Apr 2013, 12:15

Re: opsi with Postgresql as backend?

Beitrag von n.wenselowski »

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

Code: Alles auswählen

import OPSI
Benutzeravatar
n.wenselowski
Ex-uib-Team
Beiträge: 3194
Registriert: 04 Apr 2013, 12:15

Re: opsi with Postgresql as backend?

Beitrag von n.wenselowski »

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

Code: Alles auswählen

import OPSI
dkoch
Beiträge: 309
Registriert: 25 Nov 2011, 14:03

Re: opsi with Postgresql as backend?

Beitrag von dkoch »

denmarknian
Beiträge: 34
Registriert: 16 Mai 2014, 21:45

Re: opsi with Postgresql as backend?

Beitrag von denmarknian »

can I convert back to file-based if I convert to postgres? just a back-out plan. thank you.
Antworten