Re: [ADMIN] regular maintenance, backup

[Herouth Maoz]

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