Seite 1 von 2
opsi with Postgresql as backend?
Verfasst: 21 Feb 2014, 17:42
von ruch
Is there a way to use Postgresql as backend instead of Mysql?
Thanks!
Re: opsi with Postgresql as backend?
Verfasst: 21 Feb 2014, 18:23
von wolfbardo
At the moment not.
regards,
bardo wolf
Re: opsi with Postgresql as backend?
Verfasst: 24 Feb 2014, 13:58
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.

Re: opsi with Postgresql as backend?
Verfasst: 24 Feb 2014, 22:08
von ruch
Thanks for the reply, has anyone tired it with sqllite?
Re: opsi with Postgresql as backend?
Verfasst: 25 Feb 2014, 09:55
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
Re: opsi with Postgresql as backend?
Verfasst: 25 Feb 2014, 19:58
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!
Re: opsi with Postgresql as backend?
Verfasst: 26 Feb 2014, 12:45
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
Re: opsi with Postgresql as backend?
Verfasst: 04 Mär 2014, 11:09
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
Re: opsi with Postgresql as backend?
Verfasst: 18 Mai 2014, 22:54
von dkoch
Re: opsi with Postgresql as backend?
Verfasst: 24 Aug 2014, 14:06
von denmarknian
can I convert back to file-based if I convert to postgres? just a back-out plan. thank you.