PostgreSQL 11 End of Life

[Esben_D]

PostgreSQL 11 is going end of life on November 9. You can find all the details and a report to view the EOL status of your installations in the EOL blog post.

[Mister_Nobody]

We have modified report.

New functions:

1. support linux
2. server filter for linux
3. install date for windows and linux
4. description of linux package
5. postgres 15 and 16 lifecycle

Select Distinct Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.IPAddress,
  tblAssets.Domain,
  tblAssets.AssetName,
  IsNull(tsysOS.OSname, tblLinuxSystem.OSRelease) As OS,
  tblSoftwareUni.softwareName As Software,
  subquery1.Version,
  IsNull(tblLinuxSoftware.InstallDate, tblSoftware.InstallDate) As Installdate,
  IsNull(tblSoftwareUni.SoftwarePublisher, tblLinuxSoftware.description) As
  [Publisher/Description],
  Case
    When tblLinuxSoftware.description Like '%server%' Or
      tblLinuxSoftware.description Like
      '%Most Advanced Open Source Relational Database' Then 'server'
    When tblLinuxSoftware.description Is Null Then 'Server on Windows?'
    Else 'unknown'
  End As ServerEdition,
  subquery1.EOLDate,
  Case
    When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
      subquery1.EOLDate) As NVARCHAR) + ' days remaining'
  End As [Days Remaining],
  tblAssets.Lastseen,
  Case
    When GetDate() > subquery1.EOLDate Then '#ffadad'
    When GetDate() >= DateAdd(month, -1, subquery1.EOLDate) Then '#ffd152'
    Else '#d4f4be'
  End As backgroundcolor
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Left Join (Select t.softwareVersion As Version,
      t.softID,
      Case
        When Cast(Left(t.softwareVersion, PatIndex('%[^0-9]%', t.softwareVersion
          + 't') - 1) As bigint) < 6 Then '2003-01-01'
        When t.softwareVersion Like '6.3%' Then '2003-03-01'
        When t.softwareVersion Like '6.4%' Then '2003-10-30'
        When t.softwareVersion Like '6.5%' Then '2004-06-09'
        When t.softwareVersion Like '7.0%' Then '2005-05-08'
        When t.softwareVersion Like '7.1%' Then '2006-04-13'
        When t.softwareVersion Like '7.2%' Then '2007-02-07'
        When t.softwareVersion Like '7.3%' Then '2007-11-27'
        When t.softwareVersion Like '7.4%' Then '2010-10-01'
        When t.softwareVersion Like '8.0%' Then '2010-10-01'
        When t.softwareVersion Like '8.1%' Then '2010-11-08'
        When t.softwareVersion Like '8.2%' Then '2011-12-05'
        When t.softwareVersion Like '8.3%' Then '2013-02-07'
        When t.softwareVersion Like '8.4%' Then '2014-07-24'
        When t.softwareVersion Like '9.0%' Then '2015-10-08'
        When t.softwareVersion Like '9.1%' Then '2016-10-27'
        When t.softwareVersion Like '9.2%' Then '2017-11-09'
        When t.softwareVersion Like '9.3%' Then '2018-11-08'
        When t.softwareVersion Like '9.4%' Then '2020-02-13'
        When t.softwareVersion Like '9.5%' Then '2021-02-11'
        When t.softwareVersion Like '9.6%' Then '2021-11-11'
        When t.softwareVersion Like '10%' Then '2022-11-10'
        When t.softwareVersion Like '11%' Then '2023-11-09'
        When t.softwareVersion Like '12%' Then '2024-11-14'
        When t.softwareVersion Like '13%' Then '2025-11-13'
        When t.softwareVersion Like '14%' Then '2026-11-12'
        When t.softwareVersion Like '15%' Then '2027-11-11'
        When t.softwareVersion Like '16%' Then '2028-11-09'
        When Cast(Left(t.softwareVersion, PatIndex('%[^0-9]%', t.softwareVersion
          + 't') - 1) As bigint) > 16 Then '2029-11-01'
      End As EOLDate,
      t.AssetID
    From (Select it1.AssetId,
          it1.softId,
          it1.softwareVersion
        From tblsoftware it1
        Union All
        Select it2.AssetId,
          it2.SoftwareUniId,
          it2.Version
        From tblLinuxSoftware it2) t) As subquery1 On subquery1.AssetID =
      tblAssets.AssetID
  Left Join tblSoftwareUni On tblSoftwareUni.SoftID = subquery1.softID
  Left Join tblLinuxSoftware On tblLinuxSoftware.SoftwareUniId =
      subquery1.softID And tblLinuxSoftware.assetid = tblAssets.assetid
  Left Join tblSoftware On tblSoftware.SoftId = subquery1.softID And
      tblSoftware.assetid = tblAssets.assetid
Where tblSoftwareUni.softwareName Like 'Postgres%'
Order By tblAssets.assetname