Johann Spies <jspies(at)sun(dot)ac(dot)za> writes:
> * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [070514 16:36]:
>> $ gdb /path/to/postgres PID-of-backend
> Which pg-process? The Postmaster or psql? I have done this for the
> Postmaster now but
>> gdb> b errfinish
>> gdb> cont
>> ... wait for breakpoint to be hit ...
> This did not happen although the error occurred (after a few hours).
You got the wrong process then --- maybe the postmaster itself rather
than the backend assigned to your psql session? You can identify the
backend PID via pg_backend_pid() within the psql session of interest,
or look in pg_stat_activity.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-05-16 19:12:12|
|Subject: Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade |
|Previous:||From: Keaton Adams||Date: 2007-05-16 17:08:04|
|Subject: Re: WAL file utilization question|