* Tom Lane (tgl@xxxxxxxxxxxxx) wrote: > Benjamin Smith <lists@xxxxxxxxxxxxxxxxxx> 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
Attachment:
signature.asc
Description: Digital signature
