Re: New database or New Schema?

On Fri, Aug 21, 2009 at 12:16:45PM -0400, Eric Comeau wrote:
> In the next release of our software the developers are moving to
> JBoss and have introduced the use of JBoss Messaging. They want to
> change from using the built-in hsqldb to using our PostgreSQL
> database.
>
> What is the best approach, create a new database or new schema
> with-in our current PostgreSQL database?
>
> I'm leaning toward creating a new schema as we already have built-in
> procedures to backup and restore the application database.

It's difficult to tell from what you've described. If you were even
vaguely contemplating queries that touched both that database and
others you already have, it becomes much easier: use a schema.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate