Date: Fri, 17 Jan 2003 17:55:21 -0500 From: Gerard Samuel <gsam@trini0.org> To: Ceri Davies <setantae@submonkey.net> Cc: FreeBSD Questions <questions@FreeBSD.ORG> Subject: Re: Crontab and jobs Message-ID: <3E2889D9.5060100@trini0.org> 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
Thanks to James and Ceri. Use the full path to pg_dump -> /usr/local/bin/pg_dump Works now. 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 > > > 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 >> >> > -- Gerard Samuel http://www.trini0.org:81/ http://dev.trini0.org:81/ 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?3E2889D9.5060100>