The issue I am having involves large data queries where the PostgreSQL database becomes faulted and will not restart on its own. In the past they have disabled and then reenabled the database to solve the issue. Is there a better way?
The right thing seems to be to allocate enough resources / optimize your queries such that they don't fault out your database. Though it's worth examining -
is it just the database connection faulting from something like too many open connections, or does your postgres actually crash?