pg-retest: basically, the premise is pretty straightforward: capture (or read) PostgreSQL queries and build workloads/benchmarks using them, so you can replay them on dev/test or on a backup system. I have been doing this for a while and replay is always a pain.
Poke at it, beat it up, let me know.