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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1m44Nv-0007hI-89
	for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Jul 2021 16:38:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1m44Nt-0004la-Tc
	for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Jul 2021 16:38:49 +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 <jan@wi3ck.info>)
	id 1m44Nt-0004lS-M6
	for pgsql-hackers@lists.postgresql.org; Thu, 15 Jul 2021 16:38:49 +0000
Received: from mail-qk1-x72c.google.com ([2607:f8b0:4864:20::72c])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <jan@wi3ck.info>)
	id 1m44Nr-0001NS-Op
	for pgsql-hackers@lists.postgresql.org; Thu, 15 Jul 2021 16:38:48 +0000
Received: by mail-qk1-x72c.google.com with SMTP id s6so5763326qkc.8
        for <pgsql-hackers@lists.postgresql.org>;
 Thu, 15 Jul 2021 09:38:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=wi3ck-info.20150623.gappssmtp.com; s=20150623;
        h=subject:to:references:from:message-id:date:user-agent:mime-version
         :in-reply-to:content-language:content-transfer-encoding;
        bh=3PCAld1g9k0Mdl8vb5AMQ7uGU4dGnUVGTDP88gDYSmA=;
        b=nE7b4N1LGl5j4MfidMX86gcRz8eTogA4QxaqPyoaHelaJZ3P5NDNT5FWp7L+wbbf2R
         Lo8wK6Y/DuOF4MkRuLaGc63F8ehIxMPdoJ2Qx+/UJQ1fNIY5JMj2rixIOcxVmflT6TV7
         cN9KwXo8v1cSkoWfxFyd9jI8JWkOnbMjonVZLPRn+BodvkueK/7Dr7izFOxfL71RpG7n
         UDU9dHUiYJFGnxbsFH5c9yXaPKfQYqjXr1JEgxwbjmCOp3E7ULMxcBpfzzemmaRM7rMQ
         KedphjBtMBGXvg5ep3LoClvsAr4qk/uxCEkzgVnPy586ADskI/Ohds2rEFDuSDXFpdTr
         vPIQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:subject:to:references:from:message-id:date
         :user-agent:mime-version:in-reply-to:content-language
         :content-transfer-encoding;
        bh=3PCAld1g9k0Mdl8vb5AMQ7uGU4dGnUVGTDP88gDYSmA=;
        b=Lvaurz5hwEdtP90tI6erKq4OBph16cz5X3bQ5IBKqOGtOfaqKVyo914hhNkltatzgc
         o85/DwjjCzZ46Qm0x63g/vIb4cERD98bOpnSh/4z+bnTf4qj0QHl2R2ysUPMxgVovDIR
         RDYiga1JBhGIatEVNJWpwef2SrnotvpRjT5QptdKANUWOIKFpIkf6brSydzXQKQShIcy
         vaf2zr4ckX5WbHgG3qxKa0a0Mpf1KTxI6+F9dkaihkNgSqux1EjuMRUxxktPSZq44XlM
         AIFeKiLHdoKEJ0ql+Hdy4GQMBD+4Xnhdw+2T5oIQR0E2ykmQVorW3q9dJWkUltwwNZ+/
         CL9Q==
X-Gm-Message-State: AOAM5327uhu6NxUOY16JEGzBGH2phOJwMICT2gEJvzFyDgomo2KUKQ8e
	xMlawnWj/RP5SEhyZgSLrBZJd1pq+QbCizGI
X-Google-Smtp-Source: 
 ABdhPJxX3qhAMyOyFujxgpq39UxYlNUAeYPtyJ0mUlSzOm+KluXaLhjEVtHphanZfuZOULMwyYJqpQ==
X-Received: by 2002:a37:4393:: with SMTP id
 q141mr4804144qka.273.1626367126797;
        Thu, 15 Jul 2021 09:38:46 -0700 (PDT)
Received: from jupiter.onmars.wi3ck.info
 (pool-108-16-1-20.phlapa.fios.verizon.net. [108.16.1.20])
        by smtp.gmail.com with ESMTPSA id
 u3sm2249501qtg.16.2021.07.15.09.38.46
        for <pgsql-hackers@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 15 Jul 2021 09:38:46 -0700 (PDT)
Subject: Re: pg_upgrade does not upgrade pg_stat_statements properly
To: pgsql-hackers@lists.postgresql.org
References: 
 <CADK3HHKawwbOcGwMGnDuAf3-U8YfvTcS8jqDv3UM=niijs3MMA@mail.gmail.com>
 <CAKFQuwY9bAJ7m0eY7aRJxF8QLZFzTJE-yO9q2Ltg8JVv=RW+wA@mail.gmail.com>
 <CADK3HHL88084=-v_4ubFD4Jf2j+V8rjxLDnV1yLWn2bmVfn+Zw@mail.gmail.com>
 <CAKFQuwbyfEMqsei49aBgYvQtkiskBs2TEf9mVT=k6Yijk12J0A@mail.gmail.com>
 <CADK3HHJQ=GoGcH0u2Yf2Sbes+161xMwFd4FDNGzUViH4ncbeEw@mail.gmail.com>
 <3562835.1626291827@sss.pgh.pa.us>
 <CADK3HHJJm_EocOX5Jtvus2pYw_mSFH99t02fOP00K2D-hNfVRA@mail.gmail.com>
 <CAKFQuwZ7Cg3aD+oiBL7FE+F-tS_Bn5Lg4TqLpe-BxRoeazPS9w@mail.gmail.com>
 <CAKFQuwZhCVAhsjBX7vnBxAkK1XvzHci=J_-ibZyLpNtrt2fMcg@mail.gmail.com>
 <CADK3HHJcAQw_dJwyt1Z_c268R30PCAXYRUkkWucG3DKH5hNg-A@mail.gmail.com>
 <CAKFQuwax=XC5MSii-dB6AHg5Z2eZLvZEUG6r9BRtymy98ir1Fw@mail.gmail.com>
 <CADK3HHKXWBtyxVXBsBf8RKibaLusWGE3Y+b4iQ_xfrTQKupQZA@mail.gmail.com>
 <CAKFQuwbkk1R0wUHFVc_22X6eVoLq=brwnVm2ytdhnLOtLObTew@mail.gmail.com>
 <MN2PR05MB67992FAC37E5E7E04077FE50DB129@MN2PR05MB6799.namprd05.prod.outlook.com>
From: Jan Wieck <jan@wi3ck.info>
Message-ID: <41d3e282-7bd2-29d9-fb4e-8e4254dbe437@wi3ck.info>
Date: Thu, 15 Jul 2021 12:38:45 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: 
 <MN2PR05MB67992FAC37E5E7E04077FE50DB129@MN2PR05MB6799.namprd05.prod.outlook.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/41d3e282-7bd2-29d9-fb4e-8e4254dbe437%40wi3ck.info>
Precedence: bulk

On 7/15/21 12:31 PM, Robert Eckhardt wrote:
>   I don’t know if this is a terrible flaw in pg_upgrade, it is a 
> terrible flaw in the overall Postgres experience.

+1 (that is the actual problem here)


-- 
Jan Wieck