pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcluster or database?
4+ messages / 3 participants
[nested] [flat]
* cluster or database?
@ 2007-01-24 19:32 Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Ray Stell @ 2007-01-24 19:32 UTC (permalink / raw)
To: pgsql-admin
Is there a drawback to have different clusters on the same
system/diskspace? I have different applications I want to support
initially on the same server/disk array. I was thinking it would be
better/easier to have seperate clusters per app for ease of migration
and security. Is it highly superior just to use different dbs? Why?
Where is this discussed? Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cluster or database?
@ 2007-01-27 19:42 Bruno Wolff III <bruno@wolff.to>
parent: Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Bruno Wolff III @ 2007-01-27 19:42 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: pgsql-admin
On Wed, Jan 24, 2007 at 14:32:37 -0500,
Ray Stell <stellr@cns.vt.edu> wrote:
> Is there a drawback to have different clusters on the same
> system/diskspace? I have different applications I want to support
> initially on the same server/disk array. I was thinking it would be
> better/easier to have seperate clusters per app for ease of migration
> and security. Is it highly superior just to use different dbs? Why?
> Where is this discussed? Thanks.
The downside to multiple clusters is that is harder to configure them
to play nice with each other in the way of resource utilization because
they don't communicate with each other.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cluster or database?
@ 2007-01-28 14:25 Ray Stell <stellr@cns.vt.edu>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 4+ messages in thread
From: Ray Stell @ 2007-01-28 14:25 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; pgsql-admin
On Sat, Jan 27, 2007 at 01:42:52PM -0600, Bruno Wolff III wrote:
> On Wed, Jan 24, 2007 at 14:32:37 -0500,
> Ray Stell <stellr@cns.vt.edu> wrote:
> > Is there a drawback to have different clusters on the same
> > system/diskspace? I have different applications I want to support
> > initially on the same server/disk array. I was thinking it would be
> > better/easier to have seperate clusters per app for ease of migration
> > and security. Is it highly superior just to use different dbs? Why?
> > Where is this discussed? Thanks.
>
> The downside to multiple clusters is that is harder to configure them
> to play nice with each other in the way of resource utilization because
> they don't communicate with each other.
Thank you for responding. Do you have any documentation that would
support my efforts to understand some of the issues?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cluster or database?
@ 2007-01-28 17:16 Shane Ambler <pgsql@007Marketing.com>
parent: Ray Stell <stellr@cns.vt.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Shane Ambler @ 2007-01-28 17:16 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Bruno Wolff III <bruno@wolff.to>; pgsql-admin
Ray Stell wrote:
> On Sat, Jan 27, 2007 at 01:42:52PM -0600, Bruno Wolff III wrote:
>> On Wed, Jan 24, 2007 at 14:32:37 -0500,
>> Ray Stell <stellr@cns.vt.edu> wrote:
>>> Is there a drawback to have different clusters on the same
>>> system/diskspace? I have different applications I want to support
>>> initially on the same server/disk array. I was thinking it would be
>>> better/easier to have seperate clusters per app for ease of migration
>>> and security. Is it highly superior just to use different dbs? Why?
>>> Where is this discussed? Thanks.
>> The downside to multiple clusters is that is harder to configure them
>> to play nice with each other in the way of resource utilization because
>> they don't communicate with each other.
>
>
> Thank you for responding. Do you have any documentation that would
> support my efforts to understand some of the issues?
>
You should probably start with
http://www.postgresql.org/docs/8.2/interactive/creating-cluster.html
which will explain more about what a cluster is.
http://www.postgresql.org/docs/8.2/interactive/kernel-resources.html
should give you some insight into the problems system resources can play
with multiple servers on one machine.
There are a couple of ways you can have several clusters on one machine.
1. run initdb on different directories and start PostgreSQL with a
different one (-D option) when you want to work with it (which may fit
in with what you want to do).
2. run multiple copies of PostgreSQL each with it's own cluster, port
and using more system resources.
2 is where the resource problems come in - each server will need a
number of resources which is limited by system settings and often will
need a recompiled kernel to allow higher limits.
You shouldn't have any problems developing multiple databases on the one
server/cluster - each db is entirely separate from the others and you
would only have problems if you are customizing the system catalog and
want differences with each db you are working on.
When you come to install your db on the client server you create a new
cluster for their server and create the users/groups they will use then
create the database for them with the structure you want in it. You only
need to transfer the one database structure from your development server
not your entire cluster.
--
Shane Ambler
pgSQL@007Marketing.com
Get Sheeky @ http://Sheeky.Biz
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-01-28 17:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-24 19:32 cluster or database? Ray Stell <stellr@cns.vt.edu>
2007-01-27 19:42 ` Bruno Wolff III <bruno@wolff.to>
2007-01-28 14:25 ` Ray Stell <stellr@cns.vt.edu>
2007-01-28 17:16 ` Shane Ambler <pgsql@007Marketing.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox