------=_Part_19306_19457845.1211836701968
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hi,
I've been trying to run a shell script that, among other things, invokes
some sql scripts as user postgres with cron. First, I found that as cron
doesn't inherit the environment variables that are defined in the
script, i.e. the path to some of the scripts, I had to declare them
globally. But when I've done this, it seems that cron is not able to run
this script as postgres user. (all of this under Debian Etch)
In every forum or webpage where I look at, it seems that it has to be
run as root to work....but how can it work running it as root if the
user to run the sql scripts and access the database has to be
postgres??
What am I missing?
Thanks in advance for your help.
--=20
Josep S=E0nchez
[papapep]
-------------------------------------------------
http://extralinux.net
-------------------------------------------------
------=_Part_19306_19457845.1211836701968
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hi,<br><br>I've been trying to run a shell script that, among other
thi=
ngs, invokes<br>some sql scripts as user postgres with cron. First, I
found=
that as cron<br>doesn't inherit the environment variables that are
def=
ined in the<br>
script, i.e. the path to some of the scripts, I had to declare
them<br>glob=
ally. But when I've done this, it seems that cron is not able to
run<br=
>this script as postgres user. (all of this under Debian Etch)<br>In every
=
forum or webpage where I look at, it seems that it has to be<br>
run as root to work....but how can it work running it as root if
the<br>use=
r to run the sql scripts and access the database has to
be<br>postgres??<br=
><br>What am I missing?<br><br>Thanks in advance for your help.<br><br
clea=
r=3D"all">
<br>-- <br>Josep
S=E0nchez<br>[papapep]<br>--------------------------------=
-----------------<br><a
href=3D"http://extralinux.net">http://extralinux.ne=
t</a><br>-------------------------------------------------
------=_Part_19306_19457845.1211836701968--
|
