fix(engine): add mounting of socket directory for non guest virtualization roles (#385)

Description

Update the list of mounted volumes to include Postgres socket directory in case of non guest virtualization roles

Related issue

Closes: #385 (closed)

Examples

Checklist

• MR description has been reviewed
• MR changes are functionally tested
• MR does NOT have text changes OR there are text changes and they have been reviewed
• MR does NOT have API/CLI changes OR there are API/CLI changes and they have been reviewed
• MR does NOT have UI changes OR there are UI changes and they have been reviewed

Closes #385 (closed)