Revert "Changed connect to async use of libpq on non-Windows OSes"

This reverts commit 45ccff4be6bcc8e0f4d70efdaf23a5028a50588c.

lpsmith/postgresql-simple#119 workaround