Re: Finding database names for overnight vacuum - Mailing list 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@crimelabs.net            pgp:crimelabs.net/bpalmer.pgp5