This article describes how Postgres can dump an live database consistantly. It's one of those problems that can seem fiendishly difficult if you approach it from the wrong direction.