Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jc3VQ-0004og-0a for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 22 May 2020 08:58:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jc3VO-0005vy-RI for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 22 May 2020 08:58:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jc3VO-0005vr-M5 for pgsql-pkg-yum@lists.postgresql.org; Fri, 22 May 2020 08:58:14 +0000 Received: from ns5.gunduz.org ([107.170.136.15] helo=ns1.gunduz.org) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jc3VI-0001FP-2x for pgsql-pkg-yum@postgresql.org; Fri, 22 May 2020 08:58:13 +0000 Received: from asus-laptop06.gunduz.org (unknown [31.14.249.174]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id 81CB93FDBB; Fri, 22 May 2020 08:58:04 +0000 (UTC) Message-ID: <0ef8211aac548796a5e66bf5d916966409e37457.camel@gunduz.org> Subject: Re: Can we stop defaulting to 'ident'? From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: Peter Eisentraut , Stephen Frost Cc: Christoph Berg , Craig Ringer , pgsql-pkg-yum Date: Fri, 22 May 2020 09:58:01 +0100 In-Reply-To: References: <7761d006b5ace13a4d86ce489123e5004aaf8b6c.camel@gunduz.org> <20200519212710.GQ13712@tamriel.snowman.net> <6089d4c8e262dd6fe8a6510c283e674543a24b5c.camel@gunduz.org> <3869d8c9-c212-8d73-52f4-13b03abe4813@2ndquadrant.com> <20200520134035.GD296739@msg.df7cb.de> <3a7d55ed-6abb-2005-23d7-8411bb9f5651@2ndquadrant.com> <20200520145752.GD3418@tamriel.snowman.net> <32b7fe66-f0e6-42e5-3c95-7d123e7d7f6d@2ndquadrant.com> Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="=-I2b4X/DykOYjumkVRS9K" User-Agent: Evolution 3.36.2 (3.36.2-1.fc32) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-I2b4X/DykOYjumkVRS9K Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, On Fri, 2020-05-22 at 10:52 +0200, Peter Eisentraut wrote: > I found that if you use initdb's -A option to set the default=20 > authentication method, then the passsword_encryption setting is=20 > automatically adjusted in postgresql.conf. So this patch probably > isn't even necessary. Right, but then it also sets scram auth for local connections as well (which we don't want) That's why I am using --auth-local and --auth-host at the same time. Regards, --=20 Devrim G=C3=BCnd=C3=BCz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR=20 --=-I2b4X/DykOYjumkVRS9K Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAl7HlBkACgkQ2MM9/pLP brWMDxAAqWKA91pA4QIVf94jzgqPAFvC1mJbgVmIkmp+SfJYDJJauDrft9q3Vy5o ztQk3zknmcOKHFQPS2U8bzp0rX7jipEqg/tP9qrenMben0asJenC7vM18g59Jul8 Tmwz1M0QkzX1CV4Xi/stsNbNwM/xKI6EDD55kGbbix5h0T7cDzAxTY1XQKSsYddr gyrMJ+AQNpqadWoeWT5w8y4eW9c1bcm8fvOtmsIQS9lSQqwD/Gc2wOb3zLTgWAV2 O0xb+EHY0f9IUFvQLACbhSzioe0eTMA7Tmk9iA5+iUzeRs0/yhxLor15C9+QGsBJ 5pY+3uoEp1mk949A9VhdflNWL1io1P7nnWURfMtM17uiPCu4+pq7eMxw08VmwkOg nODNqd/foCVXA7I+VsnWKKc2Th+tK9R0TsFRAhA8eVU3nu569vzoDRmtqyZ+ZlJd gP+OFPiBoAtsghGbdTr2CTfJloQxhR4qXglmNtbXff13v+5Y0iK3PavIGA9izomb kPT56/Nske5SzeLY/eQsqp9W4WhfRmX/ufAl2p4MPTMf7ndf8+SvjiU4RTRbdNcr jYuzFmYV0W6pqXA5A83W0AId4B6KiW+NiDrMlgyL97fzpnVpcATqbCAE73WOsjMI +6bpdH0cOnum77jnbR/DwDLVL81uGkiU04GCqhKtXSv92m2XpmI= =lWVQ -----END PGP SIGNATURE----- --=-I2b4X/DykOYjumkVRS9K--