<div>
Did you run your script at linux shell directly and successfully ?<br />
<br />
If yes, maybe you need to add it in your script<br />
<br />
PATH=&quot;/bin:/sbin:/usr/bin:<wbr />/usr/sbin:<wbr />/opt/usr/b<wbr />in:/opt/us<wbr />r/sbin:/us<wbr />r/local/bi<wbr />n:/usr/loc<wbr />al/sbin;<br />
/yourscriptlocation;&quot; &nbsp; which is just example only<br />
<br />
and it might also need to do &nbsp;&quot; chmod 755 yourscript&quot;<br />
<br />
Hope understand your question completely, if not , please point it out<br />
<br />
Duncan
</div>


Did you run your script at linux shell directly and successfully ?

If yes, maybe you need to add it in your script

PATH="/bin:/sbin:/usr/bin:/usr/sbin:/opt/usr/bin:/opt/usr/sbin:/usr/local/bin:/usr/local/sbin;
/yourscriptlocation;"   which is just example only

and it might also need to do  " chmod 755 yourscript"

Hope understand your question completely, if not , please point it out

Duncan

<div>
Hi, <br />
maybe this help you: <br />
<br />
su postgres -c &quot;&nbsp;your command eq. bash script &quot;<br />
<br />
or <br />
<br />
sudo su postgres -c &quot;your commend &nbsp;... &quot;
</div>


Hi,
maybe this help you:

su postgres -c " your command eq. bash script "

or

sudo su postgres -c "your commend  ... "

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I need to run some script over my Postgres database by postgres user. So, I have set a cron tab to execute it for every 5 minutes.<br />
<br />

<pre><code id="code-10-28305946-1">*/5 * * * * /folder/script1 -m srv1:5432 -s srv2:5432 -b /usr/lib/postgresql/9.2/bin</code></pre>
<br />
script1=the file containing my script<br />
<br />
But its not running. I can't root's crontab since it's not allowed in Postgres service.<br />
<br />
Can you kindly help me on this and thanks a lot for your time !
</div>
</div>


Hi Experts,

I need to run some script over my Postgres database by postgres user. So, I have set a cron tab to execute it for every 5 minutes.

(CODE)

script1=the file containing my script

But its not running. I can't root's crontab since it's not allowed in Postgres service.

Can you kindly help me on this and thanks a lot for your time !

Runing crontab jobs for postgres user ?

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.