| From: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | Noah Misch <noah(at)leadboat(dot)com> |
| Cc: | hubert depesz lubaczewski <depesz(at)depesz(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Huge spikes in number of connections doing "PARSE" |
| Date: | 2011-03-12 00:16:00 |
| Message-ID: | AANLkTi=DUxGjSizQMiGR-vp7zufMiRnFH5n2C+zz=rDC@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 11, 2011 at 11:13 AM, Noah Misch <noah(at)leadboat(dot)com> wrote:
>
> gdb -ex=bt /path/to/bin/postgres $pid </dev/null
>
> I've used this on production systems to debug issues like this one, and
> I've
> never observed damage. The exact effect of debugger attach/detach may be
> OS/kernel-dependent, so it's hard to make categorical guarantees of safety.
At least on Windows NT and derivatives (until I last checked a few years
ago), detaching a debugger kills the debugged process.
Regards,
--
Gurjeet Singh
EnterpriseDB <http://www.enterprisedb.com/> Corporation
The Enterprise PostgreSQL <http://www.postgresql.org/> Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2011-03-12 04:29:48 | Re: how can I get back superuser back? |
| Previous Message | runner | 2011-03-11 23:09:40 | Re: How do you change the size of the WAL files? |