Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 17 Jan 2003 17:41:36 -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:  <3E2886A0.1040304@trini0.org>
References:  <3E288543.9020708@trini0.org> <20030117223800.GA82138@submonkey.net>

next in thread | previous in thread | raw e-mail | index | archive | help
#!/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?3E2886A0.1040304>