"Dave Page" <dpage@vale-housing.co.uk> writes:
pgAdmin uses template1 by default as it is the only accessible database that we can be sure will exist. There are 2 solutions to your problem:
1) Change your pgAdmin connection to use a different default database.
2) Select a different database to use as the template when creating a new one.
He shouldn't really be getting that error though, as CREATE DATABASE only complains if there is another connection *besides your own* to the template database.
I think the real answer is something more along the lines of "don't run two copies of pgAdmin at once".
Which is still not the whole truth.
pgAdmin may open more connections to the "initial database", e.g. to show the server status.
So the advice is "don't use the template1 database for pgadmin connections if you're creating databases frequently"
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
