Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erZqm-0007Pn-7y for pgsql-docs@arkaria.postgresql.org; Fri, 02 Mar 2018 01:51:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1erZql-0006Gc-5Y for pgsql-docs@arkaria.postgresql.org; Fri, 02 Mar 2018 01:51:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erZqk-0006GS-Sf for pgsql-docs@lists.postgresql.org; Fri, 02 Mar 2018 01:51:07 +0000 Received: from [66.111.4.221] (helo=new1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erZqi-0002Qc-BL for pgsql-docs@postgresql.org; Fri, 02 Mar 2018 01:51:05 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.nyi.internal (Postfix) with ESMTP id 8D8031E60; Thu, 1 Mar 2018 20:50:43 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute4.internal (MEProxy); Thu, 01 Mar 2018 20:50:43 -0500 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= fm1; bh=W1f2CHnFdWdDMUQ4AzVS0UG0D49Mx2EKt+kQKOyC5vM=; b=A7x5l7bd W9sU+HldjC8ZM31BofVJe8S0Zg/SLcV6XrJTHle/StrUYFMhRC+9ut+2oP2DCN5I ViYmBfYq6gg8BjrAzNJHfDqKAbOpxMo95DqGuev/uwRdljEUAqtRrP5L/JKniM2E 9R1aTCt7VtspRuKSSasIWTYHYJkuP+x3deSlYrnX51i5I+6gW1UMY2+qB0Fb4/7n y0ATHdnRmEu7HpqVPUhGst3ifDm2poK9Fw/aWw71J68ojN7ZqYQ+93RLKGY0yPKf U/R1yH/mgtCxCSLZ8s3d+KXzZACdD5/lBe0y10wEZhwfqOepoPkABpACITTSTwvf WFztPfVg50AFEg== 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=fm2; bh=W1f2CHnFdWdDMUQ4AzVS0UG0D49Mx 2EKt+kQKOyC5vM=; b=AhEi/MH5t9/JKteknVvifKNWsUnbtCqJrWaiPnfiGDw/j Bx72S2a9SwqOv26S7ai01ZvoDiHmpssts1d3LOzYVtd+eTSXIVEfOVF13OvHEivM i52Uss9fFR73GMlJhSyhmqz7uF6dkUpmJxhQfCGPmsYd4hdlTd6/NNk+LbB2Xb49 Z1QXplSbyux47OOBRBZqlkgxRLscEnlpa4moiNUs9LxR/SY8KJzSzMKDaXEtzi6r 5xl+tNeDJPNdGZRt4DVoSmaSLEQo0MCTI1AIhcE+RkjyRZRqOCilw24xd//+LtIa 4wf49E0quo+XhJiPRe+82ZAbolkaCCcjcw0u4EC3A== X-ME-Sender: Received: from paquier.xyz (mp76f1fb57.ap.nuro.jp [118.241.251.87]) by mail.messagingengine.com (Postfix) with ESMTPA id 8FB567E3DC; Thu, 1 Mar 2018 20:50:41 -0500 (EST) Date: Fri, 2 Mar 2018 10:50:38 +0900 From: Michael Paquier To: Andres Freund Cc: Michael Paquier , Petr Jelinek , sahapasci@gmail.com, pgsql-docs@postgresql.org, Fujii Masao Subject: Re: libpq options Message-ID: <20180302014938.GC1186@paquier.xyz> References: <20171122132714.1463.27247@wrigleys.postgresql.org> <20180301093554.qrqgdnfwgs77tj23@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4Ckj6UjgE2iN1+kY" Content-Disposition: inline In-Reply-To: <20180301093554.qrqgdnfwgs77tj23@alap3.anarazel.de> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.221 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --4Ckj6UjgE2iN1+kY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Mar 01, 2018 at 01:35:54AM -0800, Andres Freund wrote: > On 2017-11-25 19:05:54 +0900, Michael Paquier wrote: >> A Boolean value of true tells the backend >> + to go into walsender mode, wherein a small set of replication co= mmands >> + can be issued instead of SQL statements. >=20 > This actually is wrong now I think. Petr? On more or less HEAD: $ psql -X -d "replication=3D1 dbname=3Dpostgres" postgres=3D# create table aa (a int); ERROR: cannot execute SQL commands in WAL sender for physical replication $ psql -X -d "replication=3Ddatabase dbname=3Dpostgres" postgres=3D# create table aa (a int); CREATE TABLE So one needs to use replication=3Ddatabase in order to be able to issue normal SQL statements, while replication=3Dtrue enforces physical replication where this cannot happen (no connection to a specified database). -- Michael --4Ckj6UjgE2iN1+kY Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlqYre4ACgkQnvQgOdby QH39vw//fHNORVy+GiHnXfLPpkZdUtxRFX7ujF+hiKQw5sNekxj8gUYA3VQrdw/e tcyoOiKsNkDUnk1zPmiP7GTel/M9Lomx4vC5g5KVTq/8ytMFUK71rngDnq7/MV+9 7XpIVL2www61DRD2kZiUs0G7wrcFQOya+56gHSo9fRs1hoD+tmr9/WUQulE+xS/2 OC+Y/nSMdBq9LMJccqiU20Myr0euXIzxC9WCc6rhRDN7OTR3vcbB4pzdgVuBEq29 HN6nngOQ0u/M5cgb3Mv5olsSoT/FNvextOIxuLIPmnDx0wPfhUuF19NNtPOa2idP 5oQ46M+fG/twY1EDOfwCz6ArJ9+NNu91hMUfddWoqqNto6Ibzn57p9b7Lo5gGEB8 W/hrsCMdUYaNBYmrrjJXfJDtvSvLSYbPok9l8IIEORJw8CTYqIM8M3YM8pOzymO6 GqIWe1/WXOfIazH6Ee3Br2+5MX6tu8eCT/LlM+ZxN9/6niK92vRi7+LS6eT/dpR2 1JHGtLC4g/NYkF8zfnwzqGmyDQvMXxNT9SDXYmvfS317mDF+SN7AD9X2voZIBUOj W4AavEnmhHw3ZAznb03BOWOGe1Ndn0mlFhkUiCXXiCB39cYUz2bjFmeRJxnhkpdo UUxU7w6VWwf8zdvyVzEl1c489SplhIotJaf81pBch/+vg6yp+0s= =Raqe -----END PGP SIGNATURE----- --4Ckj6UjgE2iN1+kY--