postgresql自定义函数的调试

本文系转载他人文章
You should be able to attach gdb to a running postgresql backend- although you'll probably want to ensure your postgresql build has debugging symbols left in it to make that comprehensible. If you do select pg_backend_pid() you'll get the backend's process ID that you're dealing with, and can then attach gdb to it (using the --pid switch or attach command). This approach is only useful if you can reproduce the problem using psql, for example, though: having new backend processes automatically attached to be a gdb is... harder. For example, you can set options such as post_auth_delay to make postgresql wait after authentication has finished, giving you a chance to attach the debugger before it continues processing.