Subject: Re: Can we stop defaulting to 'ident'?
To: Stephen Frost <sfrost@snowman.net>
References: 
 <CAMsr+YFCuBGWh4=aM-K2LCsBEwcrqm=pphKKHEH09vHwXcspow@mail.gmail.com>
 <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>
 <20200520153337.GE3418@tamriel.snowman.net>
Cc: Christoph Berg <myon@debian.org>, =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?=
 <devrim@gunduz.org>, Craig Ringer <craig@2ndquadrant.com>,
 pgsql-pkg-yum <pgsql-pkg-yum@postgresql.org>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <074a1634-450f-1e2f-53aa-178de3ac1076@2ndquadrant.com>
Date: Thu, 21 May 2020 00:36:30 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <20200520153337.GE3418@tamriel.snowman.net>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 2020-05-20 17:33, Stephen Frost wrote:
>> But this leads to other questions, like, what should pg_upgrade do?
> Same as it always has- make the user deal with anything they need to
> regarding postgresql.conf?  Why would anything change with pg_upgrade?

Well, one might expect that the user at least gets some kind of 
notification that something is changing.  What happens when you end up 
with a mix of MD5 and SCRAM passwords in pg_authid?  Are users going to 
be notified about this somehow?  Has this been thought through to the 
end?  Have all combinations been tested?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services