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

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(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)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.
>

--
Angular momentum makes the world go 'round.