Dear Remi, thank you for your response.
On sepal, each user has their own platform, right? So the risk is only messing up their own "instance"... it is question whether this protection over-weights limits in installation of SW from rich open source repositories... For example rus-copernicus.eu gives possibility to install software using sudo (see chapter 6.2 Software and library installation).
Regarding PostgreSQL this packages could be beneficial:
- PostgreSQL (maybe from pgdg repo?)
- PostGIS (extension enabling spatial data types)
- some procedural languages: plr, plpythonu
Maybe some users would like to install other extensions or manage their own development with extension mechanism, but for that is is necessary to do "sudo make install".