I teach a class using PostGIS and have successfully used templates as an
efficient way of copying databases for each class member (ie. selecting a
populated database as the template).
However, in our new configuration this time around I have been getting error
messages that the database is in use when they try and copy it. Looking at
pg_stat it seems there is no one connected to the template database but still
it refuses to copy. Starting and stopping the service fixes it temporarily.
They are all connecting as the same user.
Would appreciate any clues as to what is going on and any solutions? We don't
get any errors when creating new databases from template_postgis so is there
some way I can set up the database in a similar fashion?
Postgres version: "PostgreSQL 9.0.4, compiled by Visual C++ build 1500, 32-bit"
Running on Windows Server 2008 (virtualised) via Windows Terminal Services
Thanks
Phil
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
