Re: Create db problem

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Mauro Bertoli
> Sent: 05 April 2006 09:40
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Create db problem
>
> Hi, I've some strange behaviours managing databases:
>
> - if I want create a new db from a postgres console
> (psql) I MUST have all pgAdmin clients closed (because
> 'maintenance db' lock postgres db)

That's why PostgreSQL 8.1 has the 'postgres' database so apps like
pgAdmin no longer use template1.

> - using pgAdmin I cannot create a new db using the connected
> db as template

You can only create a DB using a connected DB as a template if you
create the database /from/ that template dattabase, and that is the only
connection to that database.

Regards, Dave