The Pageant is a great venue and I have seen many good metal shows there. Unfortunately, St. Louis doesn't seem to get many metal shows anymore. Most of the tours skip St. Louis entirely and only hit Chicago. (Indy has the same problem.) I don't know of any good shows in St. Louis in August other than Rush on the 22nd.
03/22: Brit Floyd
04/06: Iced Earth