Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hfUDM-0000RI-Vv for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jun 2019 19:01:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hfUDL-0002jV-Le for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jun 2019 19:01:15 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hfUDL-0002jO-Cd for pgsql-hackers@lists.postgresql.org; Mon, 24 Jun 2019 19:01:15 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hfUDJ-0005UZ-9A for pgsql-hackers@postgresql.org; Mon, 24 Jun 2019 19:01:15 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 37CDC5F7B1; Mon, 24 Jun 2019 15:01:13 -0400 (EDT) Date: Mon, 24 Jun 2019 15:01:13 -0400 From: Stephen Frost To: Robert Haas Cc: Amit Kapila , Ian Barwick , "pgsql-hackers@postgresql.org" Subject: Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Message-ID: <20190624190113.GX2480@tamriel.snowman.net> References: <20190614160835.GF2480@tamriel.snowman.net> <20190616171610.GO2480@tamriel.snowman.net> <27dc9f8d-8d8f-9dd1-0494-5d8bd2f49a45@2ndquadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="9GYGtdBumnmR69ER" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --9GYGtdBumnmR69ER Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Robert Haas (robertmhaas@gmail.com) wrote: > On Sat, Jun 22, 2019 at 5:13 PM Stephen Frost wrote: > > All that said, whatever code it is that we write for pg_basebackup to d= o this properly should go into our client side library, so other tools can = leverage that and avoid having to write it themselves. >=20 > That is probably only going to help people who are writing in C (or > maybe some close family member) and a lot of tools for managing > PostgreSQL will be written in scripting languages. It is unlikely > that those people are going to get all of the rules for parsing a file > full of GUC settings exactly right, because translating flex into > Python is probably not anybody's idea of a fun time. So you'll end up > with a bunch of rewrite-postgresql.auto.conf tools written in > different languages at varying degrees of quality many of which will > misfire in corner cases where the GUC names contain funny characters > or the whitespace is off or there's unusual quoting involved. Calling into C functions from Python certainly isn't new, nor is it difficult to do from Perl, or various other languages, someone just needs to write the bindings. I'm not sure where the idea came from that someone would translate flex into Python, that's certainly not what I was suggesting at any point in this discussion. > If you just decreed that it was OK to append to the file, you could > avoid all that. As I said elsewhere on this thread, I have absolutely no problem with that as the documented approach to working with this file- but if that's what we're going to have be the documented approach, then everything should be using that approach... Thanks, Stephen --9GYGtdBumnmR69ER Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJdER34AAoJEO1sijiDR2RVDXkP/3vbAtdbUJGpoLDii3iqcGrG BWIC75fwIuLT1WTJOY+1BwbGszgjTQtwL4Ed9qv5Qvw/7R8hHWrlBY9WSMSf4yxT Zk3EuOXF9NzKlS/n7C38x//TQofkqBA6sPL64nurgFLRhHEq0rxOEKkJNHVeZtv6 nA7KdHZFV7qyHhNG+R7Fy6fUMI3strItadu5PyJ140AFsw3v/1CsFOAFhI1StBrm Wve69SUNxy2NFyFBhg21Z+ozdyuBCjDB60+tyfm9UfMyJOHKkG3GptPHreHWPhjx Wz5dl9uNeEPOeaZCHr4AY9cdSb3NOuINQ0BiSV1olVsCBNPSdSGbkebBXiSWbtTo 3WIx1Sv8l1yHrv/K9K2OL7IsjZkC/Vwo+AggXiMyDdSp02No6Zqwbii1L3tPIfs3 Q/y2tKpGaX4MeCLSI2ieAkC7xwMFxr7dccTjtyWT9cjwzuAZpewNr3EYPBBNAzY9 lWSl0JxL1QJy/sRKkdbib2HpnAgb4tdktfxe79FzX6iIdrQRmPVG+7RQKPDR4hWz sr7arAPW5ROM4oK+pTvy1xSVHAqtll62kksk6hq/6jDUbVGsOOLiJiNHi1DPZsO9 SHvkxgB6egBmZsKLjUA1GAFcGhsvLfftSqJSQ7dHxdsq94M/vlTscGBXf3GJHMwS J0cjWIjHVwfGKCc2Cmx0 =GwuX -----END PGP SIGNATURE----- --9GYGtdBumnmR69ER--