Re: Advantages and disadvantages of more than one dbserver on one server

From: "Daniel Seichter" <daniel(at)dseichter(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Advantages and disadvantages of more than one dbserver on one server
Date: 2003-07-03 19:47:49
Message-ID: be2181$t06$1@main.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The result of compiling, testing and let postgreSQL crash:

Now I know, that I only have advantages if I will let run each database with
its own session of pgsql. I can stop/start/restart(/kill) one session and
the other works as long as the server is not shutting down or something like
the worst case,...
I can setting up different users with different rights to each postgresql
and also can limit the possibility that users can have access to something
they shoudl not get have access.
Today memory isn't expensive so with 512MB I can be shure, every user on
this server might have enough to work without any timeout or waiting times
greater then 2 seconds.

Thanks to all which helped.

Daniel

P.S.: I hope the new release of postgreSQL for netware will be available
soon, so the same I can do without compiling.
--
postgreSQL on Netware - the red elephant
http://postgresql.dseichter.org

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-07-03 20:42:41 Re: Advantages and disadvantages of more than one dbserver
Previous Message Stuart 2003-07-03 17:24:27 Re: Login as different user inside of a function.