Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 49C56B53E86 for ; Fri, 25 May 2012 13:01:36 -0300 (ADT) Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SXwxK-0004W7-DZ for pgsql-admin@postgresql.org; Fri, 25 May 2012 16:01:36 +0000 Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 0761CE00EC84; Fri, 25 May 2012 09:01:19 -0700 (PDT) Message-ID: <4FBFACCF.3040001@pinpointresearch.com> Date: Fri, 25 May 2012 09:01:19 -0700 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: pgsql-admin@postgresql.org, Matthias@marlinmobile.com Subject: Re: introduction References: <4FBF9FC0.5060704@marlinmobile.com> In-Reply-To: <4FBF9FC0.5060704@marlinmobile.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/92 X-Sequence-Number: 39581 On 05/25/2012 08:05 AM, matthias wrote: > Hello everyone, > > I have some postgres experience, but not so much with clusters/slony > Someone is suggesting a HA solution, and I do not have the time to > wrap my head around it right know, not to mention support. Are you using clustering for redundancy or for sharding/scaling? For redundancy, the current built-in replication is the easiest to set up with no add-ons needed. You may find it very beneficial to engage a PostgreSQL-savvy consultant or firm who has encountered your use-pattern and can guide you. > > Does anyone have a suggestion for a host that offers turnkey solutions > for clustered postgres hosting? You might see what Heroku offers: https://postgres.heroku.com/ I haven't used them as we run all our own servers but they have been kind hosts for our users-group in SF. > Our current provider answered my questions that they had heard of a > client "who did this once". They had no idea what slony means. So I am > not feeling so warm and fuzzy about them. Good call. Cheers, Steve