Re: Finding database names for overnight vacuum

From: bpalmer <bpalmer(at)crimelabs(dot)net>
To: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding database names for overnight vacuum
Date: 2001-08-20 09:45:49
Message-ID: Pine.BSO.4.33.0108200545130.8531-100000@mizer.crimelabs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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?)

Not sure where it's documented, but checkout contrib/oid2name in the
source ball.

- Brandon

----------------------------------------------------------------------------
b. palmer, bpalmer(at)crimelabs(dot)net pgp:crimelabs.net/bpalmer.pgp5

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2001-08-20 09:56:32 Re: Finding database names for overnight vacuum
Previous Message Stephen Davies 2001-08-20 09:32:40 Finding database names for overnight vacuum