Pivotal Greenplum Database (GPDB)
Connecting to host via gpssh encounters the below warning message
[gpadmin@mdw faisal]$ gpssh -f hosts [WARN] Unable to write to gpssh history file: '/home/gpadmin/testing_via_root/.gshist'. Please check permissions. =>
When gpssh is executed it attempts to read or create a .gshist file on that server where the gpssh command was executed, at the directory defined by the OS environment parameter $HOME.
.gshist file is used by the gpssh to gather the previous command history that was executed under gpssh prompt.
- Make sure the permission on the directory defined by $HOME is readable / writeable by the user that executed the gpssh command
- OR Change the $HOME environment parameter to some other directory where the user can read/write.
export HOME=/tmp gpssh -f <hostfile>