Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D578E1337B3E for ; Tue, 2 Nov 2010 12:20:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 31220-07 for ; Tue, 2 Nov 2010 15:20:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id E7E83133616B for ; Tue, 2 Nov 2010 12:20:37 -0300 (ADT) Received: from 89-158-241-48.rev.dartybox.com ([89.158.241.48] helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1PDIf2-0000Dj-TT; Tue, 02 Nov 2010 16:20:32 +0100 Received: by DimIMac.local (Postfix, from userid 501) id 297C21117DAF; Tue, 2 Nov 2010 16:20:27 +0100 (CET) From: Dimitri Fontaine To: Jonathan Tripathy Cc: Scott Marlowe , pgsql-general@postgresql.org Subject: Re: Replication Organization: 2ndQuadrant References: <4CCF1AC4.6060800@abpni.co.uk> <4CCF4187.8010205@abpni.co.uk> <4CCFB6CF.4060006@abpni.co.uk> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Tue, 02 Nov 2010 16:20:27 +0100 In-Reply-To: <4CCFB6CF.4060006@abpni.co.uk> (Jonathan Tripathy's message of "Tue, 02 Nov 2010 06:59:27 +0000") Message-ID: User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.419 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201011/121 X-Sequence-Number: 169187 Jonathan Tripathy writes: > What is the difference between the "Hot-Standby" and "Warm-Standby"? Is the > only different that the "Hot-Standby" standby servers are read-only, whereas > the "Warm-Standby" standbys can't be queried at all? That and the fact that running queries are not canceled at the time you flick the switch to have your standby a master. The ongoing read-only traffic is not affected. That's hot. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support