Matt Gibbins <matt_gibbins@xxxxxxxxxxxxxxx> writes:Attached is the STDOUT messages showing the progress of the the process to segmentation fault.Not a lot of information there. Can you get a stack trace from the crash? https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend Also, if you're not on the latest minor version of PG 15, first update and see if that resolves the problem. regards, tom lane
This is the extent of information I am able to obtain at the
The Debian version Debian GNU/Linux 12 (bookworm)
The postgresql version installed is 15.4-2.pgdg120+1 which is
the latest from the distro.
Have enabled stack trace for postgresql. Noticed an interesting
problem with running the stack trace.
Of note my process is driven by remote execution of SQL queries
via SSH tunnel.
When I launch gdb for stack trace on the server the process hangs.