Out of curiosity, whats wrong with vacuumdb -a? ("Vacuum all
databases.")
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of
> Stephen Davies
> Sent: Monday, 20 August 2001 7:33 PM
> To: [EMAIL PROTECTED]
> 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?)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
