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@xxxxxxxxxxxxxxxxx"<d.davolio@xxxxxxxxxxxxxxxxx> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
