pgAdmin II questions

From: "Tamir Halperin" <tamir(at)brobus(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pgAdmin II questions
Date: 2003-03-30 18:33:13
Message-ID: 985DF46E87E0C047A3670048DBCAD0556BFC@andrew.brobus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I just finished upgrading from FreeBSD 4.6 to 4.8RC and I'm trying to do some things with pgAdmin II which are giving me problems.

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

Is this a db that the postgresql needs or was it created by mistake, maybe as a result of an erroneous create command?

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

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-03-30 20:21:43 Re: pgAdmin II questions
Previous Message Peter Eisentraut 2003-03-30 13:45:42 Re: pg_dump restore problem