Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoCu1-00047d-IR for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 13:54:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoCu1-0004ZH-0b for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 13:54:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoCtz-0004Xg-9a for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 13:54:07 +0000 Received: from moutng.kundenserver.de ([212.227.126.186]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoCtw-00077o-6w for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 13:54:07 +0000 Received: from anarazel.de (p5DDC5FC6.dip0.t-ipconnect.de [93.220.95.198]) by mrelayeu.kundenserver.de (node=mrbap4) with ESMTP (Nemesis) id 0MBBkT-1VvbHb0EOT-00AEqG; Wed, 04 Dec 2013 14:54:02 +0100 Received: by anarazel.de (Postfix, from userid 1000) id 4AF621019EF; Wed, 4 Dec 2013 14:54:01 +0100 (CET) Date: Wed, 4 Dec 2013 14:54:01 +0100 From: Andres Freund To: Mitsumasa KONDO Cc: KONDO Mitsumasa , fabriziomello@gmail.com, Pgsql Hackers Subject: Re: Time-Delayed Standbys Message-ID: <20131204135401.GK24801@awork2.anarazel.de> References: <52984711.8040806@lab.ntt.co.jp> <529E8FE6.6040209@lab.ntt.co.jp> <20131204092233.GA26559@awork2.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Provags-ID: V02:K0:WadFhyhWmYA18CwrKkyCXxSevHDDUQGo2u6rDngtgu/ /13F1URFVeDh7ddjwr/q6eMs/5bEo8QSIkzVRIBl9yV2BDOF4y UaKbtHiUbV+kAIfepEMBbG1hUxHrNI8qRMce4yY288Loy+x3sr Ff5SMe1xmRAgbiVu4xvQ/7+XEHB5H4uSxSEEYo3YSiNu7tt2wf krws4ntJ6j9+HMQZFdDz4jGUxk0ajE7vWQbtWZLboAsE2G9wN1 K73HSpxzJxFnk9F3vPCrbl1aJZQ05s0pKlcCv/F3uQXFXQ6y8X YMTxrGg5fZkK7b+ZrLRS34dHbZni4voOnzoex8MRWhaoDtZrUN 491V4EeaFdt6cQdjV7oCrAbUcziVdfxU+/p5nXTvE X-Pg-Spam-Score: -1.9 (-) 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 2013-12-04 22:47:47 +0900, Mitsumasa KONDO wrote: > 2013/12/4 Andres Freund > When it happened, psql cannot connect standby server at all. I think this > behavior is not good. > It should only delay recovery position and can seen old delay table data. That doesn't sound like a good plan - even if the clients cannot connect yet, you can still promote the server. Just not taking delay into consideration at that point seems like it would possibly surprise users rather badly in situations they really cannot use such surprises. Greetings, Andres Freund -- Andres Freund 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