Finding database names for overnight vacuum

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Finding database names for overnight vacuum
Date: 2001-08-20 09:32:40
Message-ID: 200108200932.f7K9WeR09946@mustang.sdc.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bpalmer 2001-08-20 09:45:49 Re: Finding database names for overnight vacuum
Previous Message Johann Zuschlag 2001-08-20 09:16:38 Re: Overwriting Operator for numeric and float8 fails