Thread: Create db problem

Create db problem

From

Mauro Bertoli

Date:

05 April 2006, 08:40:23

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)

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

Thank you


    
___________________________________ 
Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB 
http://mail.yahoo.it

Re: Create db problem

From

"Dave Page"

Date:

05 April 2006, 08:50:44


> -----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