Finding database names for overnight vacuum - Mailing list pgsql-general

From Stephen Davies
Subject Finding database names for overnight vacuum
Date
Msg-id 200108200932.f7K9WeR09946@mustang.sdc.com.au
Whole thread Raw
Responses Re: Finding database names for overnight vacuum  (bpalmer <bpalmer@crimelabs.net>)
Re: Finding database names for overnight vacuum  ("Oliver Elphick" <olly@lfix.co.uk>)
RE: Finding database names for overnight vacuum  ("Andrew Snow" <andrew@modulus.org>)
Re: Finding database names for overnight vacuum  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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?)

Cheers and thanks,
Stephen Davies

========================================================================
Stephen Davies Consulting                              scldad@sdc.com.au
Adelaide, South Australia.                             Voice: 08-8177 1595
Computing & Network solutions.                         Fax: 08-8177 0133



pgsql-general by date:

Previous
From: "Johann Zuschlag"
Date:
Subject: Re: Overwriting Operator for numeric and float8 fails
Next
From: bpalmer
Date:
Subject: Re: Finding database names for overnight vacuum