Re: [GENERAL] Finding database names for overnight vacuum

2001-08-20 Thread Peter Eisentraut
Stephen Davies writes: > 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. vacuumdb --all -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end o

RE: [GENERAL] Finding database names for overnight vacuum

2001-08-20 Thread Andrew Snow
ect: [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: > > fo

Re: [GENERAL] Finding database names for overnight vacuum

2001-08-20 Thread Oliver Elphick
Stephen Davies wrote: >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

Re: [GENERAL] Finding database names for overnight vacuum

2001-08-20 Thread bpalmer
> 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

[GENERAL] Finding database names for overnight vacuum

2001-08-20 Thread Stephen Davies
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?