Re: Finding database names for overnight vacuum

Поиск
Список
Период
Сортировка
От bpalmer
Тема Re: Finding database names for overnight vacuum
Дата
Msg-id Pine.BSO.4.33.0108200545130.8531-100000@mizer.crimelabs.net
обсуждение исходный текст
Ответ на Finding database names for overnight vacuum  (Stephen Davies <scldad@sdc.com.au>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Stephen Davies
Дата:
Сообщение: Finding database names for overnight vacuum
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Finding database names for overnight vacuum