Re: Create Linux Script for PostgreSQL database backup

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