Drop tables for postgres in the test suite

Rather than dropping and creating the database, drop tables, sequences and varchar_ci data type.

Doing so allows:

1. User running the tests no longer needs create database privilege.
2. Test database may be located in a non-default tablespace and generally have site-specific options applied to it.