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