Date: Fri, 17 Jan 2003 17:55:29 -0500 From: Bill Moran <wmoran@potentialtech.com> To: Gerard Samuel <gsam@trini0.org> Cc: FreeBSD Questions <questions@FreeBSD.ORG> Subject: Re: Crontab and jobs Message-ID: <3E2889E1.8070609@potentialtech.com> References: <3E288543.9020708@trini0.org> <20030117223800.GA82138@submonkey.net> <3E2886A0.1040304@trini0.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Gerard Samuel wrote: > #!/bin/sh > # > # To back up PostgreSQL database > # > > date=`date '+%Y%m%d-%H%M%S'` > > pg_dump -cO -U user database > /root/db_back/pgsql-$date.sql You probably need the full path to pg_dump. The crontab environment doesn't have a lot of the settings you get in a login shell. > Ceri Davies wrote: > >> On Fri, Jan 17, 2003 at 05:35:47PM -0500, Gerard Samuel wrote: >> >> >>> Im trying to setup a cron job to back up my db. >>> If I manually execute the script it works fine, but the cron job >>> isn't executing the job. >>> >>> ## Backup PostgreSQL database >>> */1 * * * * /root/bin/pgsql-back >>> 2> /dev/null > /dev/null >>> >>> Anyone notice anything with this crontab entry??? >>> >> >> >> Show us the script. >> It's probably your path. >> >> Ceri >> >> > -- Bill Moran Potential Technologies http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3E2889E1.8070609>