Re: Create Linux Script for PostgreSQL database backup - Mailing list pgsql-admin

From Sandro Garoffolo
Subject Re: Create Linux Script for PostgreSQL database backup
Date
Msg-id 413722B4.9040107@unito.it
Whole thread Raw
In response to Re: Create Linux Script for PostgreSQL database backup  (Geoffrey <esoteric@3times25.net>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Geoffrey
Date:
Subject: Re: Create Linux Script for PostgreSQL database backup
Next
From: Christopher Browne
Date:
Subject: Re: Create Linux Script for PostgreSQL database backup