Re: (Never?) Kill Postmaster? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: (Never?) Kill Postmaster?
Date
Msg-id 20071106235514.GL8635@alvh.no-ip.org
Whole thread Raw
In response to Re: (Never?) Kill Postmaster?  (Christian Schröder <cs@deriva.de>)
Responses Re: (Never?) Kill Postmaster?  (Christian Schröder <cs@deriva.de>)
List pgsql-general
Christian Schröder wrote:

> Since "ps -Lw" only showed me my own processes, I did "ps -AT -o
> pid,ppid,lwp,nlwp,command" instead. This is the relevant line:
>
>  PID  PPID   LWP NLWP COMMAND
> ...
> 7129  3934  7129    1 postgres: dpyrek uspi 88.70.241.205(10612) SELECT
> ...
>
> I'm not sure if this data is correct because NLWP (the number of threads in
> the process) is 1 for all processes.

Please try "thread apply all bt full" on gdb.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: subversion support?
Next
From: Alvaro Herrera
Date:
Subject: Re: Syntax error in a large COPY