Cronjob errors - Mailing list pgsql-novice

From Swanepoel, Barrie
Subject Cronjob errors
Date
Msg-id 850B6BE405AA674CB6C39EADC7CFC6E1751DC1@apk-exch-01.ad.uj.ac.za
Whole thread Raw
Responses Re: Cronjob errors  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-novice

I am trying to make a pg_dumpall via a cronjob. Using Redhat ES release 4 (Nahant Update 5) and postgresql-7.4.17-1.RHEL4.1.

 

The error I get is:

 

Date: Wed, 14 Nov 2007 04:00:01 +0200

From: root@localhost.localdomain (Cron Daemon)

To: root@localhost.localdomain

Subject: Cron <postgres@localhost> /usr/local/bin/dspace_postgres_backup >1

+/dev/null

X-Cron-Env: <SHELL=/bin/bash>

X-Cron-Env: <PATH=/sbin:/bin:/usr/sbin:/usr/bin>

X-Cron-Env: <MAILTO=root>

X-Cron-Env: <HOME=/>

X-Cron-Env: <LOGNAME=postgres>

X-Cron-Env: <USER=postgres>

 

/bin/bash: 1: No such file or directory

 

 

My shell script in /usr/local/bin is:

 

#!/bin/bash

FNAME=dspace.`date +%F`.backup

#echo $FNAME

/usr/bin/pg_dumpall -c -o > /data/dspace_backups/$FNAME

gzip /data/dspace_backups/$FNAME

 

My crontab in /etc is:

 

SHELL=/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin

MAILTO=root

HOME=/

 

# run-parts

01 * * * * root run-parts /etc/cron.hourly

02 4 * * * root run-parts /etc/cron.daily

22 4 * * 0 root run-parts /etc/cron.weekly

42 4 1 * * root run-parts /etc/cron.monthly

 

00 4 * * * postgres /usr/local/bin/dspace_postgres_backup >1 /dev/null

 

Any advise will be appreciated!

 

 

pgsql-novice by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: Building full-text index
Next
From: "Phillip Smith"
Date:
Subject: Re: Cronjob errors