Hello list,
What are your experiences with OpenSCG’s RPM packages? It is my impression that those packages allow vanilla PostgreSQL to run, but trying to build extensions such as PostGIS against them fails in most (two out of three) cases due to problems with the included shared libraries.
The “two out of three cases” means that I tried three of their packages, then basically gave up on those OpenSCG packages as one “builds out of the box” success out of three seemed a bit on the low side. Is that “success rate” about correct, or could I have picked the only two packages with such problems?
Of course, OpenSCG’s “selling points” (packages have been relocatable since around 2011, and are largely independent of the Linux distribution due to extra libraries supplied) did sound good, so you might still consider OpenSCG’s packages if you just want to run “vanilla” PostgreSQL.
As I mentioned, in one case building PostGIS against the installed PostgreSQL worked out of the box; in one case building a PostGIS extension didn’t work against the libraries supplied by OpenSCG, but after copying around some system libraries things both built and ran fine; one case was even weirder in that an initial build succeeded but produced a shared library that would error out at run time, and copying over some system libraries resulted in a state in which the build succeeded AND produced a working shared library (see the earlier discussion about that weird case:
http://www.postgresql.org/message-id/C5DBACC6DCC7604C9E4875FD9C7968B1129DF47A16@ITXS01EVS.service.it.nrw.de; it was compounded by the problem that just copying over just one system library didn’t work at all, and as it turned out, I also needed to copy over a dependency).
Figuring out which system libraries to copy over can be sort of fun if you have a little development background, but database administrators may shy away from copying bunches of shared libraries around. What could be going wrong here? How can a shared library allow things to run fine but prevent things from building against it?
Holger Friedrich