Обсуждение: database count and creating from template

Hello.  I have two questions.   First, it is possible
to name another database to "clone" with the create
statement?  I know I could modify template1, but,
I have more than one template.

Second, I'd like to have _alot_ of small databases
what type of issues do I have to concern myself with?
I've already done some of the changes to increase
the shared memory space, etc.

Thank you so much!

Clark

On Tue, Jan 01, 2002 at 12:32:22PM -0500, Clark C . Evans wrote:
| Hello.  I have two questions.   First, it is possible
| to name another database to "clone" with the create
| statement?  I know I could modify template1, but,
| I have more than one template.

*blush* ... for some reason I didn't see
   CREATE DATABASE dbname TEMPLATE mytemplate
very sorry.

| Second, I'd like to have _alot_ of small databases
| what type of issues do I have to concern myself with?
| I've already done some of the changes to increase
| the shared memory space, etc.

Any hints/problems/tricks would be great.

Clark