What debugging features are available?
PostgreSQL has several features that report status information that can be valuable for debugging purposes. First, by running configure with the –enable-cassert option, many assert()s monitor the progress of the backend and halt the program when something unexpected occurs. Both postmaster and postgres have several debug options available.