RE: Finding database names for overnight vacuum

Out of curiosity, whats wrong with vacuumdb -a?  ("Vacuum all
databases.")


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> Stephen Davies
> Sent: Monday, 20 August 2001 7:33 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Finding database names for overnight vacuum
>
>
> G'day all.
>
> I have a cron job which vacuums etc all of my databases but
> it does not
> work with 7.1.2 because of the change in structure of .../data/base.
>
> It currently says:
>
> for q in /usr/local/pgsql/data/base/*; do
> blaa
> blaa
> done
>
> How does one get an equivalent list of all databases from
> 7.1.2? (and where is it documented?)