If you are using a cool season grass then I would wait until the soil temps reach 55*. That is optimal germination temps for cool season grasses.
The soil doesn't have to be dry to aerate. You would actually get better results if you do it the day after a good rain. That way you get good penetration into the soil, just don't do it if you have standing water in the lawn.
The falacy is that you need to seed in the fall. This is only a recommendation as you get proper temperatures and ample moisture to aid in germination.
I've had good luck seeding at any point of the growing season, just as long as you are willing to keep it watered sufficiently to get the grass established.