rgrafton at indatacorp.com
Wed Oct 13 14:20:22 PDT 2004
Dick Davies wrote:
>* Norman Uittenbogaart <norman at webminded.nl> [1010 16:10]:
>>I'm trying to write a backup script for postgres and us a crontab on it.
>>In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask
>>for a password.
>>Now I made the .pgpass in root's homedir (i wanted to use root's
>>crontab) paste the password in it, chmod 400 it ...
>Can't you just pgdump from the local socket? And not bother with the password
>thing at all?
I chose to go with the pg_dump solution command from root's crontab.
Cron runs a script once a night with the following commands:
/usr/local/bin/vacuumdb -a -F -v -U pgsql > /var/backups/"$DATE"_pg.vac
/usr/local/bin/pg_dump -Fc -U pgsql db_name > /var/backups/"$DATE"_db.bu
More information about the freebsd-questions