Re: [ADMIN] Vacuum process.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Christopher L(dot) Davis" <cld(at)prin(dot)edu>
Cc: pgsql-admin(at)hub(dot)org
Subject: Re: [ADMIN] Vacuum process.
Date: 2000-01-12 03:30:00
Message-ID: Pine.LNX.4.21.0001120418300.3735-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)prin(dot)edu
>
> ************
>
>

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-01-12 03:30:18 Re: [ADMIN] Setting Transaction level doesn't work
Previous Message Peter Eisentraut 2000-01-12 03:29:56 Re: [ADMIN] bugs?