Re: Using pg_dump in a cron

Thanks Tom,

You are absolutely right, the commandt stty istrip was the first line of my
.profile...

Regards,
Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
Sent: jeudi 2 juin 2005 18:07
To: Patrick(dot)FICHE(at)aqsacom(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Using pg_dump in a cron

Patrick(dot)FICHE(at)AQSACOM(dot)COM writes:
> The dump execution is OK but my user gets a mail containing the =
> following
> message :
>
> Your "cron" job on ALIS
> . $HOME/.profile; pg_dump alis -U postgres -f
> $AQSADIR/data/backup/alis_data.sql -a -d >/dev/null 2>&1
>
> produced the following output:
>
> stty: : No such device or address

> What's wrong with it ?

My bet is the .profile file contains a call of stty ... and of course
stdin is going to be pointing somewhere else than a terminal ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend