Re: [PERFORM] Vacuum template databases, Urgent: Production probl

2006-03-14 Thread Vivek Khera
On Mar 14, 2006, at 4:19 PM, mcelroy, tim wrote: Humm, well I am running 8.0.1 and use that option and see the following in my vacuum output log: vacuumdb: vacuuming database "template1" it has done so since at least 7.4, probably 7.3. the "-a" flag really does what is says. ---

Re: [PERFORM] Vacuum template databases, Urgent: Production probl

2006-03-14 Thread Jim C. Nasby
On Tue, Mar 14, 2006 at 04:19:37PM -0500, mcelroy, tim wrote: > Humm, well I am running 8.0.1 and use that option and see the following in > my vacuum output log: > > vacuumdb: vacuuming database "template1" > > So I would assume that it is being vacuumed? Maybe I'm wrong. If so, we > should be

Re: [PERFORM] Vacuum template databases, Urgent: Production probl

2006-03-14 Thread mcelroy, tim
Title: RE: [PERFORM] Vacuum template databases, Urgent: Production probl Humm, well I am running 8.0.1 and use that option and see the following in my vacuum output log: vacuumdb: vacuuming database "template1" So I would assume that it is being vacuumed?  Maybe I'm wr

Re: [PERFORM] Vacuum template databases, Urgent: Production probl

2006-03-14 Thread Jim C. Nasby
On Tue, Mar 14, 2006 at 12:28:17PM -0500, mcelroy, tim wrote: > If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases > including template1? It does on 8.1... [EMAIL PROTECTED]:15]~:18%vacuumdb -va | & grep template1 vacuumdb: vacuuming database "template1" [EMAIL PROTECTED]:16

Re: [PERFORM] Vacuum template databases, Urgent: Production probl

2006-03-14 Thread mcelroy, tim
Title: RE: [PERFORM] Vacuum template databases, Urgent: Production problem If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases including template1? Tim  -Original Message- From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]  On Behalf Of Tom Lane Sent:   Tues