rjbs helpfully unhorked the last SQL statement that postgres was bitching about, so gamesite.collaspar.net is alive once again, and now only jcn is still talking to mysql.
Actually though, there are some non-public portions of $gs which still need updating, so it's not quite complete yet. And jcn needs more fixing than just porting from one db to another, I think.