How to fix gpssh when it is hanging?
Post date: Oct 05, 2012 10:56:19 PM
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.