XRAY: How to overcome Postgres permission issue while installing Xray with bundled Postgres

While installing Xray along with the bundled Postgres, the Postgres installation may fail with Permission denied with the below error,

Error running /tmp/postgresql_installer_adc14a5600/prerun_checks.sh : /bin/sh: /tmp/postgresql_installer_adc14a5600/prerun_checks.sh: Permission denied

This error either says that the /tmp filesystem for Postgres misses the needed permissions otherwise the issue is with the mount point of the /tmp filesystem. If the latter is the case with mount point then the cause of the issue is that /tmp filesystem is not correctly mounted or mounted with "noexec" option.
To overcome the issue, we need to change the status of /tmp to EXEC flag in /etc/fstab as below,

/dev/mapper/vg_xxx_tmp	/tmp	ext4	nodev,nosuid,exec	1  2 (Added entry in fstab)