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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])