BUG #17742: Postgres not generating the minidump after crash in Windows.

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sujeet(dot)chaurasia(at)lisec(dot)com
Subject: BUG #17742: Postgres not generating the minidump after crash in Windows.
Date: 2023-01-09 10:41:30
Message-ID: 17742-2c2fabf8a5ee70d0@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17742
Logged by: Sujeet Chaurasia
Email address: sujeet(dot)chaurasia(at)lisec(dot)com
PostgreSQL version: 13.9
Operating system: Windows
Description:

I am trying to generate a minidump of the postgres.exe when it crashes. I
followed the postgres wiki, where it is stated that this function is already
included in the new version of postgres. Only the step is to create a
crashdumps folder and give it full permissions to it within the data
directory.

I am using postgres13, and the crash of my database is random, I can see the
log.

https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows

I followed the below part of the article.
** Create a directory named crashdumps (all lowercase) in the PostgreSQL
data directory (as shown by SHOW data_directory; in psql)
** Give the PostgreSQL user (postgres by default) "full control" of it in
the security tab of the folder properties.
** Run the problem code. You don't need to restart Pg or change any
settings.

When a backend crashes, a Windows minidump should be created in the
crashdumps directory. however, we are not getting it. on Google search, I
haven't found if anyone has yet tried it.

Browse pgsql-bugs by date

  From Date Subject
Next Message wangw.fnst@fujitsu.com 2023-01-09 12:29:45 RE: Logical Replica ReorderBuffer Size Accounting Issues
Previous Message PG Bug reporting form 2023-01-09 08:37:37 BUG #17741: vacuum process hangs after pg_surgery manipulations