[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

__________________________________________
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