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

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

From
ramesh penumalli
Date:
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
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.

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

From
Ramesh Penuballi
Date:
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.
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@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.

--
Angular momentum makes the world go 'round.

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

From
Ramesh Penuballi
Date:
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, <ronljohnsonjr@gmail.com> 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 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@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.

--
Angular momentum makes the world go 'round.

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

From
Ramesh Penuballi
Date:
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 installed, the job is running successfully to take the backup of our production  server where postgresql is running on the separate RHEL7 instance after running psql, and pg_dump commands. 

But the issue is that the jenkins  job is failing when we tried to perform the restore activity from prod to stage environments.

Do you have any idea where to check the locations where postgresql path in Linux to compare the same prod and stage environments. 

Thanks and Regards 
Ramesh Penuballi 



On Fri, 17 Jan, 2020, 18:52 Ramesh Penuballi, <ramesh.252@gmail.com> wrote:
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, <ronljohnsonjr@gmail.com> 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 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@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.

--
Angular momentum makes the world go 'round.
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 might be the reason that Jenkins and Postgresql services are running in two separate Linux  instances.

From the  Linux server  where JENKINS installed, the job is running successfully to take the backup of our production  server where postgresql is running on the separate RHEL7 instance after running psql, and pg_dump commands. 

But the issue is that the jenkins  job is failing when we tried to perform the restore activity from prod to stage environments.

Do you have any idea where to check the locations where postgresql path in Linux to compare the same prod and stage environments. 

Thanks and Regards 
Ramesh Penuballi 



On Fri, 17 Jan, 2020, 18:52 Ramesh Penuballi, <ramesh.252@gmail.com> wrote:
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, <ronljohnsonjr@gmail.com> 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 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@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.

--
Angular momentum makes the world go 'round.

--
Angular momentum makes the world go 'round.

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

From
Ramesh Penuballi
Date:
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, <ramesh.252@gmail.com> 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 might be the reason that Jenkins and Postgresql services are running in two separate Linux  instances.

From the  Linux server  where JENKINS installed, the job is running successfully to take the backup of our production  server where postgresql is running on the separate RHEL7 instance after running psql, and pg_dump commands. 

But the issue is that the jenkins  job is failing when we tried to perform the restore activity from prod to stage environments.

Do you have any idea where to check the locations where postgresql path in Linux to compare the same prod and stage environments. 

Thanks and Regards 
Ramesh Penuballi 



On Fri, 17 Jan, 2020, 18:52 Ramesh Penuballi, <ramesh.252@gmail.com> wrote:
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, <ronljohnsonjr@gmail.com> 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 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@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.

--
Angular momentum makes the world go 'round.