Re: URGENT: undoing a mistake

On 31 Oct 2002 at 10:18, Nick Sayer wrote:

> Andrew Perrin wrote:
>
> >- Do a formal backup more often
> >
> >
> >
> For what it's worth, the FreeBSD "port"
> (http://cvsweb.freebsd.org/ports/databases/postgresql7/) for
> PostgreSQL contains a most excellent daily maintenance script (as
> written it's a FreeBSD "periodic" script, but it's more or less
> suitable to be a cron job). It does a pg_dump of all the databases
> (with blobs, as a -Fc) and vacuums all the tables.

For those looking for this script:

http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/postgresql7/file
s/502.pgsql
--
Dan Langille : http://www.langille.org/