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 <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
