Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A84856322C0 for ; Mon, 16 Feb 2009 16:01:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44644-03 for ; Mon, 16 Feb 2009 16:01:17 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f167.google.com (mail-gx0-f167.google.com [209.85.217.167]) by mail.postgresql.org (Postfix) with ESMTP id 330B46330CD for ; Mon, 16 Feb 2009 16:01:17 -0400 (AST) Received: by gxk11 with SMTP id 11so1433384gxk.19 for ; Mon, 16 Feb 2009 12:01:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=C77HBGHBgWwmeREL5sdDeCy4tXlVglOD47T9T/FfTmU=; b=ME+9WRDceqRti4wg64DAHClCfUE8vO/2JyqGl44UcV2nnZN5Isiz70JqehLKiZrWLW rVVKP7usglUKCunRWbEAMRokD2nsq6EdL/9/SJRrxWUAtOlTLtRZz0tGrIfEAA1NDOPK BOwY0H7JUwjBsBdaq9kFPM/grGyz+boHRjllY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=hv2nGDGSpev191rKyx96QVbmOrICEXh6y+aZMX3xWShSkAt2j5i0qPJ43AxcXiT1VB FhiXfglYmJPR3j2XGKb7T16vmg1B7NvwgCRIzOZACQfYcwHecC0RoNVjIeaHUHoq1093 2gZORYrtZNmWUgFIwK2Zy+Hwax9WlD6gWmikc= MIME-Version: 1.0 Received: by 10.151.108.5 with SMTP id k5mr434163ybm.48.1234814475710; Mon, 16 Feb 2009 12:01:15 -0800 (PST) In-Reply-To: <3a0028490902161152l13cc82eva6b26c013776cbcf@mail.gmail.com> References: <3a0028490902161152l13cc82eva6b26c013776cbcf@mail.gmail.com> Date: Mon, 16 Feb 2009 13:01:15 -0700 Message-ID: Subject: Re: Downtime From: Scott Marlowe To: Rafael Domiciano Cc: "pgsql-admin@postgresql.org" Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/106 X-Sequence-Number: 31327 On Mon, Feb 16, 2009 at 12:52 PM, Rafael Domiciano wrote: > Hello for all, > > Our bussiness do not tolerate anymore downtime (the downtime is estimate at > 10 hour / year - that involves upgrade of hardware, crash of hardware), and > using Slony-I 1.2.15 I have waste time to put the slave node on production. > So I'm studying some replications softwares, like pgpool, pg_cluster, > pg_replicator. What exactly was not good enough about slony? We use it for automated failover which is initiated by the application if it detects the master go down. Works pretty well. Our downtime for unscheduled maintenance is well under an hour a year with this setup.