Date: Wed, 13 Oct 2004 14:20:29 -0700 From: Randy Grafton <rgrafton@indatacorp.com> To: Dick Davies <rasputnik@hellooperator.net> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Postgres Message-ID: <416D9C1D.1000104@indatacorp.com> In-Reply-To: <20041013204735.GO9309@lb.tenfour> References: <416D4546.9090308@webminded.nl> <20041013204735.GO9309@lb.tenfour>
next in thread | previous in thread | raw e-mail | index | archive | help
Dick Davies wrote: >* Norman Uittenbogaart <norman@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?416D9C1D.1000104>