Re: PostgreSQL 12 crash with segmentation violation

Alvaro Herrera <[email protected]> writes:
> On 2019-Nov-04, Marcel Ruff wrote:
>> Now I have upgraded to postgresql 12 and get a crash about once per day,
>> ...
>> How can I track down the problem?

> The first you need to do is obtain a crash dump.  This page may help:

> https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Getting_a_trace_from_a_reproducibly_crashing_backend

Also, as long as you're building from source anyway, you might pull down
v12 branch tip from our git repo, or use a nightly snapshot tarball [1]
to see if the problem's already fixed.

			regards, tom lane

[1] https://www.postgresql.org/ftp/snapshot/12/