RE: [GENERAL] backup/maintenance scripts?

I use this one, after having asked on the list for this kind of stuff. It only does vacuum, because backup may be a lot more specific for each one.
It works on RedHat :

========================================
[root(at)fleurance cron.daily]# cat /etc/cron.daily/postgresql
#!/bin/sh

su postgres -c 'psql -t -c "select datname from pg_database order by datname;" template1 | xargs -n 1 psql -q -c "vacuum analyze;"'
[root(at)fleurance cron.daily]#
========================================

RedHat has the gentle facility to run every script in /etc/cron.daily, each day, according to this crontab :

========================================
[root(at)fleurance /etc]# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly
[root(at)fleurance /etc]#
========================================

Yours,

Nicolas huillard

-----Message d'origine-----
De: Bruce Bantos [SMTP:anon(at)mgfairfax(dot)rr(dot)com]
Date: jeudi 27 janvier 2000 17:35
À: pgsql-general(at)postgreSQL(dot)org
Objet: [GENERAL] backup/maintenance scripts?

I asked a similar question yesterday about scheduling backups and vacuum,
but I thought I would make a more direct request:

Does anyone have an example of a postgreSQL scheduled maintenance script
(cron job, other) that they would care to share with the list? An example of
a script that performs vacuums, creates backups, etc would be great. Perhaps
we could add a section on routine maintenance in the docs and include a good
script example.

Thanks,

Bruce

************