Re: [GENERAL] Using pg_dump in a cron

--- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane Sent: jeudi 2 juin 2005 18:07 To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Using pg_dump in a

Re: [GENERAL] Using pg_dump in a cron

On Jun 2, 2005, at 9:43 AM, [EMAIL PROTECTED] 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 st

Re: [GENERAL] Using pg_dump in a cron

[EMAIL PROTECTED] 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: > > s

[GENERAL] Using pg_dump in a cron

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