Geoffrey wrote:
Kaolin Fire wrote:
For that matter:
echo "1 3 * * * postgres /usr/local/bin/pg_dumpall > ~/backup.sql" >> /etc/crontab
note to remember the two >>'s so you don't obliterate your crontab like I just did.
Unless things have changed, and they might have, you have to tell cron to reread the crontab file for it to process your addition. Your better solution is to use the tools designed for editing crontab, such as 'crontab -e.' If you use this tool, crontab will automagically reread the file.
One question , if you set access to server with password in pg_hba.conf how can you pass the apssword in the script?
_____________________________________________________________________ For your security, this mail has been scanned and protected by Inflex
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
