How to fix gpssh when it is hanging?

posted Apr 28, 2017, 4:51 PM by Sachchida Ojha
The gpssh process is hanging and not providing an interactive shell. You will still can run commands like gpssh -f host_file uname, but you will not get a shell.

In this case the .bashrc file on the segment node is configured with some variables that interfere with this operation:

export PS1="[`whoami`@mdwt:$PGPORT:$PGDATABASE]$ "
export PROMPT_COMMAND='export PS1="[`whoami`@mdwt:$PGPORT:$PGDATABASE]$ "'

Remove the above variables and things should work properly.