vRealize Automation – postgres will not start

Error: You see the following message when trying to start postgres

UTCFATAL: Could not create lock file “/tmp/.s.PGSQL.5432.lock:” Not a directory

Resolution

Recreate /tmp and assign the proper permissions

mkdir /tmp
chmod 1777 /tmp