Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1frT0j-0000X2-6I for buildfarm-members@arkaria.postgresql.org; Sun, 19 Aug 2018 19:05:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frT0f-0007za-2Z for buildfarm-members@arkaria.postgresql.org; Sun, 19 Aug 2018 19:05:09 +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 1frT0e-0007zT-IX for buildfarm-members@lists.postgresql.org; Sun, 19 Aug 2018 19:05:08 +0000 Received: from mail-qt0-x242.google.com ([2607:f8b0:400d:c0d::242]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1frT0X-00020f-Fc for buildfarm-members@postgresql.org; Sun, 19 Aug 2018 19:05:07 +0000 Received: by mail-qt0-x242.google.com with SMTP id b15-v6so14010746qtp.11 for ; Sun, 19 Aug 2018 12:05:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:references:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=XXkFaUF0nyfq0YVmZhIrx6oQUynR+0v5lOSTP9wvJ7Q=; b=PaTEcoaNU5foxF+DFA6KKKiqdQezsckGT/6KKClt7wFbrgCTmasSxwPBmCHKW+PHT8 PW3upfH4DgaWlun0lGzp17wgLabG3uYUvdg47vc/ywNm0X6RzPjq176vBDAO6skkmXhi tFdoEf5nJuu6bMERS73/uGoCkB1K+qghxaZzITdu+BBsq48LfowORnvqqfasdzgftT7Z GTnvrDlAmQKvL3heYMbVHkQE8zs3duQLlTYIaqlxr4+MC+WQlWhYGFsAXbgartvJmwBp 9r/k24j1TJ3iARoXV3+YkJMyD7WFjMmbFHraEFsMAY83UxRktR11d+/xGc9qW0KI+oae EuEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=XXkFaUF0nyfq0YVmZhIrx6oQUynR+0v5lOSTP9wvJ7Q=; b=e+8BTJ3KeosDWLrCvHmu0qwfVb11m8/AvThdOYNUgTBdbatS9cUqkmDhXmSZjHCAoF Ue1DFLrBG1e3s+1t/JmoUdcaxRSiJgPWh958+at4+xFaluHymGUEORTa/+tuEOWVREin aCbvAqZ0ZXaCHGliWAfeQ2WnbIymRcv4ju/NcNcpV/lgLvkKuf1vqjfHmfgukVlAlZxM bs2W8eZmjVWK6m+YXMo79yghdsghhYQeP/Ay4IiQzYNwPP6pI4xmH/UPhQfkOYbapCty iHU92sPOMhRwNtaRq+AIulNvRdF/ff9p0FWwaeuJlkxWE5gouk6P3cnAMSuqH80nH6GC NPVg== X-Gm-Message-State: APzg51AhGL30fa6q9LtWR5xGYUj+aHEgDzF1TNFl6yvLkULjGYYfajw4 ZZbAqvDIrpDBoiLNBkNSjaPmlJI8F29AJVU+6mpH3ChVv7vwAb5VSk0AF8knskvh4B4rGwL7HsR 3k1JixITSz4LYwOOmdFYyVDe8YHk6icejORGmSbckZKKrteCfI8N8zo+UDVJV4oGctu7WGyU6pp uvQ3Wl67mWnc04PsCUng== X-Google-Smtp-Source: AA+uWPwGI0KmSUQMcJOSXoWPuW4DnZMe0jfDEyGu1fdSm6g6zlSNeQWmXnuXohfvHJnkBCWONgEtRw== X-Received: by 2002:aed:3302:: with SMTP id u2-v6mr4897242qtd.92.1534705500285; Sun, 19 Aug 2018 12:05:00 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id s8-v6sm505808qtc.71.2018.08.19.12.04.58 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 19 Aug 2018 12:04:59 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: many animals are running old clients To: Noah Misch , buildfarm-members@postgresql.org References: <144264ec-fd45-80eb-7642-109f920286b9@2ndQuadrant.com> <20180818070030.GA3795674@rfd.leadboat.com> <20180818162211.GC3795674@rfd.leadboat.com> Message-ID: <966eeb24-3f37-29da-dee2-91522bbe1850@2ndQuadrant.com> Date: Sun, 19 Aug 2018 15:04:58 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <20180818162211.GC3795674@rfd.leadboat.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 08/18/2018 12:22 PM, Noah Misch wrote (offlist): > On Sat, Aug 18, 2018 at 08:17:17AM -0400, Andrew Dunstan wrote: >> >> Is there anything I can do to make upgrade easier? > The show_log.pl web page could highlight a particular run's config change, > including version number changes, when there is such a change compared to the > previous run. If it's clear enough that folks are unlikely to confuse an > upgrade-induced failure with a PG-commit-induced failure, I could stop checking > for post-upgrade buildfarm failures. What I've done is add this to the database in a way that makes it easily accessible to the web app, and added that info to the history page. I might break that out into a separate history at some stage. > > It wouldn't make an upgrade easier, but the "Flags" column of show_status.pl > could give an extra badge for being on the latest version. That would motivate > some folks. Yes, I'll look at this, although I'm reluctant to make the dashboard any more busy. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services