[postgis-users] Restore of DB failing

Tim De Chant dechant at nature.berkeley.edu
Tue Sep 19 09:23:28 PDT 2006

Thanks all for the help.  Late yesterday I made sure that there were  
no connections to template1 (save my own) and ran the script.  Ran  
fine.  All seems well.  Thanks again.


Tim De Chant
     University of California, Berkeley
     Environmental Science, Policy, and Management
     137 Mulford Hall #3114
     Berkeley, CA 94720-3114
     (510) 643-3910

On Sep 19, 2006, at 2:47 AM, Markus Schaber wrote:

> Hi, Tim,
> Markus Schaber wrote:
>> PostgreSQL tries the template1 database by default when creating a  
>> new
>> database. However, this won't work when there are any connections to
>> that database (other than the one issuing createdb itsself).
> This statement is somehow confusing.
> I wanted to say that, by default, PostgreSQL copies the template1
> database when creating a new database. As this copying happens on the
> file system level, it needs a global lock on that source database.
> HTH,
> Markus
> -- 
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
> Fight against software patents in Europe! www.ffii.org
> www.nosoftwarepatents.org
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list