Remove JSON support due to psycopg2ct not supporting it, update tests

- Also don't perform the weakref cleanup test in pypy since it's not immediate in pypy