Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin II questions

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tamir Halperin <tamir(at)brobus(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pgAdmin II questions
Date: 2003-03-30 20:21:43
Message-ID: 20030330121626.Q24855-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
I don't know much about pgAdmin itself, but...

On Sun, 30 Mar 2003, Tamir Halperin wrote:

> I remember creating a db called taxcal and it's listed there. However,
> I don't remember creating a db called pgsql.

It's possible it got created as a side effect of the system upgrade.

> Also, I can't drop it (by right clicking on it and selecting drop
> object from the shortcut menu. After being warned that the action
> cannot be undone I agree and an error comes up:
>
> "An error as occured in pgAdmin II:basActions.drop:
>
> Number: -2147467259

> Description: ERROR: DROP DATABASE: database "pgsql" is being accessed
> by other users

Are there any connections to it on the server?  You can check with ps.

> Another thing I need help with is the appearance of both "template0"
> as well as "template1". I can't seem to delete template0 because the
> error from the drop action informs me that it is marked as a template.

Deleting template0 or template1 (unless you're just going to recreate it
from template0) is a bad idea.  They're the template databases from which
new databases are created (IIRC, template0 is just system things and
template1 can include anything you want to be clone in newly created
databases - such as language handlers, or wahtever).


In response to

Responses

pgsql-admin by date

Next:From: Kevin BrownDate: 2003-03-31 09:10:45
Subject: Re: [pgsql-advocacy] uppercase = lowercase
Previous:From: Tamir HalperinDate: 2003-03-30 18:33:13
Subject: pgAdmin II questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group