Thread: Vacuum process.

Vacuum process.

From
"Christopher L. Davis"
Date:
Sorry if this is very basic, but I have searched through the archives and
saw mention in a message that vacuuming template1 caused problems.  So I
just wanted to be sure.  Is it necessary to vacuum the template1 database?
I am writing a script to backup and then vacuum my database, but wondered
if I should include a command for vacuuming template1 in addition.  I am
running version 6.4.  And should the recommendation change for the current
version?

Thanks,
Chris

------------------------------------------------------------
Christopher L. Davis       Systems and Network Administrator
The Principia                   PHONE:  (314)-434-2100
13201 Clayton Road                FAX:  (314)-275-3538
St. Louis, MO  63131         INTERNET:  cld@prin.edu

Re: [ADMIN] Vacuum process.

From
Peter Eisentraut
Date:
There shouldn't be any need to vacuum the template database. It's vacuumed
at the end of initdb and one usually doesn't make any great changes to it
afterwards.

On 2000-01-12, Christopher L. Davis mentioned:

> Sorry if this is very basic, but I have searched through the archives and
> saw mention in a message that vacuuming template1 caused problems.  So I
> just wanted to be sure.  Is it necessary to vacuum the template1 database?
> I am writing a script to backup and then vacuum my database, but wondered
> if I should include a command for vacuuming template1 in addition.  I am
> running version 6.4.  And should the recommendation change for the current
> version?
>
> Thanks,
> Chris
>
> ------------------------------------------------------------
> Christopher L. Davis       Systems and Network Administrator
> The Principia                   PHONE:  (314)-434-2100
> 13201 Clayton Road                FAX:  (314)-275-3538
> St. Louis, MO  63131         INTERNET:  cld@prin.edu
>
> ************
>
>

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden