[postgis-users] Help

[Lee Hachadoorian]

Are you trying to do this in pgAdmin?  If you clicked on
template_postgis in the left pane server/database hierarchy, pgAdmin
is now using the database and can't also use it as a template for a
new DB.  (pgAdmin is using the database if the database icon does
*not* have a little red X over it.)

You should be able to fix this by disconnecting from the server, then
reconnecting.  Create your new DB before doing anything that uses the
template_postgis database.

Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center

On Wed, May 7, 2008 at 9:25 AM, eehab hamzeh <eehab40 at hotmail.com> wrote:
>
> Hello
>
>  I am a new user to PostGIS, i try to create a database with the following
>
>
>
>
> §Name der DB: ihab
> §Eigentümer der DB: postgres
>
> §Kodierung der Zeichen: LATIN1
>
> §Vorlage: template_postgis
>
> I received the following message
>
> 'Error: Source database 'Template_postgis' is being used by other user'
>
>
> thanks
>
> Ihab
>
>
> ________________________________
> Explore the seven wonders of the world Learn more!
> _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>