PostgreSQL notification listeners stop cleanly when a program ends

Active PostgreSQL notification listeners should stop and release their dedicated connections when the application run ends, including Stop, errors and Quit. If a notification handler fails while a buffer error is also queued, report the original handler exception.