Re: "could not receive data from client" && "incomplete startup packet"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Gauthier <davegauthierpg(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: "could not receive data from client" && "incomplete startup packet"
Date: 2018-02-08 14:49:14
Message-ID: 13271.1518101354@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Gauthier <davegauthierpg(at)gmail(dot)com> writes:
> It's a corporate "public" posting, so I can't simply install stuff there.
> However, I can request that new version(s) be put there. What version
> would you recommend ?

The important point is that you should be running the latest, or nearly
latest, minor release in whichever PG release series you've chosen.
The reason this list seems like such a fail:

>>> These are my options...
>>> ls -ld /tool/pandora64/.package/postgresql*
>>> drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016 /tool/pandora64/.package/postgresql-8.2.3
>>> drwxr-xr-x 8 pandora pandora 4096 Sep 16 2013 /tool/pandora64/.package/postgresql-8.3.0
>>> drwxr-xr-x 6 pandora pandora 4096 Aug 31 2015 /tool/pandora64/.package/postgresql-9.0.2
>>> drwxr-xr-x 6 pandora pandora 4096 Oct 11 2013 /tool/pandora64/.package/postgresql-9.3.0
>>> drwxr-xr-x 6 pandora pandora 4096 May 30 2014 /tool/pandora64/.package/postgresql-9.3.2
>>> drwxr-xr-x 6 pandora pandora 4096 Oct 19 2016 /tool/pandora64/.package/postgresql-9.6.0

is that whoever is producing the packages seems to be content to wrap one
early release in each branch (or some branches) and then never follow up.
Those early releases are, almost by definition, not as stable as their
branches will be in a year or two. They also contain known security
issues of assorted severities.

For reference, the current latest minor releases are 10.2, 9.6.7, 9.5.11,
9.4.16, 9.3.21 (all newly minted today, as it happens). The 9.0.x and
8.x.x release branches have been out of support for years.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Hirsch 2018-02-08 16:09:45 Odd behavior with 'currval'
Previous Message David Gauthier 2018-02-08 14:21:05 Re: "could not receive data from client" && "incomplete startup packet"