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 1fvKhD-0007K7-FX for buildfarm-members@arkaria.postgresql.org; Thu, 30 Aug 2018 11:01:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fvKhB-0007iQ-8H for buildfarm-members@arkaria.postgresql.org; Thu, 30 Aug 2018 11:01:01 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fvKhB-0007iJ-3X for buildfarm-members@lists.postgresql.org; Thu, 30 Aug 2018 11:01:01 +0000 Received: from mail-wr1-x441.google.com ([2a00:1450:4864:20::441]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fvKh6-0004w6-PW for buildfarm-members@postgresql.org; Thu, 30 Aug 2018 11:01:00 +0000 Received: by mail-wr1-x441.google.com with SMTP id j26-v6so7658135wre.2 for ; Thu, 30 Aug 2018 04:00:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=jkT4MqkFeO4d9kmvWPdN9cqhdY90cbatOK8lDuLrZfs=; b=Q5MjpHy9R2wuKrQlVbzGqQ7+256oe4JrxVNxxP4aoXBKzA3R/bcA94iqA5Kx46gX/p lPDvZ/181LUPNW3lPhhBGB5DevQpt1wU57ufSy8FCuK5CLEaGRcMfwY2uqDfSui9/DI3 +JJji75kFOqQfsjZgAD2KV68LqWPMG3dX1/zerEUlbd4jkJ4kLJUxrSLlslhn/BDDggT RuzKdF15IIwgPvQhP82gQALWJnxeXgSNv8A/e+7eqd+ocSP2AFcVdQKK0BXpP/k9a4zc NQye3S1k7tvSlwzs3U76+yUFZ2xHBNm+2rIaPqbt2a2EUYDZGwGJgNdOjqyomytxA2sL CiOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=jkT4MqkFeO4d9kmvWPdN9cqhdY90cbatOK8lDuLrZfs=; b=ZvB7hfZzidfdgSlVb4+0ywmsehtOu+iOfJtgNFTB7WtTWcRq4syzDfAz6A0xzg/RjS lC5qroak2eDbOXS8JYpoUVZbzRv5Sp5G+uYRFS7EOdGVXZSar8RGppJgAB+JLpqvsz7D ujnBIB+u59VTZbSEOmx+UXK36EMEiSk2mF90bzm91NtJOeWKCMoDMhrdiVPCTYv5B6/m zA2uVDCOzY6F9Q2uS4Cv5nJZ45787Bm2X9J+05VBP6deVzahTtGynPkN+S/S+jvOZU13 RcU4C10IBShXXGmZh8glPQ/Y1/ddrh552ff8Ba/6kwj1dO872NqN++cpY7N3WwnyiN7u jl0A== X-Gm-Message-State: APzg51DpxVF0FHBMIMkg6qectLRW8jXibrBZRsEKYOoah8rs0RuMIwlt nUrLNLh/GEBFkaRqwCWReJtvNp36d9RBJ0DN7ZN9Sg== X-Google-Smtp-Source: ANB0VdbHSkjVyX3dyfBcVoDEM+8sFYunh1fu6m6d9zjZjzV2mRFWASwt9yc0WyPvqi9H/kGseCm/zATxS9U4IDzuh8o= X-Received: by 2002:adf:9a21:: with SMTP id z30-v6mr6688360wrb.47.1535626855881; Thu, 30 Aug 2018 04:00:55 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a1c:89d1:0:0:0:0:0 with HTTP; Thu, 30 Aug 2018 04:00:54 -0700 (PDT) In-Reply-To: <5b87cbc3.1c69fb81.648e2.5581@mx.google.com> References: <5b87cbc3.1c69fb81.648e2.5581@mx.google.com> From: Dave Page Date: Thu, 30 Aug 2018 12:00:54 +0100 Message-ID: Subject: Re: many animals are running old clients To: Darcy Buskermolen Cc: Tom Lane , Andrew Dunstan , buildfarm-members@postgresql.org Content-Type: multipart/alternative; boundary="00000000000040b3ef0574a4fd82" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000040b3ef0574a4fd82 Content-Type: text/plain; charset="UTF-8" On Thu, Aug 30, 2018 at 11:49 AM, Darcy Buskermolen wrote: > That particular era of equipment is still quite prominent in telecom > central office environments, and I know of several telcom nms solutions > that use PostgreSQL. However having said that it's of little likelyhood > that those are being updated to use newer versions of postgres or even > wether or not they receive security/bugfixes.... > Right - we have some customers in that category; they're usually the ones asking for extended support on ancient releases. > > > > > > Sent on the go, from somewhere other than here. > > -------- Original message -------- > From: Dave Page > Date: 2018-08-30 05:32 (GMT-06:00) > To: Tom Lane > Cc: Andrew Dunstan , > buildfarm-members@postgresql.org > Subject: Re: many animals are running old clients > > > > On Wed, Aug 29, 2018 at 11:17 PM, Tom Lane wrote: > >> Andrew Dunstan writes: >> > On 08/29/2018 10:35 AM, Dave Page wrote: >> >> It's very far from a 5 minute job on ancient Solaris boxes :-( >> >> > Please let me know when issues like this arise. >> >> One thing of the same ilk is that a few months ago I had to give up on >> using https reporting on gaur/pademelon, and switch back to http. >> I don't think that was your fault, because it was not associated with a >> buildfarm client upgrade. It appeared to me that the pginfra folk had >> changed something to require newer TLS versions in https connections to >> the buildfarm server. Like Dave, I spent a fair while trying to install >> new-enough Perl modules to fix that, without a lot of success: newer >> Perl code doesn't compile on that platform. >> >> It's debatable of course how much anyone cares about buildfarm animals >> that are this old. I've already shut down pademelon since its compiler >> never heard of C99, and I don't see much point in running it on just >> the back branches. >> > > Right - I do wonder that about this machine (whether it's worth > supporting, not whether its compiler supports C99). Here's what we're > talking about: > > -bash-3.00$ cat /etc/release > Solaris 10 11/06 s10s_u3wos_10 SPARC > Copyright 2006 Sun Microsystems, Inc. All Rights Reserved. > Use is subject to license terms. > Assembled 14 November 2006 > -bash-3.00$ prtconf -b > name: SUNW,Sun-Blade-1000 > model: SUNW,501-6230 > banner-name: SUNW,Sun-Blade-2000 (2 X UltraSPARC-III+) > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --00000000000040b3ef0574a4fd82 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, Aug 30, 2018 at 11:49 AM, Darcy Buskermolen &= lt;darcyb@gmail.com> wrote:
That parti= cular era of equipment is still quite prominent in telecom central office e= nvironments, and I know of several telcom nms solutions that use PostgreSQL= .=C2=A0 However having said that it's of little likelyhood that those a= re being updated to use newer versions of postgres or even wether or not th= ey receive security/bugfixes....

Right - we have some customers in that category; they're usually the = ones asking for extended support on ancient releases.
=C2=A0




Sent on the go, from somewhere other than here.



On Wed, Aug 29, 2018 at 11:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andrew Dunstan <andrew.dunstan@2ndquadrant.= com> writes:
> On 08/29/2018 10:35 AM, Dave Page wrote:
>> It's very = far from a 5 minute job on ancient Solaris boxes :-(

> Please let me know= when issues like this arise.

One thing of the same ilk is that a few months ago I had to give up = on
using https reporting on gaur/pademelon, and switch back to http.
I don't think that was your fault, because it was not associated with a=
buildfarm client upgrade.=C2=A0 It appeared to me that the pginfra folk had=
changed something to require newer TLS versions in https connections to
the buildfarm server.=C2=A0 Like Dave, I spent a fair while trying to insta= ll
new-enough Perl modules to fix that, without a lot of success: newer
Perl code doesn't compile on that platform.

It's debatable of course how much anyone cares about buildfarm animals<= br> that are this old.=C2=A0 I've already shut down pademelon since its com= piler
never heard of C99, and I don't see much point in running it on just the back branches.

Right - I do wonder = that about this machine (whether it's worth supporting, not whether its= compiler supports C99). Here's what we're talking about:

-bash-3.00$ cat /etc/release
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Solari= s 10 11/06 s10s_u3wos_10 SPARC
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0Copyright 2006 Sun Microsystems, Inc.=C2=A0 All Rights Reserved.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 Use is subject to license terms.
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0Assembled 14 November 2006
-bash-3.00$ prtconf -b
=
name:=C2=A0 SUNW,Sun-Blade-1000
model:=C2=A0 SUNW,501-6230
banner-name:=C2=A0 SUNW,Sun-Blade-2000 (2 X UltraSPARC-III+)
=

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

E= nterpriseDB UK: h= ttp://www.enterprisedb.com
The Enterprise PostgreSQL Company



-= -
Dav= e Page
Blog: h= ttp://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK:= http://www.enter= prisedb.com
The Enterprise PostgreSQL Company
--00000000000040b3ef0574a4fd82--