From: | Rick Otten <rottenwindfish(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: signal 11 segfaults with parallel workers |
Date: | 2017-07-28 00:54:31 |
Message-ID: | CAMAYy4+ek5FxjgE3K7aoWv4AD0x7RMoCFbb-D2Tq-4fhKYfKwQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I'm using the Ubuntu PostgresSQL 9.6.3 from this repo:
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main
It looks like there is a "-dbg" package available:
postgresql-9.6-dbg - debug symbols for postgresql-9.6
I'll give that a try when I get the restart opportunity.
On Thu, Jul 27, 2017 at 8:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Rick Otten <rottenwindfish(at)gmail(dot)com> writes:
> > Is enabling DEBUG in the postgresql.conf sufficient to enable debug
> symbols
> > in the core, or do I have to rebuild the postgresql binaries to get that?
>
> You would need to recompile (with --enable-debug added to configure
> switches) if they're not there already. But if you used somebody's
> packaging rather than a homebrew build, you can probably get the
> symbols installed without doing your own build.
>
> > Is the core of any use without debug symbols enabled?
>
> You should still be able to get a stack trace out of it, but the trace
> would be much more informative with debug symbols. See
> https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_
> a_running_PostgreSQL_backend_on_Linux/BSD
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2017-07-28 10:07:59 | Re: BUG #14758: Segfault with logical replication on a function index |
Previous Message | Tom Lane | 2017-07-28 00:48:24 | Re: signal 11 segfaults with parallel workers |