Forum OpenACS Q&A: Response to What does it take to get Postgresql database error detail in tracebacks?

Randy

If you watch your error log, you will notice that the more specific error comes before what is displayed in your browser as a traceback. For the type of error you are seeing, you might get very valuable information from this initial error message. Less valuable info will be obtained from a bug in a plpgsql procedure, and you will have to use the error log again to cut and paste the substituted query into psql

A simple way to follow errors without too much garbage flying by is:

$ tail -f your-server.log | grep -4 "rror" /dev/fd/0

Which should show a context of 4 lines before and after an error.