Re: Postgres 8.4.20 seqfault on RHEL 6.4

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres 8.4.20 seqfault on RHEL 6.4
Date: 2015-02-13 05:25:32
Message-ID: CAAcYxUeyV_Zy2FJWqiA-35qO6sWideZ6BqCaQV0dxrBEJBvM_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Feb 12, 2015 at 7:35 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Dave Johansen <davejohansen(at)gmail(dot)com> writes:
> > Also, could this be caused by an issue or misuse of libpq/libpqxx in our
> > application? If so, is there someway that we could turn on some sort of
> > logging logging to see the queries or at least connections that we
> opening
> > when or just before the crash happened?
>
> A client should not be able to crash the server. (Ideally, anyway...)
>

That's what I figured, but wanted to check to be sure.

As for logging, log_statements = all ought to help, though it might be
> verbose.
>

Thankfully the crash is only happening on our development server and not
the operational one, so the traffic level isn't too high and logging all
the statements shouldn't be too insane.

Thanks,
Dave

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Михаил 2015-02-13 09:45:47 database role create date
Previous Message Tom Lane 2015-02-13 02:35:26 Re: Postgres 8.4.20 seqfault on RHEL 6.4