| From: | "Andrew Snow" <andrew(at)modulus(dot)org> |
|---|---|
| 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 10:04:57 |
| Message-ID: | 001201c1295f$91355cf0$fa01b5ca@avon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Out of curiosity, whats wrong with vacuumdb -a? ("Vacuum all
databases.")
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
> Stephen Davies
> Sent: Monday, 20 August 2001 7:33 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Finding database names for overnight vacuum
>
>
> 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?)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Babikov | 2001-08-20 11:05:46 | Is it possible to work with big databases (up to 10Gb) under Postgres? |
| Previous Message | Oliver Elphick | 2001-08-20 09:57:38 | Re: Finding database names for overnight vacuum |