At 02:33 +0300 on 09/07/1999, Lamar Owen wrote: > psql -t -c "select datname from pg_database" template1|xargs -n 1 psql > -q -c "vacuum analyze" I would add a WHERE DATNAME <> 'template1' to this query. It could prevent locks, at least to people who didn't upgrade to 6.5 as yet. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma
- [ADMIN] regular maintenance, backup JT Kirkpatrick
- Re: [ADMIN] regular maintenance, backup Lamar Owen
- Re: [ADMIN] regular maintenance, backup Keith Keller
- Re: [ADMIN] regular maintenance, backup Oliver Elphick
- [ADMIN] regular maintenance, backup Lamar Owen
- Re: [ADMIN] regular maintenance, backup kkeller
- Re: [ADMIN] regular maintenance, backup Lamar Owen
- Herouth Maoz