Could not find home for relational data store binaries of the PostgreSQL directory

Error Message

Attempts to upgrade ArcGIS Data Store to the latest version fail and return the following error message:

Error:
Attempt to configure data store failed. Caused by: Database upgrade failed for relational data store. Caused by: Could not find home for relational data store binaries 'C:\arcgisdatastore\pgsql<PostgreSQL version number>'.

Cause

• In a high availability environment, the pgsql folder is only present on the ArcGIS Data Store standby machine and not on the primary machine.
• The pgsql folder is deleted in the arcgisdatastore folder.

Solution or Workaround

Copy the pgsql folder from the standby machine to the primary machine

1. Stop ArcGIS Data Store on both the standby machine and primary machine. Refer to Portal for ArcGIS: Change the status of a data store machine for information.
2. Open Windows File Explorer on the standby data store machine.
3. Navigate and open the standby data store machine’s arcgisdatastore folder. The folder is commonly located at:

C:\arcgisdatastore

4. Right-click the pgsql folder and select Copy.
5. Open Windows File Explorer on the primary data store machine.
6. Navigate and open the primary data store machine’s arcgisdatastore folder. The folder is commonly located at:

C:\arcgisdatastore

7. Right-click inside the folder and select Paste.
8. Restart the primary data store machine. Refer to Portal for ArcGIS: Change the status of a data store machine for information.
9. On the Windows taskbar, search for and select Task Manager.
10. In the Task Manager window, click on the Details tab.
11. Ensure the Status of the postgres.exe process is Running.

Copy the pgsql folder from a different folder location or from a backup

1. On the Windows taskbar, search for and select Task Manager.
2. In the Task Manager window, click Services.
3. Search for and select ArcGIS Data Store. Right-click ArcGIS Data Store and select Stop.
4. Navigate to the location the pgsql folder is located. The folder is commonly located at:

C:\arcgisdportal

5. Double-click the arcgisportal folder. Right-click on the pgsql folder and select Copy. 
6. Navigate to the data store machine’s arcgisdatastore folder. The folder is commonly located at:

C:\arcgisdatastore

7. Right-click inside the arcgisdatastore folder and select Paste.
8. On the Windows taskbar, search for and select Task Manager.
9. In the Task Manager window, click Services.
10. Search and select ArcGIS Data Store. Right-click ArcGIS Data Store and select Start.

Reinstall and import the data store backup

1. Uninstall ArcGIS Data Store. Refer to ArcGIS Enterprise: Uninstall with the user interface for instructions.
2. Navigate to the following folder location on the machine:

C:\Program Files\ArcGIS

3. Delete the DataStore folder.
4. Navigate to the C:\ drive of the machine, and delete the folder named arcgisdatastore.
5. Reinstall ArcGIS Data Store. Refer to ArcGIS Enterprise: Install ArcGIS Data Store for instructions.
6. Run the Windows Command Prompt as an administrator.
7. Navigate to the ArcGIS Data Store utilities folder using the following command:

cd <ArcGIS Data Store installation directory>\DataStore\tools

8. In the Command Prompt window, run the restoredatastore command utility to restore the data store backup data. Refer to Portal for ArcGIS: restoredatastore for more information.
9. When prompted with Do you wish to continue (Yes or No)?, type Yes, and press Enter.