Re: Old Template0 is annoying me!

From: Javier Dussaillant <ashkar(at)vrweb(dot)cl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Old Template0 is annoying me!
Date: 2001-11-07 18:18:19
Message-ID: 5.0.2.1.2.20011107151451.00a7de70@192.168.0.254
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmmm... I was thinking the same a while ago. I updated webmin like a week
ago, but perhaps it didn't update the pgsql module...
I'll check that.

Thanks to you and Andrew Sullivan who replied to me also :)

At 01:01 PM 11/7/2001 -0500, Tom Lane wrote:
>Javier Dussaillant <ashkar(at)vrweb(dot)cl> writes:
> > Well, I have the following problem. When I upgraded to pgsql 7.1 (I can't
> > recall exactly what previous version I had), postgresql created a
> > Template1, in addition to the Template0 that already existed,
>
>The other way around I would believe ...
>
> > them. But, I didn't consider what would happen to Template0, so it seems
> > that it stayed like an anachronic entity, a specter that bugs me but
> that I
> > cannot grab. When I use phpPgAdmin, it truncates the DB list at Template0
> > so I can't see the DB that would go after it. When I'm using Webmin's
> > PostgreSQL module, when I try to see the Granted Privileges this undead
> > Template0 starts consuming all of my machine's resources, sucking up it's
> > life energy :(
>
>Your complaint is colorful but it's not easy to determine exactly what's
>going wrong for you. template0 should just sit there quietly and not do
>anything. Perhaps you need to get updated versions of phpPgAdmin and/or
>webmin that know that that's a system database and they shouldn't try to
>connect to it?
>
> regards, tom lane

Javier Dussaillant G.
ashkar(at)vrweb(dot)cl
Departamento de Desarrollo VRWEB ltda.
http://www.vrweb.cl

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gordan Bobic 2001-11-07 18:26:08 Re: More Performance Questions
Previous Message Gordan Bobic 2001-11-07 18:14:59 Re: Performance Question Followup No.2