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

2020-01-20 Thread Ramesh Penuballi
Hi Ron, Issue has been resolved after checking the postgresql connector installation location on the Jenkins server. Thank you so much for you help and looking into the issue. Thanks and Regards Ramesh Penuballi On Mon, 20 Jan, 2020, 11:30 Ramesh Penuballi, wrote: > Hi Ron, > > I have checke

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

2020-01-20 Thread Ron
Where is JENKINS installed, and where is Postgres installed?  Are they on the same server? On 1/20/20 12:00 AM, Ramesh Penuballi wrote: Hi Ron, I have checked on my Jenkins server.bashrc and. bashprofiles filed of root and Jenkins users but  didn't find anything about postgresql path. It mig

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

2020-01-19 Thread Ramesh Penuballi
Hi Ron, I have checked on my Jenkins server.bashrc and. bashprofiles filed of root and Jenkins users but didn't find anything about postgresql path. It might be the reason that Jenkins and Postgresql services are running in two separate Linux instances. >From the Linux server where JENKINS in

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

2020-01-17 Thread Ramesh Penuballi
Thanks once again for sharing the info. Let me check and get back to you. Thanks and Regards Ramesh Penuballi On Fri, 17 Jan, 2020, 18:43 Ron, wrote: > The Jenkins server needs to be able to find the Unix executables dropdb, > createdb and psql. > > I don't know *anything* about Jenkins, or eve

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

2020-01-17 Thread Ron
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. O

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

2020-01-17 Thread Ramesh Penuballi
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

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

2020-01-17 Thread Ron
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 runn

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

2020-01-17 Thread ramesh penumalli
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 verif