Re: Database update problem from crontab on ubuntu server

--Signature=_Fri__18_Apr_2008_10_46_00_+1200_9G6g6pzpOxiQdlhj
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, 18 Apr 2008 00:21:23 +0400
David Jorjoliani <djorj@[EMAIL PROTECTED]
> wrote:

> Hi,
>=20
> I have daily cron jobs for database update, which where working fine on
> Fedore Core 6. No I move it on Ubuntu Server 7.10 and postgres gives
erro=
r:
>=20
> "unexpected EOF on client connection"
>=20
> while update running from cron. If I run this update manually from root
> user - it works fine. Here is update command:
>=20
> su -l postgres -c "gunzip -c /backup/rms.gz | psql rms"
>=20
> Can somebody give any suggestion?
>=20
> Thanks,
> David
>=20
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In crontab you have almost no $PATH set up by default. My expectation is
th=
at it can't find gunzip. Try either setting the PATH in the script, or
usin=
g the full pathname of gunzip instead...

Cheers,

Steve

--Signature=_Fri__18_Apr_2008_10_46_00_+1200_9G6g6pzpOxiQdlhj
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIB9MoDN07rEXM5z0RAsLzAJ9bXPHoYd04Ty/sb9bwVt97QVAu6gCgusBN
IZsXG/QBkUGbcr7vf1Xeqbs=
=aNbu
-----END PGP SIGNATURE-----

--Signature=_Fri__18_Apr_2008_10_46_00_+1200_9G6g6pzpOxiQdlhj--