Re: (Never?) Kill Postmaster?

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.