From: | Javier Dussaillant <ashkar(at)vrweb(dot)cl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Old Template0 is annoying me! |
Date: | 2001-11-07 14:32:06 |
Message-ID: | 5.0.2.1.2.20011107105832.00a76070@192.168.0.254 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
First, hello to everyone, I'm new to the list :)
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, and
everything is working fine, but the Template0 DB is making some problems.
I upgraded sometime ago so I don't remember exactly what I did. I think
that I dumped all my DBs, dropped them, upgraded, initdb an then I restored
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 :(
I tried to vacuum the God forsaken DB while chanting some mantras, hoping
that it may fix it. I tried to banish it casting a Drop spell on it but
didn't work either.
So, any ideas of how I may exorcise my poor little linux from this evil
Template0?
Thanks,
P.D.: I was hearing Dead Can Dance while writing this mail so.... :)
Javier Dussaillant G.
ashkar(at)vrweb(dot)cl
Departamento de Desarrollo VRWEB ltda.
http://www.vrweb.cl
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastien Caille | 2001-11-07 14:43:36 | error with "select from tg_relname" |
Previous Message | Roberto Mello | 2001-11-07 13:57:45 | Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql |