We've established a mount point for PostgreSQL, and during the creation of the dSource, we've encountered a situation where the permissions of PostgreSQL are being altered to root.
And this is the error we are getting in the Delphix Engine
Could you share the output of sudo -l -S for user postgres? I'd recommend opening a support case with Delphix Support for further log reviews.
Hello Vijayendra,This is the Output for the sudo -l -SThanks,
Can you please check your /etc/sudoers file and confirm that you have a similar configuration for the postgres user?
postgres ALL=NOPASSWD: /bin/mount,/bin/umount,/bin/mkdir,/bin/rmdir
The output above seems to imply that is not configured as we expect it: Postgres Sudo Requirements
You could also try to run sudo /bin/mount, sudo /bin/umount while logged as postgres to see if you get a prompt for the password.If you would like to raise a support case and attach a support bundle, we may be able to investigate this further for you.
The mount point (/mnt/provision) must be owned by the Delphix operating system user. It looks like our PostgreSQL documentation is missing that point so I will file a documentation bug.
Other datasets note this requirement ( target host requirements ):
There must be a directory (e.g. "/mnt/provision/" or "/mnt/staging/") that will be used as a container for the NFS mount points that are created when provisioning a VDB or linking a staging push dSource.
The delphix_os user and primary OS group (i.e. oinstall or dba) must own the directory.
The directory must have at least permissions -rwxrwx--- (0770).
There must be no symbolic links in the path of this directory, because NFS can mount into a directory with symlinks in its path, but cannot unmount.