[postgis-users] Restore of DB failing

Markus Schaber schabi at logix-tt.com
Tue Sep 19 02:47:02 PDT 2006


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



More information about the postgis-users mailing list