Thanks Tom, You are absolutely right, the commandt stty istrip was the first line of my .profile... Regards, Patrick ---------------------------------------------------------------------------- --------------- Patrick Fiche email : patrick.fiche@xxxxxxxxxxx tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Tom Lane Sent: jeudi 2 juin 2005 18:07 To: Patrick.FICHE@xxxxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Using pg_dump in a cron Patrick.FICHE@xxxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
