Re: Help - corruption issue?

Dne 21.4.2011 07:16, Phoenix Kiula napsal(a):
> Tomas,
> 
> I did a crash log with the strace for PID of the index command as you
> suggested.
> 
> Here's the output:
> http://www.heypasteit.com/clip/WNR
> 
> Also including below, but because this will wrap etc, you can look at
> the link above.
> 
> Thanks for any ideas or pointers!
> 
> 
> 
> Process 15900 attached - interrupt to quit

Nope, that's the "psql" process - you need to attach to the backend
process that's created to handle the connection. Whenever you create a
connection (from a psql), a new backend process is forked to handle that
single connection - this is the process you need to strace.

You can either see that in 'ps ax' (the PID is usually +1 with respect
to the psql process), or you can do this

  SELECT pg_backend_pid();

as that will give you PID of the backend for the current connection.

regards
Tomas