On Sun, Nov 13, 2011 at 1:13 PM, Thom Brown <t...@linux.com> wrote: > I don't know if this has been discussed before, but would it be > feasible to introduce the ability to detach and attach databases? (if > you're thinking "stop right there" skip to the end) What I had in > mind would be to do something like the following:
That would be better done at the tablespace level, and then the feature becomes "transportable tablespaces". Which seems like a good and useful idea to me. > You may now be able to infer where this notion came from, when someone > asked if you can clone databases without kicking users off. However, > this isn't a schema-only copy, but naturally contains data as well. The OP wanted to do this without freezing activity on the database, which is not easy... OTOH we can do a backup of just a single database and then filter recovery at database level to produce just a single copy of another database on its own server, if anyone wanted that. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
