Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkYkM-0004kf-9G for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jul 2018 17:47:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fkYkK-0000in-QB for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jul 2018 17:47:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkYkK-0000ig-JF for pgsql-hackers@lists.postgresql.org; Tue, 31 Jul 2018 17:47:44 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkYkD-0003w5-9J for pgsql-hackers@lists.postgresql.org; Tue, 31 Jul 2018 17:47:44 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id EC2BD21924; Tue, 31 Jul 2018 13:47:35 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 31 Jul 2018 13:47:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=WoRySUELGBWfQmdZZ+PE5M7OVEMlRsFe+NDPAcK9LPw=; b=XuuANAkO fv+GzV+AXA1z7cdEfbaNV3559/oih/QzWgDrLWILVGIBRWJbY7JV4LDyRdB2bexJ jkf/ivhOQR0RrIr/hROLiae2I97ZuIgojaD6hxccU5Z2n9rPowym9q/ZrMTf9AVv OUIsCDWSmRij/IRfC+WISw4n9BK5/FRCp78tMGHQbZqM1zBoOkfNIF+0TQ1rbq3y 9Pp65B4w4qRACtZRS4oZGM2BgBRYv7EmThVROxqyLVDna+k4dgWg0bJ2CqtolNM6 1P/HgqJ6842EzkECvuj9rP5Asaqlx+vF0soz/Wc/9Hmnld+O00ISKILzDcPFYO7n /WoP/ilTaDxPaQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=WoRySUELGBWfQmdZZ+PE5M7OVEMlR sFe+NDPAcK9LPw=; b=Pva16RpXGyYAPv6rQAtWzAda7PpizRxzV02vokMpK3Vwp 8z0e8cv+aYz2hOebBpYpEsMgEg7XhPcmrVXzOiGPEJm6VfRXytn4nRITqGcMcgOP a/8MWqVFfD9LfZmabxDu3kCbBmz68aiq3NlqAso6RHFUrar7zSF/cM6WcBrEFuYv 7Ro5Xzph4t5lVyaHgU15qG7tjtthbweXWkhNphclB41J7rD7ofWz87HKcwpD3YF4 +4/VtLyc3jUsIjMDBei3NFDgWCR3QNV34KVY2qQa3XGIW4PSz5Qq1HS4mBLH/IvN peb/wnvM8uoO9rFdEldVKLOht+Ay5wpApYXbBfcEA== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (77-246-194-58.cust.suomicom.net [77.246.194.58]) by mail.messagingengine.com (Postfix) with ESMTPA id 6C4DCE4621; Tue, 31 Jul 2018 13:47:34 -0400 (EDT) Date: Wed, 1 Aug 2018 02:47:32 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Kyotaro HORIGUCHI , pgsql-hackers@lists.postgresql.org Subject: Re: Documentaion fix. Message-ID: <20180731174732.GD2878@paquier.xyz> References: <20180731.190909.42582169.horiguchi.kyotaro@lab.ntt.co.jp> <20180731145914.sn35a3yhdyksmrc7@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="hK8Uo4Yp55NZU70L" Content-Disposition: inline In-Reply-To: <20180731145914.sn35a3yhdyksmrc7@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --hK8Uo4Yp55NZU70L Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jul 31, 2018 at 10:59:14AM -0400, Alvaro Herrera wrote: > How about pasting it like this? >=20 > alvherre=3D# select * from pg_replication_slots \gx > =E2=94=80[ RECORD 1 ]=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=AC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80 > slot_name =E2=94=82 node_a_slot > plugin =E2=94=82=20 > slot_type =E2=94=82 physical > datoid =E2=94=82=20 > database =E2=94=82=20 > temporary =E2=94=82 f > active =E2=94=82 f > active_pid =E2=94=82=20 > xmin =E2=94=82=20 > catalog_xmin =E2=94=82=20 > restart_lsn =E2=94=82=20 > confirmed_flush_lsn =E2=94=82=20 Each time this catalog is changed, this would become incorrect. My suggestion would be to change the query to that and call it a day: SELECT slot_name, slot_type, active FROM pg_replication_slots; -- Michael --hK8Uo4Yp55NZU70L Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAltgoLQACgkQnvQgOdby QH3LrxAAimzDAjFgQracIlIK9DxkTqXH2U+s5XS3fpdDB5pbyvOvK3el/WFjveDG PVPwxgwZ5AE6LvsR6rEnOrH1slpwdiUT3h6Aoq7cw7Wc6AwFhTGWL86uO4lO2n2u 5MudWuI2ke9zs9m9fOYmCYpXl588dD8TiNswx5mTzOOh3jyCJ069SJZgZPX6pcpV 0oUeEp5kw7qa4B532/Rga8b9GHIBrKgexlksc0ZuLTmCBsENlF74TOL8iFg/ybHy JPmHZC/sFI5Sg+wVivuXbptY8773B2UF2gC6ua6HbUBKIL3nJ/5gyrkEOJREHgqv 1o2Qe8z6AwxBSPULPftMeXoJro6hhCH43pNV2lzc9HfU6iIIWhpQgim5VwivOHbK dCaw5bbNlq71fQUapdIeEqfn6xAPfcczuBqKKqUgBFL4Cr7PBHD1baS2NVqnDICv /xw4LaMDquLMi/12wJSglNRJMhgonBj5SP4p1ZWVqKKvFomDTfOzG9HoiQmMmXdN yB/H8l4f86PFHEcFcDKHiHgJsXO5oRFZYcfAnLErPs123ddsAixzQ65SR2j+Lw91 fAuXXkNXC4n/apws+buO4KXaOFz0MeCqimg9YlH/QlBuq+l2rPRmpXbWCBwabHa+ mT45wALnf+YRYbiSv1+KhBnCwInau8pMwO04ttBi11IRKvdLZGg= =ysdO -----END PGP SIGNATURE----- --hK8Uo4Yp55NZU70L--