Seems like you're going to have to kill -9. On Mon, 2 Jan 2006, Gregory S. Williamson wrote:
I tried su - postgres -c '/apps/pgsql-7.4/bin/pg_ctl stop -D /data/postgres/gex_runtime -m immediate' on one of the two hozed servers and that's (I think) what got this:
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
