On 28 Jun 2012, at 5:11, Tim Uckun wrote:
> I am sure this is intended behavior but it seems odd (and inconvenient) to me.
>
> create database tim_test_copy template tim_test
>
> ERROR: source database "tim_test" is being accessed by other users
> DETAIL: There are 1 other session(s) using the database.
>
> I would presume only reads are required from tim_test but apparently I
> have to resort to pg_dump and pg_restore to clone an active database.
For how to mark a database as a template database, check the bottom section of:
http://www.postgresql.org/docs/9.1/static/manage-ag-templatedbs.html
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.