Error: "State 'postgres_user.present' was not found in SLS 'sse.eapi_database'" when upgrading PostgreSQL as part of VCF Salt / RaaS 8.18.3

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Following instructions as in TechDocs (VCF Salt 8.18) PostgreSQL: Migrate VCF Salt RaaS to a PostgreSQL 15.x database 

Step: salt <postgres_minion> state.sls sse.eapi_database

Errors seen in state:

• Comment: State 'postgres_user.present' was not found in SLS 'sse.eapi_database'
• Reason: 'postgres_user' _virtual_ returned False: Unable to load postgres module. Make sure `postgres.bins_dir` is set.

Environment

• VCF Salt / RaaS 8.x, upgrading to version 8.18.3
• Salt master / minion 3006.x versions below 3006.26

Cause

Python library dependencies are not ensured in all cases

Resolution

Upgrade Salt on master and minions to version 3006.26 or higher