From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Mauro Bertoli" <bertolima(at)yahoo(dot)it>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Create db problem |
Date: | 2006-04-05 08:50:38 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9A3B@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Mauro Bertoli
> Sent: 05 April 2006 09:40
> To: pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Velevitch | 2006-04-05 09:26:44 | ERROR: permission denied for schema public |
Previous Message | Mauro Bertoli | 2006-04-05 08:40:18 | Create db problem |