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.