Where the core files are generated in running postgres server

Started by M Tarkeshwar Raoover 11 years ago4 messagesgeneral
Jump to latest
#1M Tarkeshwar Rao
m.tarkeshwar.rao@ericsson.com

Hi all,

I want to know the exact path of the core files generated by Postgres server during crash?

Can I configure it or generate it?

Regards
Tarkeshwar

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Asif Naeem
anaeem.it@gmail.com
In reply to: M Tarkeshwar Rao (#1)
Re: Where the core files are generated in running postgres server

Hi Tarkeshwar,

If you are using Unix/Linux following link might be useful to you i.e.

https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Enabling_core_dumps

Regards,
Muhammad Asif Naeem

On Mon, Aug 4, 2014 at 3:19 PM, M Tarkeshwar Rao <
m.tarkeshwar.rao@ericsson.com> wrote:

Show quoted text

Hi all,

I want to know the exact path of the core files generated by Postgres
server during crash?

Can I configure it or generate it?

Regards
Tarkeshwar

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3M Tarkeshwar Rao
m.tarkeshwar.rao@ericsson.com
In reply to: Asif Naeem (#2)
Re: Where the core files are generated in running postgres server

Hi Asif,

Is it always creating core files on /var/lib/postgresql/8.4/main path for ubontu?
i.e. in data directory.

Regards
Tarkeshwar

From: Asif Naeem [mailto:anaeem.it@gmail.com]
Sent: 04 August 2014 16:01
To: M Tarkeshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where the core files are generated in running postgres server

Hi Tarkeshwar,

If you are using Unix/Linux following link might be useful to you i.e.

https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Enabling_core_dumps

Regards,
Muhammad Asif Naeem
On Mon, Aug 4, 2014 at 3:19 PM, M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com<mailto:m.tarkeshwar.rao@ericsson.com>> wrote:
Hi all,

I want to know the exact path of the core files generated by Postgres server during crash?

Can I configure it or generate it?

Regards
Tarkeshwar

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Michael Paquier
michael@paquier.xyz
In reply to: M Tarkeshwar Rao (#3)
Re: Where the core files are generated in running postgres server

On Mon, Aug 4, 2014 at 7:56 PM, M Tarkeshwar Rao
<m.tarkeshwar.rao@ericsson.com> wrote:

Is it always creating core files on /var/lib/postgresql/8.4/main path for
ubuntu?

I don't recall for ubuntu, but on Linux for sure you can see how a
core file is shaped by looking at /proc/sys/kernel/core_pattern. Just
noticing something... You should consider an upgrade to a newer
version. 8.4 has just become EOL.
Regards,
--
Michael

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general