[postgis-users] Restore of DB failing

[Steffen Macke]

Tim,

> 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 issuing?
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.

Regards,

Steffen