Horton

Re: How can I have 2 completely seperated databases in PostgreSQL?

Bruno Wolff III <bruno@wolff.to>

View thread View on postgr.es
From: Bruno Wolff III <bruno@wolff.to>
To: hong.ge@yale.edu
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-hackers@postgresql.org
Date: 2004-02-12T15:19:16Z
Lists: pgsql-hackers 
On Wed, Feb 11, 2004 at 17:48:51 -0500,
  hong.ge@yale.edu wrote:
> Thank you very much for your reply. I'd like to discuss the why.
> 
> I don't think letting them share data and logs could gain me something.
> And if I have 2 databases totally not relevant, I think the most natural
> way is to make them totally seperated. Does the sharing buys me
> anything? If not, what's the reason of doing it?

They would both use the same shared memory segment. If you are short on
memory running two clusters may make the problem worse.