forum.opsi.org

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

Thanks!

At the moment not.

regards,
bardo wolf

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.

Thanks for the reply, has anyone tired it with sqllite?

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

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!

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

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

https://github.com/kochd/opsi-postgres

Give it a try

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