Database Management for PostgreSQL

pgAdmin looks like a promising tool fro viewing and managing databases.
It might be helpful for debugging in the future