New database or New Schema?

From: "Eric Comeau" <ecomeau(at)signiant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: New database or New Schema?
Date: 2009-08-21 16:16:45
Message-ID: h6mh9e$1e5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Archibald Zimonyi 2009-08-21 16:27:46 Re: Questions about encoding between two databases
Previous Message Scott Bailey 2009-08-21 16:09:46 Re: pl/pgsql loop thru columns names