Michael,
Thanks for the pointers - we use Linux so I had thought of just using ps - but I'll also look into the pg_stat_activity table and see what's in that ...
Thanks again.
On Mon, 2006-05-22 at 11:55 -0600, Michael Fuhr wrote:
On Mon, May 22, 2006 at 06:47:20PM +0100, Steve Tucknott wrote:
> Looks as though it may well do. I'll see if I can get the pid of the
> process and give it a go.
"SELECT * FROM pg_stat_activity" might be useful for obtaining the
pid, especially if you have stats_command_string enabled. On
Unix-like systems the output from "ps" might also be helpful.
Regards,
Steve Tucknott ReTSol Ltd
DDI: 01903 828769 Mobile: 0773 671 5772 |