Postgres

[Andrew L. Gould]

On Wednesday 13 October 2004 04:20 pm, Randy Grafton wrote:
> 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:
> DATE=`/bin/date +%Y%m%d`
> /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
>
> -Randy

Why not run use pgsql's crontab?

Best of luck,

Andrew Gould