Ruined
Explorer
It's kind of world-specific, but you might want to check out 'Relics & Rituals II' for Scarred Lands. They have all of the astrological signs and their relevance laid out. Also, there is a prestige class for scholarly types who work their magics in conjunction with the stars (High Astrologer, I believe).
IIRC, there are also feats you can take that give you an ability based on your birth month. Unfortunately, I don't have the book with me here at work.
Worth checking out, even if you run your own setting. If nothing else, great material to steal from.
IIRC, there are also feats you can take that give you an ability based on your birth month. Unfortunately, I don't have the book with me here at work.

Worth checking out, even if you run your own setting. If nothing else, great material to steal from.