Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

(Probably irrelevant) I'm using Puppet to setup/manage a class of computers that are equipped with PostgreSQL and PostGIS, and this implies that each computer goes through an unattended install:

PostgreSQL

command     => '/bin/mount -o remount exec /tmp                ;
                /bin/mkdir -m 0755 -p /opt/PostgreSQL/9.1      ;
                /tmp/setup/postgres-9.1.4.run                  \
                  --mode unattended                            \
                  --superaccount postgres                      \
                  --superpassword sUP34_se<uR3^P4sSw0rd        \
                  --datadir /opt/PostgreSQL/9.1/data           \
                  --locale 1                                   ;
                /bin/mount -o remount /tmp                     ;
                /bin/touch $installflag',

I should mention that, even though the install succeeds (exit code 0, at least), PostgreSQL does not appear under Applications.

PostGIS

command     => '/bin/mount -o remount exec /tmp      ;
                /tmp/setup/postgis-1.5.bin           \
                  --mode unattended                  \
                  --pgport 5432                      \
                  --pguser postgres                  \
                  --pgpassword sUP34_se<uR3^P4sSw0rd ;
                /bin/mount -o remount /tmp',

When I now attempt to run /opt/PostgreSQL/9.1/bin/pgAdmin3 --version, I receive the following error (formatting added):

./pgAdmin3: error while loading shared libraries: 
            libwx_gtk2u_stc-2.8.so.0: 
            cannot open shared object file: 
            No such file or directory

running locate libwx_gtk2u gives me the path /opt/PostgreSQL/9.1/pgAdmin3/lib as its location, so following the advice of a forum post, I alter LD_LIBRARY_PATH, previously empty, to be

export LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/pgAdmin3/lib

which only spits out another error:

pgAdmin3: error while loading shared libraries:
          libssl.so.1.0.0:
          cannot open shared object file:
          No such file or directory

I'm out of both ideas and pages of Google search results.

I am running Red Hat Enterprise Linux 5 x86_64.

share|improve this question
    
Is it a typo, or the location is really in the pgAdmib3 folder? That is, do you really have a /opt/PostgreSQL/9.1/pgAdmib3 and a /opt/PostgreSQL/9.1/pgAdmin3 folder? –  dezso Jun 18 '13 at 21:00
    
@dezso Nice catch; edited –  Sean Allred Jun 18 '13 at 21:03
1  
The solution with LD_LIBRARY_PATH should work. Make sure it's an environment variable, as opposed to a simple variable that is not inherited by child processes. –  Daniel Vérité Jun 19 '13 at 15:49
    
@DanielVérité, I get another error when I ensure it's an environment variable, so progress? I'll edit my Q. –  Sean Allred Jun 19 '13 at 19:30
    
So other shared libraries are missing. ldd ./pgAdmin3 can be used to list all of them. libssl should be provided by openssl that you want to install as an OS package. –  Daniel Vérité Jun 19 '13 at 20:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.