Problem Note 65233: Failed Postgres nodes re-entering the cluster might take a long time to restore the data
 |  |  |  |  |
If a failover of the SAS® Infrastructure Data Server (PostgreSQL database) in SAS® Viya® 3.5 occurs, you must fix the issue with the node that went down before having it re-enter the cluster. After you fix the node and the node attempts to re-enter the cluster, the data could take a long time to restore.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
When you apply this hot fix, any SAS Infrastructure Data Server using PostgreSQL 11.5 or later uses the pg_rewind utility to synchronize the cluster with another copy. Using the PostgreSQL pg_rewind utility instead of the pg_basebackup utility that is used for PostgreSQL 9.4 decreases the time needed to restore the cluster.
You must set the following parameters to on in the postgresql.conf file:
Note: By default, they are set to on.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.5 | Viya | ||
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=softwareUpdatesWinViya 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| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-18 09:40:34 |
| Date Created: | 2019-12-10 12:57:27 |