Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TG7Go-0008J6-FP for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 11:56:14 +0000 Received: from news.hub.org ([200.46.204.72]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TG7Gn-0006YQ-1M for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 11:56:14 +0000 Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.5/8.14.5) with ESMTP id q8OBuA8Q005367 for ; Mon, 24 Sep 2012 08:56:10 -0300 (ADT) (envelope-from news@news.hub.org) Received: from news.hub.org (news@localhost) by news.hub.org (8.14.5/8.14.5/Submit) with NNTP id q8OBo1FT001811 for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 08:50:01 -0300 (ADT) (envelope-from news) Received: by 10.224.223.84 with SMTP id ij20mr9985183qab.5.1348487401301; Mon, 24 Sep 2012 04:50:01 -0700 (PDT) Received: by 10.236.192.164 with SMTP id i24mr1499072yhn.14.1348487401275; Mon, 24 Sep 2012 04:50:01 -0700 (PDT) X-Newsgroups: pgsql.admin Date: Mon, 24 Sep 2012 04:50:01 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=66.87.0.127; posting-account=lc_-4QoAAADAwaU3-alPZhalkZK-lSTn References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <144ab3e9-3357-4fd1-92c3-3b2df4192ae7@googlegroups.com> Subject: Re: Multiple servers with Postgresql From: John Coryat Injection-Date: Mon, 24 Sep 2012 11:50:01 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable To: pgsql-admin@postgresql.org X-Pg-Spam-Score: -1.8 (-) X-Archive-Number: 201209/133 X-Sequence-Number: 40074 I'm currently running 8.4 (32 bit) in my production environment and want to= implement warm spare in that system. I have a test environment consisting = of two 64bit CentOS6 servers running 9.1 that I want to use hot spare / mas= ter with and when that system is working well, migrate to those servers ins= tead of the 32 bit 8.4 system. I've been using Postgres for many years and have a basic understanding abou= t tuning but I would like to hire (rent?) an expert to help fine tune the s= ystem, especially the test 9.1 environment so it can run more efficiently a= nd deal with the spikes in demand we have. Thanks. -John Coryat