On 3/29/19 12:42 PM, John M Knoeller wrote: > If it is not a shell script, then > /bin/sh /usr/pgsql-10/bin/psql > > is expected to fail. > > Why it doesn't work when you tell HTCondor that /usr/pgsql-10/bin/psql is the executable, > my best guess is that the environment is different between running the program yourself > and running as a local universe job. > > try adding > > setenv = true > > to your submit file. That will take pass the environment at submit time into the local universe job. with > universe = LOCAL > executable = /usr/bin/psql > arguments = "-d bmrbeverything -U postgres -f /websites/webapi/wsgi/releases/v2/server/wsgi/utils/sql/initialize.sql" > setenv = TRUE ... I get > could not find a "condor_exec.exe" to execute > could not find a "condor_exec.exe" to execute > condor_exec.exe: could not find own program executable However with > universe = LOCAL > executable = /bin/sh > arguments = "-c '/usr/bin/psql -d bmrbeverything -U postgres -f /websites/webapi/wsgi/releases/v2/server/wsgi/utils/sql/initialize.sql' " > setenv = TRUE it runs. So there is some shell magic involved in postgres... -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
Attachment:
signature.asc
Description: OpenPGP digital signature