SAS recommends that you upgrade SAS^® Infrastructure Data Server (PostgreSQL) on SAS^® Viya^® 3.5 to version 15 to keep current with the latest security fixes for PostgreSQL. Upgrading the SAS Infrastructure Data Server is a separate step after installing the latest release of SAS Viya 3.5 as documented in Upgrade PostgreSQL.

You might encounter issues restarting the SAS Infrastructure Data Server after completing a successful upgrade. If you have not upgraded yet, complete the steps in the Upgrade section below. If you have upgraded and are encountering issues, complete the steps in the Remediation section below.

Upgrade

To avoid encountering PostgreSQL restart issues in which the start appears to stop responding, complete these steps:

1. Click the Hot Fix tab to access the hot fix and then apply it to SAS Viya 3.5 release 23w44.

2. Upgrade PostgreSQL by completing the steps in Upgrade PostgreSQL.

Remediation

If you already performed the upgrade to PostgreSQL 15 and are encountering issues restarting PostgreSQL, complete the remediation steps below.

Note: Remediation steps should only be performed if you have a PostgreSQL 15 cluster that is failing to start (hanging) AND you did not apply the hot fix before upgrading.

Remediation Steps

1. If starting PostgreSQL has stalled, exit the start by pressing Ctrl-C.
2. Click the Hot Fix tab in this note to access the hot fix and then apply it.
3. Rerun the sas-pgupgrade-cli script with the cleanup option: sas-pgupgrade-cli cleanup
4. Shut down the entire SAS Viya stack using your normal process or Viya-ARK.
5. Rerun the complete site.yml file.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Viya 3.x	Microsoft® Windows® for x64	3.5		Viya 3.5
		Linux for x64	3.5	3.5	Viya 3.5	Viya 3.5

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWin

---

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates

---

If you encounter an issue in which SAS Infrastructure Data Server on SAS Viya 3.5 does not restart after upgrading to PostgreSQL to version 15, a new "sas-pgupgrade-cli" script is needed, which is available in this hot fix.

Type:	Installation Note
Priority:	medium

Date Modified:	2023-12-22 13:31:09
Date Created:	2023-12-21 10:28:56