From: d.davolio@mastertraining.it <d.davolio@mastertraining.it>
To: pgsql-performance@postgresql.org
Subject: Re: How many Cluster database on a single server
Date: Fri, 21 Oct 2011 08:57:48 +0200
Message-ID: <4EA117EC.7000406@mastertraining.it> (raw)
In-Reply-To: <4E9EA2D60200002500042216@gw.wicourts.gov>
References: <4E9E9C82.4060400@mastertraining.it>
<4E9ED696.1080107@emolecules.com>
<4E9EE69E.4070502@mastertraining.it>
<4E9EA2D60200002500042216@gw.wicourts.gov>
Thanks everybody for the suggestions. Now I have a better idea on which
direction proceed. When we will have some results we will post again to
share.
Thanks again!
On 10/19/2011 05:13 PM, Kevin Grittner wrote:
> "d.davolio@mastertraining.it"<d.davolio@mastertraining.it> wrote:
>
>> We are thinking to use the Streaming Replica feature to keep in
>> sync a number of little DB servers around the net. The replica
>> should happen on one or more centralized servers. I didn't tested
>> the replica personally bus as I can see, it syncs the whole
>> Cluster DB. So, on the centralized server(s), we will have perfect
>> copies of the Cluster Databases. We sure need to test this
>> configuration but first of all I was wondering if there are known
>> drawbacks.
>
> We do something very much like this with about 100 standby database
> clusters on a single machine. We don't have any illusion that we
> could switch to one of these for a normal production load and have
> good performance with all of these competing for resources -- it's
> primarily to confirm that the PITR backup process is working and
> staying up to date, and to provide a quick source for a copy to a
> standby production server.
>
> The one thing I would strongly recommend is that you use a separate
> OS user as the owner of each cluster's data directory (and, of
> course, to run the cluster's service). We didn't initially do this,
> and had problems on recovery when the server crashed. If you search
> the archives you can probably dig up all the details on why this is
> an issue and why separate users is a good solution; but really, this
> is important.
>
> -Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: d.davolio@mastertraining.it
Subject: Re: How many Cluster database on a single server
In-Reply-To: <4EA117EC.7000406@mastertraining.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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