| From: | "Dan Langille" <dan(at)langille(dot)org> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: URGENT: undoing a mistake |
| Date: | 2002-12-04 20:14:48 |
| Message-ID: | 3DEE1BE8.12180.21C731E@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ralf Praschak | 2002-12-05 02:47:28 | alter database name length |
| Previous Message | Jack Flak | 2002-12-04 18:55:07 | Re: Disabling triggers on a relation. |