Using pg_dump in a cron

From: Patrick(dot)FICHE(at)AQSACOM(dot)COM
To: pgsql-general(at)postgresql(dot)org
Subject: Using pg_dump in a cron
Date: 2005-06-02 13:43:35
Message-ID: 1DC6C8C88D09D51181A40002A5286929B23119@intranet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm using PostgreSQL 8.0.2 on Solaris 10.
I would like to manage an automatic backup of my database.

Here is the line in the cron :
37 * * * * . $HOME/.profile; pg_dump alis -U postgres -f
$AQSADIR/data/backup/alis_data.sql -a -d >/dev/null 2>&1

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 ?

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


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Clements 2005-06-02 13:54:16 Automate Postgres Backup In windows
Previous Message Michael Fuhr 2005-06-02 13:27:38 Re: writing a file using procedure