Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Ron <ronljohnsonjr@xxxxxxxxx> · Fri, 17 Jan 2020 07:13:02 -0600



    The Jenkins server needs to be able to find the Unix executables
    dropdb, createdb and psql.

    
    I don't know anything about Jenkins, or even whether or not
    Jenkins runs on the same box as Postgres, but there's some
    shell script somewhere that points $PATH to the proper
    Postgres binaries.

    
    On 1/17/20 6:56 AM, Ramesh Penuballi
      wrote:

    
        Dear Ron, 
        

        Thanks for looking into this query. 
        

        Could you please let me know how can I check the
          same. 
        

        We are able take our production backup  from
          the  Jenkins server, and the issue is with our uat database
          server only. 
        

        Could you please let me know how to check the
          path on Jenkins server as I am new to Jenkins. 
        

        Thanks and Regards 
        Ramesh Penuballi 

          
            On Fri, 17 Jan, 2020,
              17:53 Ron, <ronljohnsonjr@xxxxxxxxx>
              wrote:

            
               Does the Jenkins' $PATH variable have the Postgres
                binaries' location?

                
                On 1/17/20 2:47 AM, ramesh penumalli wrote:

                
                  Dear Team,
                    

                    I am using postgresql 9.2.12 version and I am
                      facing  an issue while running the executing the
                      commands createdb,dropdb,psql commands in the
                      shell script which is running from Jenkins to
                      restore prod data into stage environment.
                    

                    Jenkins job is failing with the below output.I
                      have verified the script and the scrit is fine and
                      it seems to be an issue with the configuration of
                      postgresql  and not sure where to make the
                      changes.
                    

                      line 48: dropdb: command not found
                      line 50: createdb: command not found
line 52: psql: command not found
Kindly guide me to rectify the issue.
Thanks and Regards,
Ramesh
                    
                  
                -- 

                  Angular momentum makes the world go 'round.
              
            
    -- 

      Angular momentum makes the world go 'round.