From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: sujeet.chaurasia@lisec.com
Subject: BUG #17742: Postgres not generating the minidump after crash in Windows.
Date: Mon, 09 Jan 2023 10:41:30 +0000
Message-ID: <17742-2c2fabf8a5ee70d0@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17742
Logged by: Sujeet Chaurasia
Email address: sujeet.chaurasia@lisec.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, sujeet.chaurasia@lisec.com
Subject: Re: BUG #17742: Postgres not generating the minidump after crash in Windows.
In-Reply-To: <17742-2c2fabf8a5ee70d0@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox