Re: Using pg_dump in a cron - Mailing list pgsql-general

From Tom Lane
Subject Re: Using pg_dump in a cron
Date
Msg-id 14662.1117728398@sss.pgh.pa.us
Whole thread Raw
In response to Using pg_dump in a cron  (Patrick.FICHE@AQSACOM.COM)
List pgsql-general
Patrick.FICHE@AQSACOM.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

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: [SQL] index row size 2728 exceeds btree maximum, 27
Next
From: Himanshu Baweja
Date:
Subject: Re: Stats not getting updated....