Determine whether you need a new order for PostgreSQL 15 on SAS® Viya® 3.5 (Windows)


PostgreSQL 15 is available on SAS Viya 3.5 starting with the 23w44 revision in November 2023. However, in order to obtain PostgreSQL 15 on SAS Viya 3.5, a new SAS software order is required. All new SAS Viya 3.5 deployments using a SAS software order from 23w44 or later include PostgreSQL 15 by default. Existing SAS Viya 3.5 deployments need to be upgraded to SAS Viya 3.5 using an order from 23w44 or later. 

If you are interested in obtaining PostgreSQL 15 on SAS Viya 3.5 (Windows), complete the following checks to determine how to proceed.

For SAS Viya 3.5 Linux environments see SAS KB0037227, "Determine whether you need a new order for PostgreSQL 15 on SAS® Viya® 3.5 (Linux)."

Confirm your version of SAS Viya

If you are on a release of SAS Viya prior to SAS Viya 3.5, you must upgrade to SAS Viya 3.5 (Ship Event 23w44 or later) in order to obtain PostgreSQL 15. To upgrade to SAS Viya 3.5, contact SAS to obtain an updated software order for SAS Viya 3.5. Then, follow the directions in Upgrading Your SAS Viya Software to upgrade to SAS Viya 3.5 including the post-Viya upgrade steps for Upgrade to PostgreSQL Version 15.

If you are already on SAS Viya 3.5, proceed to the next check.

Check whether PostgreSQL 15 is already installed on your system

If SAS already installed PostgreSQL 15, it is located in one of the following locations depending on your operating system.

If the following folder exists on the system with your SAS Viya deployment, then PostgreSQL 15 is installed: C:\Program Files\SAS\Viya\lib\postgresql15\bin

If you do not have the postgresql15 location, you must upgrade to SAS Viya 3.5 (Ship Event 23w44 or later) in order to obtain PostgreSQL 15. To upgrade to SAS Viya 3.5, contact SAS to obtain an updated software order for SAS Viya 3.5. Then, follow the directions in Upgrading Your SAS Viya Software to upgrade to SAS Viya 3.5 including the post-Viya upgrade steps for Upgrade to PostgreSQL Version 15.

If you have the postgresql15 location, proceed to the next check.

Check whether your deployment is already running with PostgreSQL 15

It is possible to have PostgreSQL 15 installed but not in use with SAS® Viya®.  The following checks determine whether PostgreSQL 15 is in use by SAS Viya.

  1. As an administrator, open a PowerShell window.
  2. In the following directory, open the PG_VERSION file: C:\ProgramData\SAS\Viya\data\sasdatasvrc\postgres\node0.

If the version listed in the PG_VERSION file is 15, no further action is needed. 

If the version listed in the PG_VERSION file is earlier than 15, proceed to the next check.

Check for the latest MSIs

The latest MSIs must also be installed.  

Check the MSI name by changing to the following directory and issuing a dir command:

cd <SAS_VIYA_ROOT_HOME>/powershell-deployment\Downloads
dir

If you have sas-datasvrc15-15.4.0.0.msi, PostgreSQL 15 is installed but not yet configured. You should complete the post-Viya upgrade steps for Upgrade to PostgreSQL Version 15.

If you do not have the version of the file that is noted above, you must upgrade to SAS Viya 3.5 (Ship Event 23w44 or later) in order to obtain PostgreSQL 15. To upgrade to SAS Viya 3.5, contact SAS to obtain an updated software order for SAS Viya 3.5. Then, follow the directions in Upgrading Your SAS Viya Software to upgrade to SAS Viya 3.5 including the post-Viya upgrade steps for Upgrade to PostgreSQL Version 15.