We have migrated to new Google sites!
Post date: Oct 10, 2012 2:43:56 PM
GPstart: gpstate failed. (Reason='could not connect to server: Connection refused)
To resolve the issue use the gpstop -af command on the master server and make sure there are no more postgres processes running.
Then do a gpstart.
[gpadmin@mdw]$ gpstart
[gpadmin@mdw]$ gpstate
The system is now started with all segments restored.
If the gpstop -af command fails, you can kill the standby sync process on the smdw host.
[gpadmin@smdw]$ ps -ef |grep -i sync
root 4375 489 0 Nov22 ? 00:00:00 [xfssyncd]
gpadmin 15971 1 0 03:23 ? 00:00:00 /usr/local/greenplum-db/./bin/gpsyncmaster -D /data/master/gpseg-1 -p 5432 -b 98 -C -1 -z 48 -i
gpadmin 16147 16108 0 03:31 pts/0 00:00:00 grep -i sync
[gpadmin@smdw]$ kill -9 15971
[gpadmin@mdw]$ gpstart
[gpadmin@mdw]$ gpstop -r
[gpadmin@mdw]$ gprecoverseg
[gpadmin@mdw]$ gpstate