Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YWQET-0001eL-TD for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2015 14:06:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YWQES-0005Kr-ER for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2015 14:06:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YWQEF-0004zI-Al for pgsql-hackers@postgresql.org; Fri, 13 Mar 2015 14:06:19 +0000 Received: from mail-lb0-f175.google.com ([209.85.217.175]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YWQE8-0004Ew-Q4 for pgsql-hackers@postgresql.org; Fri, 13 Mar 2015 14:06:15 +0000 Received: by lbiz12 with SMTP id z12so23000229lbi.12 for ; Fri, 13 Mar 2015 07:06:11 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to :subject:references:in-reply-to:content-type :content-transfer-encoding; bh=Cvl6x+OIi5KRairM9vB2yl1e0m8xw+I6tlfaZNyU+fY=; b=bkVDxeqxhpL9x5K4m5O40GEz9o5PHcu9oyQ17TnuCpTTVmEa5KqyDEt2sSN7/FKEVM B2MYF4GWHC9kUGGfUfRfkyUC2XePB/XUKkni+EJ114h6s244ObODEz0Tb/F/MDZ/+sZG 6LvBdc3xcVVETG6KKH7+CvUNvQYrplSuqy6FTWaKU2EchEqjFUn0audOfkgM2VNnD+8x LMoy84zgEsejtoZJqcRR74s0ajHDgmV5LsgUtYXKzwxLvjqmBZZJwSAWkQeFvBdmaQeg UFyVzWxAnu5xlO47Z9+nX7nlYpD4lKtqpM4Zfqc5RLGZbnyL6SSoz4nPkM4zIaYYmMgH 74Ew== X-Gm-Message-State: ALoCoQlXleUIrRsk61IeiaOaVASJfO8w1hImAltbuQO8CGX6rFoZ/JqrecdH31CxQ+2UPWCXmGzo X-Received: by 10.112.157.100 with SMTP id wl4mr43870736lbb.108.1426255570982; Fri, 13 Mar 2015 07:06:10 -0700 (PDT) Received: from [192.168.21.17] ([193.110.198.7]) by mx.google.com with ESMTPSA id mm7sm419177lbb.30.2015.03.13.07.06.09 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 13 Mar 2015 07:06:10 -0700 (PDT) Message-ID: <5502EED5.3030904@2ndquadrant.com> Date: Fri, 13 Mar 2015 15:06:13 +0100 From: Petr Jelinek User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Andres Freund , pgsql-hackers@postgresql.org, Simon Riggs Subject: Re: recovery_target_action doesn't work for anything but shutdown References: <20150312145202.GD20199@awork2.anarazel.de> <20150312145354.GA22300@awork2.anarazel.de> In-Reply-To: <20150312145354.GA22300@awork2.anarazel.de> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 12/03/15 15:53, Andres Freund wrote: > On 2015-03-12 15:52:02 +0100, Andres Freund wrote: >> I guess what you actually intended to test was StandbyModeRequested? > > Err, EnableHotStandby. > Yeah pause does not work currently. This change was made by committer and I think the intended change was to make it a little safer by silently changing to shutdown instead of silently changing to promote which is essentially what was happening before the patch. But yes the check should have been against EnableHotStandby it seems. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers