[postgis-users] Restore of DB failing
Tim De Chant
dechant at nature.berkeley.edu
Mon Sep 18 11:34:26 PDT 2006
Here's the postgis_restore.pl command I have been using:
sh /usr/bin/postgis_restore.pl /usr/share/postgresql/contrib/
lwpostgis.sql china_camp ~/gaptest2.dump > ~/restore.log
In response to your other point (other psql, et al. sessions
running), I think we ran the script with nothing else running, but I
cannot be positive. Is this essential to the success of the script?
Creating a db without postgis_restore.pl does not require me to stop
instances of psql, et al. Is this specific to postgis_restore.pl?
Tim De Chant
University of California, Berkeley
Environmental Science, Policy, and Management
137 Mulford Hall #3114
Berkeley, CA 94720-3114
On Sep 18, 2006, at 11:15 AM, Steffen Macke wrote:
>> createdb: database creation failed: ERROR: source database
>> "template1" is being accessed by other users
> What is the name of the database you are trying to restore?
> Could you post the full postgis_restore.pl command that you are
> Did you drop the old database (in case it is existing)?
> The error message means what it says: A user is accessing
> template1, blocking
> it for administrative purposes (like creating new databases). Make
> sure that you
> have no psql or other PostgreSQL sessions (PgAdmin, etc.) open.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users