Re: Finding database names for overnight vacuum

have you tried "psql -l"?

David

bpalmer wrote:

>>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>