Feature Wiki

Information about planned and released features

Reiter

PostgreSQL Support

1 Description

ILIAS should support PostgreSQL.
 
Alex, 26 Dec 2011: I have added experimental support and managed to get an ILIAS installation running on PostgreSQL. Please check out the SVN trunk an try it. If you would like to help testing this, please drop a message below in the "Discussion" area.

2 Status

  • If you want to know more about this feature, its implementation or funding, please contact: alex.killing (at) gmx.de

3 Additional Information

Installing PostgreSQL
 
Here are some installation hints for building and installing Postgres. They are written for Snow Leopard, but the basic steps are the same on any Unix-like system.
 
 
PHP PostgreSQL support
 
You need to build PHP with postgres support. If you build PHP from scratch you need to add something like '--with-pgsql=/usr/local/pgsql' to your configure script.
 
 
ILIAS setup
 
Use your postgres user to create a database:
> createdb ilias
 
Now create a new ILIAS client and select "Postgres" as database type. The other setup steps should work like usual.
 
 
Converting MySQL to PostgreSQL 
 
Performance Scalability
 
We currently have no idea how good/bad the ILIAS performance will be. Also it would be interesting how scalability can be achieved. Add any information/links related to these topics here.

4 Discussion

Matthias Kunkel, 05 Jan 2012: I strongly support this suggestion as it would gives us independence from Oracle's database products (Oracle and MySQL).

JF 6 Feb 2012: We highly appreciate the idea.

5 Follow-Up

Zuletzt geändert: 17. Apr 2025, 15:06, Kunkel, Matthias [mkunkel]