Re: Postgresql Segfault in 8.1

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Benjamin Smith <lists(at)benjamindsmith(dot)com> writes:
> > What's the best way to do this? Take PG down (normally started as a service)
> > and run directly in a single-user mode?
>
> No, just start a psql session in one window, then in another window
> determine the PID of the backend process it's connected to, and attach
> gdb to that process. Something like
>
> ps auxww | grep postgres:
> ... eyeball determination of correct PID ...

You can also do 'select pg_backend_pid();' from psql... I know that's
there on 8.1, though I recall this was an 8.0 discussion and I *think*
it's there too but not 100% sure.

Enjoy,

Stephen