Re: Using pg_dump in a cron

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick(dot)FICHE(at)AQSACOM(dot)COM
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using pg_dump in a cron
Date: 2005-06-02 16:06:38
Message-ID: 14662.1117728398@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Himanshu Baweja 2005-06-02 16:07:12 Re: Stats not getting updated....
Previous Message Jaime Casanova 2005-06-02 15:48:21 Re: [SQL] index row size 2728 exceeds btree maximum, 27