Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script - Mailing list pgsql-general

From Ramesh Penuballi
Subject Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script
Date
Msg-id CAGeQtUt=f57_nOp++Ob5yA=nffZkTpSBUezWhNp+1xq=_iNAaQ@mail.gmail.com
Whole thread Raw
In response to Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script
List pgsql-general
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@gmail.com> 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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script
Next
From: Ron
Date:
Subject: Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script