Update pg_stat_activity call for pgsql 9.2

Also reorganize the source tree per pgxn recommendations.