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. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
