| From: | Vivek Khera <vivek(at)khera(dot)org> | 
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: Using pg_dump in a cron | 
| Date: | 2005-06-02 17:27:20 | 
| Message-ID: | 2A0C3A0C-EA74-42ED-A750-9E2DBA4E66C6@khera.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
On Jun 2, 2005, at 9:43 AM, Patrick(dot)FICHE(at)AQSACOM(dot)COM wrote:
> 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 ?
>
Your .profile executes the stty command.  Don't do that.  Why do you  
need stuff from your .profile anyhow?
And why would you drop the output to /dev/null -- you'll never know  
if your dump fails!  Why bother making one then?
Vivek Khera, Ph.D.
+1-301-869-4449 x806
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russ Brown | 2005-06-02 17:40:33 | Re: writting a large store procedure | 
| Previous Message | Richard Huxton | 2005-06-02 17:00:17 | Re: [SQL] index row size 2728 exceeds btree maximum, 27 |